Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DAL dal = new DAL();
- string SQL = @"INSERT INTO Assets ([AssetName],[AssetType],[Model],[Description],
- [PurchaseValue],[SalvageValue],[Currency],[DateAcquired,[DateRetire],[ImagePath],
- [InUse])
- VALUES (?,?,?,?,?,?,?,?,?,?,?)";
- OleDbParameter[] par = new OleDbParameter[]{
- new OleDbParameter("@assetname",name.Text),
- new OleDbParameter("@assettype",assettypes.SelectedValue.ToString()),
- new OleDbParameter("@model",model.Text),
- new OleDbParameter("@description",description.Text),
- new OleDbParameter("@purchasevalue",purchaseval.Value),
- new OleDbParameter("@salvagevalue",salvageval.Value),
- new OleDbParameter("@currency",currencies.SelectedIndex),
- new OleDbParameter("@dateacquired",purchasedate.Value),
- new OleDbParameter("@dateretire",purchasedate.Value.AddYears((int)lifetime.Value)),
- new OleDbParameter("@imagepath","N/A"),
- new OleDbParameter("@addedby",MDIParent1.User.ID)
- };
- new OleDbParameter("@assetname",name.Text),
- new OleDbParameter("@assettype",assettypes.SelectedValue.ToString()),
- new OleDbParameter("@model",model.Text),
- new OleDbParameter("@description",description.Text),
- new OleDbParameter("@purchasevalue",purchaseval.Value),
- new OleDbParameter("@salvagevalue",salvageval.Value),
- new OleDbParameter("@currency",currencies.SelectedIndex),
- new OleDbParameter("@dateacquired",purchasedate.Value),
- new OleDbParameter("@dateretire",purchasedate.Value.AddYears((int)lifetime.Value)),
- new OleDbParameter("@imagepath","N/A"),
- new OleDbParameter("@addedby",MDIParent1.User.ID)
- DAL dal = new DAL();
- DAL _dal = new DAL();
- DAL dataAccessLayer = new DAL();
Add Comment
Please, Sign In to add comment