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);
}
