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