private void UpdateAssetTable() { List <Asset> empAsset = new List <Asset>(); Save_NewMembers saveEmp = new Save_NewMembers(); int staId, locId; using (AccetManagementEntities db = new AccetManagementEntities()) { var statusId = db.STATUS.Where(c => c.STATUSNAME == cmbStatus.Text).OrderBy(c => c.STATUSNAME).Select(c => c.STATUSID).ToList(); var LocationId = db.LOCATIONs.Where(c => c.LOCATIONNAME == cmbLocation.Text).OrderBy(c => c.LOCATIONID).Select(c => c.LOCATIONID).ToList(); // UPDATE ASSETS TABLE staId = statusId[0]; locId = LocationId[0]; empAsset.Add(new Asset() { AssetNo = this.dgvCheckin.CurrentRow.Cells[0].Value.ToString(), Comment = richTextBoxComent.Text.ToString().Trim(), EmpName = "", CheckoinDate = DateTime.Now, StatusId = statusId[0], LocationId = LocationId[0], EmpId = "" }); } saveEmp.CheckinUpdate(empAsset); }
private void UpdateAssetTable() { List <Asset> empAsset = new List <Asset>(); Save_NewMembers saveEmp = new Save_NewMembers(); empAsset.Add(new Asset() { AssetNo = this.dgvItemsCheckedOut.CurrentRow.Cells[1].Value.ToString(), Comment = rctComment.Text.ToString().Trim(), EmpName = cmbCheckout.Text.ToString().Trim(), CheckoutDate = DateTime.Now, StatusId = staId, LocationId = locId, EmpId = CommonData.PersonalNumber }); saveEmp.UpdateAssetTable(empAsset); }