protected void grvNgach_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
Hashtable values = new Hashtable();
item.ExtractValues(values);
switch (e.Item.OwnerTableView.Name)
{
case "tbl_Ngach":
Ngach ngach = new Ngach();
ngach.NgayTao = ngach.NgayCapNhat = DateTime.Now;
ngach.NguoiTao = ngach.NguoiCapNhat = idNhanVien;
item.UpdateValues(ngach);
_entities.AddToNgaches(ngach);
_entities.SaveChanges();
break;
case "tbl_BacNgach":
BacNgach bacngach = new BacNgach();
item.UpdateValues(bacngach);
GridDataItem parentItem = e.Item.OwnerTableView.ParentItem;
if (parentItem != null)
{
var idNgach = parentItem.OwnerTableView.DataKeyValues[parentItem.ItemIndex]["IDNgach"].ToString();
bacngach.IDNgach = Convert.ToInt32(idNgach);
bacngach.NgayTao = bacngach.NgayCapNhat = DateTime.Now;
bacngach.NguoiTao = bacngach.NguoiCapNhat = idNhanVien;
_entities.AddToBacNgaches(bacngach);
_entities.SaveChanges();
}
break;
}
}
protected void grvNgach_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
switch (e.Item.OwnerTableView.Name)
{
case "tbl_Ngach":
var iDNgach = Convert.ToInt32(item.GetDataKeyValue("IDNgach").ToString());
Ngach ngach = _entities.Ngaches.Where(d => d.IDNgach == iDNgach).First();
ngach.NgayCapNhat = DateTime.Now;
ngach.NguoiCapNhat = idNhanVien;
item.UpdateValues(ngach);
_entities.SaveChanges();
break;
case "tbl_BacNgach":
var iDBacNgach = Convert.ToInt32(item.GetDataKeyValue("IDBacNgach").ToString());
BacNgach bacngach = _entities.BacNgaches.Where(d => d.IDBacNgach == iDBacNgach).First();
bacngach.NgayCapNhat = DateTime.Now;
bacngach.NguoiCapNhat = idNhanVien;
item.UpdateValues(bacngach);
_entities.SaveChanges();
break;
}
}
protected void grvNgach_DeleteCommand(object sender, GridCommandEventArgs e)
{
switch (e.Item.OwnerTableView.Name)
{
case "tbl_Ngach":
var iDNgach = (e.Item as GridDataItem).GetDataKeyValue("IDNgach").ToString();
int idn = Convert.ToInt32(iDNgach);
_entities.DeleteBacNgachByIDNgach(idn);
_entities.SaveChanges();
break;
case "tbl_BacNgach":
var iDBacNgach = (e.Item as GridDataItem).GetDataKeyValue("IDBacNgach").ToString();
int idbn = Convert.ToInt32(iDBacNgach);
BacNgach bacngach = _entities.BacNgaches.Where(d => d.IDBacNgach == idbn).First();
_entities.BacNgaches.DeleteObject(bacngach);
_entities.SaveChanges();
break;
}
}
