protected void grvNhomChucDanh_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_NhomChucDanh":
NhomChucDanh nhomchucdanh = new NhomChucDanh();
nhomchucdanh.NgayTao = nhomchucdanh.NgayCapNhat = DateTime.Now;
nhomchucdanh.NguoiTao = nhomchucdanh.NguoiCapNhat = idNhanVien;
item.UpdateValues(nhomchucdanh);
_entities.AddToNhomChucDanhs(nhomchucdanh);
_entities.SaveChanges();
break;
case "tbl_ChucDanhChuyenMon":
ChucDanh chucdanh = new ChucDanh();
item.UpdateValues(chucdanh);
GridDataItem parentItem = e.Item.OwnerTableView.ParentItem;
if (parentItem != null)
{
var idNhomChucDanh = parentItem.OwnerTableView.DataKeyValues[parentItem.ItemIndex]["IDNhomChucDanh"].ToString();
chucdanh.IDNhomChucDanh = Convert.ToInt32(idNhomChucDanh);
chucdanh.NgayTao = chucdanh.NgayCapNhat = DateTime.Now;
chucdanh.NguoiTao = chucdanh.NguoiCapNhat = idNhanVien;
_entities.AddToChucDanhs(chucdanh);
_entities.SaveChanges();
}
break;
}
}
protected void grvNhomChucDanh_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
switch (e.Item.OwnerTableView.Name)
{
case "tbl_NhomChucDanh":
var iDNhomChucDanh = Convert.ToInt32(item.GetDataKeyValue("IDNhomChucDanh").ToString());
NhomChucDanh nhomchucdanh = _entities.NhomChucDanhs.Where(d => d.IDNhomChucDanh == iDNhomChucDanh).First();
nhomchucdanh.NgayCapNhat = DateTime.Now;
nhomchucdanh.NguoiCapNhat = idNhanVien;
item.UpdateValues(nhomchucdanh);
_entities.SaveChanges();
break;
case "tbl_ChucDanhChuyenMon":
var iDChucDanhChuyenMon = Convert.ToInt32(item.GetDataKeyValue("IDChucDanh").ToString());
ChucDanh chucdanh = _entities.ChucDanhs.Where(d => d.IDChucDanh == iDChucDanhChuyenMon).First();
chucdanh.NgayCapNhat = DateTime.Now;
chucdanh.NguoiCapNhat = idNhanVien;
item.UpdateValues(chucdanh);
_entities.SaveChanges();
break;
}
}
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 grvChucDanhCongViec_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
var iD = Convert.ToInt32(item.GetDataKeyValue("IDChucDanhCongViec").ToString());
ChucDanhCongViec obj = _entities.ChucDanhCongViecs.Where(o => o.IDChucDanhCongViec == iD).First();
obj.NgayCapNhat = DateTime.Now;
obj.NguoiCapNhat = idNhanVien;
item.UpdateValues(obj);
_entities.SaveChanges();
}
protected void grvQHNhanThan_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
int id = Convert.ToInt32(item.GetDataKeyValue("IDQuanHe").ToString());
QuanHe tt = _entities.QuanHes.Where(d => d.IDQuanHe == id).First();
tt.NgayCapNhat = DateTime.Now;
tt.NguoiCapNhat = idNhanVien;
item.UpdateValues(tt);
_entities.SaveChanges();
}
protected void grvDonViDT_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
var id = Convert.ToInt32(item.GetDataKeyValue("IDNoiCapBang").ToString());
NoiCapBang obj = _entities.NoiCapBangs.Where(o => o.IDNoiCapBang == id).First();
obj.NgayCapNhat = DateTime.Now;
obj.NguoiCapNhat = idNhanVien;
item.UpdateValues(obj);
_entities.SaveChanges();
}
protected void grvQuocTich_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
var iDQuocTich = Convert.ToInt32(item.GetDataKeyValue("IDQuocTich").ToString());
QuocTich qt = _entities.QuocTiches.Where(q => q.IDQuocTich == iDQuocTich).First();
qt.NgayCapNhat = DateTime.Now;
qt.NguoiCapNhat = idNhanVien;
item.UpdateValues(qt);
_entities.SaveChanges();
}
protected void grvLoaiNghi_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
var iD = Convert.ToInt32(item.GetDataKeyValue("IDLoaiNghi").ToString());
LoaiNghi ln = _entities.LoaiNghis.Where(l => l.IDLoaiNghi == iD).First();
ln.NgayCapNhat = DateTime.Now;
ln.NguoiCapNhat = idNhanVien;
item.UpdateValues(ln);
_entities.SaveChanges();
}
protected void grvDanTocs_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
var iDDanToc = Convert.ToInt32(item.GetDataKeyValue("IDDanToc").ToString());
DanToc dt = _entities.DanTocs.Where(d => d.IDDanToc == iDDanToc).First();
dt.NguoiCapNhat = idNhanVien;
dt.NgayCapNhat = DateTime.Now;
item.UpdateValues(dt);
_entities.SaveChanges();
}
protected void grvTonGiao_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
var iDTonGiao = Convert.ToInt32(item.GetDataKeyValue("IDTonGiao").ToString());
TonGiao tg = _entities.TonGiaos.Where(t => t.IDTonGiao == iDTonGiao).First();
tg.NgayCapNhat = DateTime.Now;
tg.NguoiCapNhat = idNhanVien;
item.UpdateValues(tg);
_entities.SaveChanges();
}
protected void grvLoaiHinhDT_UpdateCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
var iDLoaiHinh = item.GetDataKeyValue("IDLoaiHinh").ToString();
int id = Convert.ToInt32(iDLoaiHinh);
LoaiHinhDT lh = _entities.LoaiHinhDTs.Where(l => l.IDLoaiHinh == id).First();
lh.NgayCapNhat = DateTime.Now;
lh.NguoiCapNhat = idNhanVien;
item.UpdateValues(lh);
_entities.SaveChanges();
}
protected void grvChucDanhCongViec_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
Hashtable values = new Hashtable();
item.ExtractValues(values);
ChucDanhCongViec obj = new ChucDanhCongViec();
obj.NgayTao = obj.NgayCapNhat = DateTime.Now;
obj.NguoiTao = obj.NguoiCapNhat = idNhanVien;
item.UpdateValues(obj);
_entities.AddToChucDanhCongViecs(obj);
_entities.SaveChanges();
}
protected void grvQHNhanThan_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
Hashtable values = new Hashtable();
item.ExtractValues(values);
QuanHe tt = new QuanHe();
tt.NgayTao = tt.NgayCapNhat = DateTime.Now;
tt.NguoiTao = tt.NguoiCapNhat = idNhanVien;
item.UpdateValues(tt);
_entities.AddToQuanHes(tt);
_entities.SaveChanges();
}
protected void grvTonGiao_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
Hashtable values = new Hashtable();
item.ExtractValues(values);
TonGiao tg = new TonGiao();
tg.NgayTao = tg.NgayCapNhat = DateTime.Now;
tg.NguoiTao = tg.NguoiCapNhat = idNhanVien;
item.UpdateValues(tg);
_entities.AddToTonGiaos(tg);
_entities.SaveChanges();
}
protected void grvDanTocs_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
Hashtable values = new Hashtable();
item.ExtractValues(values);
DanToc dt = new DanToc();
dt.NguoiTao = dt.NguoiCapNhat = idNhanVien;
dt.NgayTao = dt.NgayCapNhat = DateTime.Now;
item.UpdateValues(dt);
_entities.AddToDanTocs(dt);
_entities.SaveChanges();
}
protected void grvLoaiHinhDT_InsertCommand(object sender, GridCommandEventArgs e)
{
GridEditableItem item = e.Item as GridEditableItem;
Hashtable values = new Hashtable();
item.ExtractValues(values);
LoaiHinhDT lh = new LoaiHinhDT();
lh.NgayTao = lh.NgayCapNhat = DateTime.Now;
lh.NguoiTao = lh.NguoiCapNhat = idNhanVien;
item.UpdateValues(lh);
_entities.AddToLoaiHinhDTs(lh);
_entities.SaveChanges();
}
public static void UpdateTouristFromList(List<TouristInfo> lstTourists, int intTerritoryID, GridEditableItem editableItem)
{
var intTouristId = (int)editableItem.GetDataKeyValue("PolTuristiSaraksts");
var itemTourist = lstTourists.Where(n => n.PolTuristiSaraksts == intTouristId).FirstOrDefault();
if (itemTourist != null)
{
editableItem.UpdateValues(itemTourist);
itemTourist.Apstaklis = ((RadComboBox)editableItem.FindControl("ddlApstaklis")).Text;
itemTourist.Apstaklis_ID = Convert.ToInt32(((RadComboBox)editableItem.FindControl("ddlApstaklis")).SelectedValue);
itemTourist.IsResident = ((CheckBox)editableItem.FindControl("chkResidents")).Checked;
if (itemTourist.IsResident)
{
itemTourist.DzDatums = null;
}
else
{
itemTourist.PersKods = string.Empty;
}
}
}