public ActionResult ChucvuList_Save() { AjaxStoreResult ajaxStoreResult = new AjaxStoreResult(StoreResponseFormat.Save); try { QLVBEntities db = this.DBContext; StoreDataHandler dataHandler = new StoreDataHandler(HttpContext.Request["data"]); ChangeRecords <DMCHUCVU> data = dataHandler.ObjectData <DMCHUCVU>(); ConfirmationList confirmationList = dataHandler.BuildConfirmationList("MACHUCVU"); foreach (DMCHUCVU c in data.Deleted) { db.DMCHUCVUs.Attach(c); db.DMCHUCVUs.DeleteObject(c); } foreach (DMCHUCVU c in data.Created) { db.DMCHUCVUs.AddObject(c); } foreach (DMCHUCVU c in data.Updated) { var orgRecord = db.DMCHUCVUs.Single(p => p.MACHUCVU == c.MACHUCVU); db.DMCHUCVUs.ApplyCurrentValues(c); } db.SaveChanges(); } catch (Exception e) { ajaxStoreResult.SaveResponse.Success = false; int nCode = System.Runtime.InteropServices.Marshal.GetHRForException(e); if (nCode == -2146233087) { ajaxStoreResult.SaveResponse.Message = "Trùng mã chức năng."; } else { ajaxStoreResult.SaveResponse.Message = e.InnerException.Message; } } return(ajaxStoreResult); }
protected int GetNewDanhmucID() { QLVBEntities db = this.DBContext; if (db.Connection.State == System.Data.ConnectionState.Closed) { db.Connection.Open(); } ObjectResult <int?> n = db.GetNewSeqVal("Danhmuc_seq"); foreach (int i in n) { return(i); } return(0); }
public BaseController() { string connectionString = ""; System.Configuration.Configuration rootWebConfig = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/"); try { if (rootWebConfig.ConnectionStrings.ConnectionStrings.Count > 0) { connectionString = rootWebConfig.ConnectionStrings.ConnectionStrings["QLVBEntities"].ConnectionString; } } catch { } _db = new QLVBEntities(connectionString); }
public ActionResult SoVanbanList_Save() { AjaxStoreResult ajaxStoreResult = new AjaxStoreResult(StoreResponseFormat.Save); try { QLVBEntities db = this.DBContext; StoreDataHandler dataHandler = new StoreDataHandler(HttpContext.Request["data"]); ChangeRecords <DMSOVB> data = dataHandler.ObjectData <DMSOVB>(); foreach (DMSOVB c in data.Deleted) { db.DMSOVBs.Attach(c); db.DMSOVBs.DeleteObject(c); } foreach (DMSOVB c in data.Created) { c.IDSOVB = GetNewDanhmucID(); db.DMSOVBs.AddObject(c); } foreach (DMSOVB c in data.Updated) { var orgRecord = db.DMSOVBs.Single(p => p.IDSOVB == c.IDSOVB); db.DMSOVBs.ApplyCurrentValues(c); } db.SaveChanges(); } catch (Exception e) { ajaxStoreResult.SaveResponse.Success = false; int nCode = System.Runtime.InteropServices.Marshal.GetHRForException(e); ajaxStoreResult.SaveResponse.Message = e.InnerException.Message; } return(ajaxStoreResult); }
public ActionResult NhanvienList_Save() { string sMaNhanvien; int nNhanvienID; AjaxStoreResult ajaxStoreResult = new AjaxStoreResult(StoreResponseFormat.Save); try { QLVBEntities db = this.DBContext; StoreDataHandler dataHandler = new StoreDataHandler(HttpContext.Request["data"]); ChangeRecords <DMNHANVIEN> data = dataHandler.ObjectData <DMNHANVIEN>(); var qrChucvu = from cn in db.DMCHUCVUs.Where(cn => cn.MACHUCNANG != "01" && cn.MACHUCNANG != "02") select cn; foreach (DMNHANVIEN c in data.Deleted) { db.DMNHANVIENs.Attach(c); db.DMNHANVIENs.DeleteObject(c); } foreach (DMNHANVIEN c in data.Created) { if (IsUserNameExist(c.USERNAME)) { throw new Exception("Tên đăng nhập đã được sử dụng " + c.TEN + "(" + c.USERNAME + ")"); } if (qrChucvu.Any(p => p.MACHUCVU == c.CHUCVU) && c.MAPHONG.Length == 0) { throw new Exception("Chưa chọn phòng cho nhân viên " + c.TEN); } nNhanvienID = GetNewNhanvienID(); string s = c.MAPHONG; if (s.Length == 0) { s = "00"; } sMaNhanvien = s + nNhanvienID.ToString("D6"); c.MANV = sMaNhanvien; db.DMNHANVIENs.AddObject(c); } foreach (DMNHANVIEN c in data.Updated) { if (qrChucvu.Any(p => p.MACHUCVU == c.CHUCVU) && c.MAPHONG.Length == 0) { throw new Exception("Chưa chọn phòng cho nhân viên " + c.TEN); } var orgRecord = db.DMNHANVIENs.Single(p => p.MANV == c.MANV); //string sCurMaNV = c.MANV; //sCurMaNV = sCurMaNV.Substring(2); //sCurMaNV = c.MAPHONG + sCurMaNV; db.DMNHANVIENs.ApplyCurrentValues(c); } db.SaveChanges(); } catch (Exception e) { ajaxStoreResult.SaveResponse.Success = false; int nCode = System.Runtime.InteropServices.Marshal.GetHRForException(e); if (e.InnerException != null) { ajaxStoreResult.SaveResponse.Message = e.InnerException.Message; } else { ajaxStoreResult.SaveResponse.Message = e.Message; } } return(ajaxStoreResult); }