public static DTO_PRO_SYLL update_PRO_SYLL(AppEntities db, DTO_PRO_SYLL item, string Username)
{
var dbitem = db.tbl_PRO_SYLL.Find(item.ID);
if (dbitem == null)
{
dbitem = new tbl_PRO_SYLL();
dbitem.CreatedBy = Username;
dbitem.CreatedDate = DateTime.Now;
dbitem.IDDetai = item.IDDetai;
dbitem.IDNhanSu = item.IDNhanSu;
db.tbl_PRO_SYLL.Add(dbitem);
}
var objHRM_SYLL = db.tbl_CUS_HRM_STAFF_NhanSu_SYLL.FirstOrDefault(c => c.IDNhanSu == item.IDNhanSu);
if (objHRM_SYLL != null)
{
int id = dbitem.ID;
CopyHelper copyHelper = new CopyHelper();
copyHelper.Copy(objHRM_SYLL, dbitem);
dbitem.ID = id;
}
dbitem.IDDetai = item.IDDetai;
dbitem.IDNhanSu = item.IDNhanSu;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
var detai = db.tbl_PRO_DeTai.FirstOrDefault(c => c.ID == dbitem.IDDetai);
if (detai != null)
{
if (detai.IDNCV == dbitem.IDNhanSu)
{
BS_HelperReference.PRO_SYLL_NCV_Update(db, dbitem.IDDetai, dbitem.IDNhanSu);
}
}
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_SYLL", DateTime.Now, Username);
item.ID = dbitem.ID;
item.CreatedBy = dbitem.CreatedBy;
item.CreatedDate = dbitem.CreatedDate;
item.ModifiedBy = dbitem.ModifiedBy;
item.ModifiedDate = dbitem.ModifiedDate;
return(item);
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("save_PRO_SYLL", e);
return(null);
}
}
public IHttpActionResult Get(int id)
{
DTO_PRO_SYLL tbl_PRO_SYLL = BS_PRO_SYLL.get_PRO_SYLL(db, id);
if (tbl_PRO_SYLL == null)
{
return(NotFound());
}
return(Ok(tbl_PRO_SYLL));
}
public static bool put_PRO_SYLL(AppEntities db, int ID, DTO_PRO_SYLL item, string Username)
{
bool result = false;
var dbitem = db.tbl_PRO_SYLL.Find(ID);
if (dbitem != null)
{
dbitem.IDDetai = item.IDDetai;
dbitem.IDNhanSu = item.IDNhanSu;
dbitem.HoTen = item.HoTen;
dbitem.GioiTinh = item.GioiTinh;
dbitem.NgaySinh = item.NgaySinh;
dbitem.DiaChi = item.DiaChi;
dbitem.DienThoaiCQ = item.DienThoaiCQ;
dbitem.Mobile = item.Mobile;
dbitem.Email = item.Email;
dbitem.ChucVu = item.ChucVu;
dbitem.CoQuanLamViec = item.CoQuanLamViec;
dbitem.ThuTruongCoQuan = item.ThuTruongCoQuan;
dbitem.DienThoaiThuTruong = item.DienThoaiThuTruong;
dbitem.DiaChiCoQuan = item.DiaChiCoQuan;
dbitem.JSON_TrinhDoChuyenMon = item.JSON_TrinhDoChuyenMon;
dbitem.JSON_KinhNghiem = item.JSON_KinhNghiem;
dbitem.HTML = item.HTML;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.JSON_HocVi = item.JSON_HocVi;
dbitem.NgayKy_Ngay = item.NgayKy_Ngay;
dbitem.NgayKy_Thang = item.NgayKy_Thang;
dbitem.NgayKy_Nam = item.NgayKy_Nam;
dbitem.NgayKy_ChuKy = item.NgayKy_ChuKy;
dbitem.DienThoaiNhaRieng = item.DienThoaiNhaRieng;
dbitem.FormConfig = item.FormConfig;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_SYLL", DateTime.Now, Username);
result = true;
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("put_PRO_SYLL", e);
result = false;
}
}
return(result);
}
public IHttpActionResult Save(DTO_PRO_SYLL tbl_PRO_SYLL)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DTO_PRO_SYLL result = BS_PRO_SYLL.save_PRO_SYLL(db, tbl_PRO_SYLL, Username);
if (result != null)
{
return(Ok(result));
}
return(BadRequest());
}
public IHttpActionResult Post(DTO_PRO_SYLL tbl_PRO_SYLL)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
DTO_PRO_SYLL result = BS_PRO_SYLL.post_PRO_SYLL(db, tbl_PRO_SYLL, Username);
if (result != null)
{
return(CreatedAtRoute("get_PRO_SYLL", new { id = result.ID }, result));
}
return(Conflict());
}
public IHttpActionResult GetCustom(int idDeTai, int idNhanSu, bool isChuNhiem, bool?isInput = false)
{
DTO_PRO_SYLL tbl_PRO_SYLL = BS_PRO_SYLL.get_PRO_SYLLCustom(db, idDeTai, idNhanSu);
//if (tbl_PRO_LLKH.ID == 0)
//{
string html = "";
string htmlPrint = "";
if (isChuNhiem)
{
using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/NhanSuSYLL_ChuNhiemDeTai.html")))
{
htmlPrint = r.ReadToEnd();
}
}
else
{
using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/NhanSuSYLL.html")))
{
htmlPrint = r.ReadToEnd();
}
}
if (isChuNhiem)
{
using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/NhanSuSYLL_ChuNhiemDeTai_Input.html")))
{
html = r.ReadToEnd();
}
}
else
{
using (System.IO.StreamReader r = new System.IO.StreamReader(System.Web.Hosting.HostingEnvironment.MapPath("~/Content/FormTemplate/NhanSuSYLL_Input.html")))
{
html = r.ReadToEnd();
}
}
tbl_PRO_SYLL.HTML = html;
tbl_PRO_SYLL.HTMLPrint = htmlPrint;
//}
return(Ok(tbl_PRO_SYLL));
}
public IHttpActionResult Put(int id, DTO_PRO_SYLL tbl_PRO_SYLL)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tbl_PRO_SYLL.ID)
{
return(BadRequest());
}
bool result = BS_PRO_SYLL.put_PRO_SYLL(db, id, tbl_PRO_SYLL, Username);
if (result)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
return(NotFound());
}
}
public static DTO_PRO_SYLL save_PRO_SYLL(AppEntities db, DTO_PRO_SYLL item, string Username)
{
var dbitem = db.tbl_PRO_SYLL.Find(item.ID);
if (dbitem == null)
{
dbitem = new tbl_PRO_SYLL();
dbitem.CreatedBy = Username;
dbitem.CreatedDate = DateTime.Now;
db.tbl_PRO_SYLL.Add(dbitem);
}
dbitem.IDDetai = item.IDDetai;
dbitem.IDNhanSu = item.IDNhanSu;
dbitem.HoTen = item.HoTen;
dbitem.GioiTinh = item.GioiTinh;
dbitem.NgaySinh = item.NgaySinh;
dbitem.DiaChi = item.DiaChi;
dbitem.DienThoaiCQ = item.DienThoaiCQ;
dbitem.DienThoaiNhaRieng = item.DienThoaiNhaRieng;
dbitem.Mobile = item.Mobile;
dbitem.Email = item.Email;
dbitem.ChucVu = item.ChucVu;
dbitem.CoQuanLamViec = item.CoQuanLamViec;
dbitem.ThuTruongCoQuan = item.ThuTruongCoQuan;
dbitem.DienThoaiThuTruong = item.DienThoaiThuTruong;
dbitem.DiaChiCoQuan = item.DiaChiCoQuan;
dbitem.NgayKy_ChuKy = item.NgayKy_ChuKy;
dbitem.NgayKy_Nam = item.NgayKy_Nam;
dbitem.NgayKy_Ngay = item.NgayKy_Ngay;
dbitem.NgayKy_Thang = item.NgayKy_Thang;
if (item.ListKinhNghiem != null)
{
dbitem.JSON_KinhNghiem = JsonConvert.SerializeObject(item.ListKinhNghiem);
}
else
{
dbitem.JSON_KinhNghiem = string.Empty;
}
if (item.ListTrinhDoChuyenMon != null)
{
dbitem.JSON_TrinhDoChuyenMon = JsonConvert.SerializeObject(item.ListTrinhDoChuyenMon);
}
else
{
dbitem.JSON_TrinhDoChuyenMon = string.Empty;
}
dbitem.FormConfig = item.FormConfig;
dbitem.HTML = item.HTML;
dbitem.IsDisabled = item.IsDisabled;
dbitem.IsDeleted = item.IsDeleted;
dbitem.ModifiedBy = Username;
dbitem.ModifiedDate = DateTime.Now;
try
{
db.SaveChanges();
BS_CUS_Version.update_CUS_Version(db, null, "DTO_PRO_SYLL", DateTime.Now, Username);
var detai = db.tbl_PRO_DeTai.FirstOrDefault(c => c.ID == dbitem.IDDetai);
if (detai != null)
{
if (detai.IDNCV == dbitem.IDNhanSu)
{
BS_HelperReference.PRO_SYLL_NCV_Update(db, dbitem.IDDetai, dbitem.IDNhanSu);
}
}
item.ID = dbitem.ID;
item.CreatedBy = dbitem.CreatedBy;
item.CreatedDate = dbitem.CreatedDate;
item.ModifiedBy = dbitem.ModifiedBy;
item.ModifiedDate = dbitem.ModifiedDate;
return(item);
}
catch (DbEntityValidationException e)
{
errorLog.logMessage("save_PRO_SYLL", e);
return(null);
}
}
public static DTO_PRO_SYLL get_PRO_SYLLCustom(AppEntities db, int idDeTai, int nhanSuId)
{
var query = db.tbl_PRO_SYLL.Where(d => d.IDDetai == idDeTai && d.IDNhanSu == nhanSuId && d.IsDeleted == false).Select(s => new DTO_PRO_SYLL
{
ID = s.ID,
IDDetai = s.IDDetai,
IDNhanSu = s.IDNhanSu,
HoTen = s.HoTen,
GioiTinh = s.GioiTinh,
NgaySinh = s.NgaySinh,
DiaChi = s.DiaChi,
DienThoaiCQ = s.DienThoaiCQ,
Mobile = s.Mobile,
Email = s.Email,
ChucVu = s.ChucVu,
CoQuanLamViec = s.CoQuanLamViec,
ThuTruongCoQuan = s.ThuTruongCoQuan,
DienThoaiThuTruong = s.DienThoaiThuTruong,
DiaChiCoQuan = s.DiaChiCoQuan,
DienThoaiNhaRieng = s.DienThoaiNhaRieng,
JSON_TrinhDoChuyenMon = s.JSON_TrinhDoChuyenMon,
JSON_KinhNghiem = s.JSON_KinhNghiem,
HTML = s.HTML,
FormConfig = s.FormConfig,
IsDisabled = s.IsDisabled,
IsDeleted = s.IsDeleted,
CreatedDate = s.CreatedDate,
CreatedBy = s.CreatedBy,
ModifiedDate = s.ModifiedDate,
ModifiedBy = s.ModifiedBy,
NgayKy_ChuKy = s.NgayKy_ChuKy,
NgayKy_Nam = s.NgayKy_Nam,
NgayKy_Ngay = s.NgayKy_Ngay,
NgayKy_Thang = s.NgayKy_Thang,
JSON_HocVi = s.JSON_HocVi,
IsCNDT = s.tbl_CUS_HRM_STAFF_NhanSu.IsCNDT == true
}).FirstOrDefault();
if (query == null)
{
query = db.tbl_CUS_HRM_STAFF_NhanSu_SYLL.Where(d => d.IDNhanSu == nhanSuId && d.IsDeleted == false).Select(s => new DTO_PRO_SYLL
{
ID = s.ID,
IDDetai = idDeTai,
IDNhanSu = s.IDNhanSu,
HoTen = s.HoTen,
GioiTinh = s.GioiTinh,
NgaySinh = s.NgaySinh,
DiaChi = s.DiaChi,
DienThoaiCQ = s.DienThoaiCQ,
Mobile = s.Mobile,
Email = s.Email,
ChucVu = s.ChucVu,
CoQuanLamViec = s.CoQuanLamViec,
ThuTruongCoQuan = s.ThuTruongCoQuan,
DienThoaiThuTruong = s.DienThoaiThuTruong,
DiaChiCoQuan = s.DiaChiCoQuan,
DienThoaiNhaRieng = s.DienThoaiNhaRieng,
JSON_TrinhDoChuyenMon = s.JSON_TrinhDoChuyenMon,
JSON_KinhNghiem = s.JSON_KinhNghiem,
HTML = s.HTML,
FormConfig = s.FormConfig,
IsDisabled = s.IsDisabled,
IsDeleted = s.IsDeleted,
CreatedDate = s.CreatedDate,
CreatedBy = s.CreatedBy,
ModifiedDate = s.ModifiedDate,
ModifiedBy = s.ModifiedBy,
NgayKy_ChuKy = s.NgayKy_ChuKy,
NgayKy_Nam = s.NgayKy_Nam,
NgayKy_Ngay = s.NgayKy_Ngay,
NgayKy_Thang = s.NgayKy_Thang,
JSON_HocVi = s.JSON_HocVi,
IsCNDT = s.tbl_CUS_HRM_STAFF_NhanSu.IsCNDT == true
}).FirstOrDefault();
}
if (query == null)
{
//New
query = new DTO_PRO_SYLL
{
IDNhanSu = nhanSuId,
IDDetai = idDeTai
};
var objNhanSu = db.tbl_CUS_HRM_STAFF_NhanSu.Where(c => c.ID == nhanSuId).FirstOrDefault();
if (objNhanSu != null)
{
query.HoTen = objNhanSu.Name;
query.Email = objNhanSu.Email;
query.DiaChi = objNhanSu.DiaChi;
query.Mobile = objNhanSu.SoDienThoai;
query.IsCNDT = objNhanSu.IsCNDT == true;
}
var ListTrinhDoChuyenMon = new List <DTO_PRO_SYLL_TrinhDoChuyenMon>();
var objHocVi1 = new DTO_PRO_SYLL_TrinhDoChuyenMon();
var objHocVi2 = new DTO_PRO_SYLL_TrinhDoChuyenMon();
var objHocVi3 = new DTO_PRO_SYLL_TrinhDoChuyenMon();
var objLL = db.tbl_CUS_HRM_STAFF_NhanSu_LLKH.FirstOrDefault(c => c.IDNhanSu == nhanSuId);
if (objLL != null)
{
objHocVi1.HocVi = objLL.HocViThacSy;
objHocVi1.NamNhanBang = objLL.NamHocViThacSy;
objHocVi2.HocVi = objLL.HocViTienSy;
objHocVi2.NamNhanBang = objLL.NamHocViTienSy;
objHocVi3.HocVi = objLL.HocHam;
objHocVi3.NamNhanBang = objLL.NamPhongHocHam;
}
ListTrinhDoChuyenMon.Add(objHocVi1);
ListTrinhDoChuyenMon.Add(objHocVi2);
ListTrinhDoChuyenMon.Add(objHocVi3);
query.ListKinhNghiem = new List <DTO_PRO_SYLL_KinhNghiem>()
{
new DTO_PRO_SYLL_KinhNghiem()
};
query.ListTrinhDoChuyenMon = ListTrinhDoChuyenMon;
}
else
{
//Edit
//Edit
if (!string.IsNullOrWhiteSpace(query.JSON_KinhNghiem))
{
query.ListKinhNghiem = JsonConvert.DeserializeObject <List <DTO_PRO_SYLL_KinhNghiem> >(query.JSON_KinhNghiem);
}
if (!string.IsNullOrWhiteSpace(query.JSON_TrinhDoChuyenMon))
{
query.ListTrinhDoChuyenMon = JsonConvert.DeserializeObject <List <DTO_PRO_SYLL_TrinhDoChuyenMon> >(query.JSON_TrinhDoChuyenMon);
}
}
return(query);
}
