public HttpResponseMessage updatecomment([FromBody] RM0010 value) { using (DB db = new DB()) { result <RM0010> rel = new result <RM0010>(); var check = db.RM0010.SingleOrDefault(p => p.RM0010_ID == value.RM0010_ID); if (check != null) { check.ghichu = value.ghichu; try { db.SaveChanges(); rel.set("OK", null); } catch (Exception g) { rel.set("ERR", null, g.Message); } } else { rel.set("NaN", null); } return(rel.ToHttpResponseMessage()); } }
public HttpResponseMessage add([FromBody] RM0010[] values) { using (DB db = new DB()) { results <object> list = new results <object>(); values.ToList().ForEach(value => { result <object> rel = new result <object>(); var check = db.RM0010.SingleOrDefault(p => p.RM0010_ID == value.RM0010_ID); if (check == null) { RM0010 newj = value; if (newj.sophieu != null) { newj.A0028_ID = db.A0028.Where(p => p.sophieu == newj.sophieu).Select(p => p.A0028_ID).FirstOrDefault(); var rm01_id = db.A0028.Where(p => p.sophieu == newj.sophieu).Select(p => p.T005C).FirstOrDefault(); newj.RM0001_ID = rm01_id != null ? int.Parse(rm01_id) : 0; newj.bophanid = db.A0028.Where(p => p.sophieu == newj.sophieu).Select(p => p.T098C).FirstOrDefault(); } newj.trangthai = true; db.RM0010.Add(newj); try { db.SaveChanges(); rel.set("OK", ungvienget.Getallungvien(new ungvienget.filterungvien() { id = value.RM0010_ID }), "Thành công"); } catch (Exception l) { rel.set("ERR", null, "Thất bại:" + l.Message); } } else { if (ungvienget.updateungvien(value)) { rel.set("OK", ungvienget.Getallungvien(new ungvienget.filterungvien() { id = value.RM0010_ID }), "Thành công"); } else { rel.set("ERR", null, "Thất bại:"); } } list.add(rel); }); return(list.ToHttpResponseMessage()); } }
public static bool updateungvien(RM0010 value) { using (DB db = new DB()) { result <object> rel = new result <object>(); var check = db.RM0010.SingleOrDefault(p => p.RM0010_ID == value.RM0010_ID); if (check != null) { check.maID = value.maID; check.HODEM = value.HODEM; check.TEN = value.TEN; check.NGAYSINH = value.NGAYSINH; check.NOISINH = value.NOISINH; check.CMTND_SO = value.CMTND_SO; check.CMTND_NGAYCAP = value.CMTND_NGAYCAP; check.CMTND_NOICAP = value.CMTND_NOICAP; check.GIOITINH = value.GIOITINH; check.HONNHAN = value.HONNHAN; check.TELEPHONE = value.TELEPHONE; check.MOBILE = value.MOBILE; check.CHIEUCAO = value.CHIEUCAO; check.CANNANG = value.CANNANG; check.EMAIL = value.EMAIL; check.THUONGTRU = value.THUONGTRU; check.TAMTRU = value.TAMTRU; check.RM0001_ID = value.RM0001_ID; check.RM0001_ID2 = value.RM0001_ID2; check.NGAYCOTHELAM = value.NGAYCOTHELAM; check.THUNHAPMONGMUON = value.THUNHAPMONGMUON; check.COTHELAMTHEM = value.COTHELAMTHEM; check.COTHEDICONGTAC = value.COTHEDICONGTAC; check.COTHETHAYDOIDIADIEM = value.COTHETHAYDOIDIADIEM; check.DATUNGTHITUYENMEIKO = value.DATUNGTHITUYENMEIKO; check.NEUDATUNGTHITUYENMEIKO = value.NEUDATUNGTHITUYENMEIKO; check.ID_NGUONTHONGTIN = value.ID_NGUONTHONGTIN; check.DUDINHTUONGLAI = value.DUDINHTUONGLAI; check.SOTHICH = value.SOTHICH; check.KHONGTHICH = value.KHONGTHICH; check.CACPHAMCHATKYNANG = value.CACPHAMCHATKYNANG; check.HOTENNGUOITHAN = value.HOTENNGUOITHAN; check.DIACHINGUOITHAN = value.DIACHINGUOITHAN; check.MOBILENGUOITHAN = value.MOBILENGUOITHAN; check.ANHCHANDUNG = value.ANHCHANDUNG; check.RM0011_ID1 = value.RM0011_ID1; check.RM0011_ID2 = value.RM0011_ID2; check.trangthai = value.trangthai; check.DUDINHHOCTIEPCHUYENNGANH = value.DUDINHHOCTIEPCHUYENNGANH; check.DUDINHHOCTIEP = value.DUDINHHOCTIEP; check.bophanid = value.bophanid; check.A0028_ID = value.A0028_ID; check.ghichu = value.ghichu; check.Headhunt = value.Headhunt; check.Position = value.Position; check.Date = value.Date; if (value.sophieu != null) { check.A0028_ID = db.A0028.Where(p => p.sophieu == value.sophieu).Select(p => p.A0028_ID).FirstOrDefault(); check.bophanid = db.A0028.Where(p => p.sophieu == value.sophieu).Select(p => p.T098C).FirstOrDefault(); //check.RM0001_ID =int.Parse( db.A0028.Where(p => p.sophieu == value.sophieu).Select(p => p.T005C).FirstOrDefault()); } if (value.A0028_ID != null) { check.RM0001_ID = int.Parse(db.A0028.Where(p => p.A0028_ID == value.A0028_ID).Select(p => p.T005C).FirstOrDefault()); } try { db.SaveChanges(); db.RM0081_A.RemoveRange(check.RM0081_A); db.RM0081_B.RemoveRange(check.RM0081_B); db.RM0081_C.RemoveRange(check.RM0081_C); db.RM0081_D.RemoveRange(check.RM0081_D); db.RM0081_E.RemoveRange(check.RM0081_E); db.RM0081_F.RemoveRange(check.RM0081_F); db.RM0080.RemoveRange(check.RM0080); db.SaveChanges(); check.RM0080 = value.RM0080; check.RM0081_A = value.RM0081_A; check.RM0081_B = value.RM0081_B; check.RM0081_C = value.RM0081_C; check.RM0081_D = value.RM0081_D; check.RM0081_E = value.RM0081_E; check.RM0081_F = value.RM0081_F; db.SaveChanges(); return(true); rel.set("OK", ungvienget.Getallungvien(new ungvienget.filterungvien() { id = value.RM0010_ID }), "Thành công"); } catch (Exception l) { return(false); rel.set("ERR", null, "Thất bại:" + l.Message); } } else { return(false); rel.set("NaN", null, "Không tìm thấy dữ liệu."); } return(false); // return rel.ToHttpResponseMessage(); } }
public HttpResponseMessage update([FromBody] RM0010 value) { result <object> rel = new result <object>(); if (ungvienget.updateungvien(value)) { rel.set("OK", ungvienget.Getallungvien(new ungvienget.filterungvien() { id = value.RM0010_ID }), "Thành công"); return(rel.ToHttpResponseMessage()); } else { rel.set("ERR", null, "Thất bại:"); return(rel.ToHttpResponseMessage()); //using (DB db = new DB()) //{ // result<object> rel = new result<object>(); // var check = db.RM0010.SingleOrDefault(p => p.RM0010_ID == value.RM0010_ID); // if (check != null) // { // check.maID = value.maID; // check.HODEM = value.HODEM; // check.TEN = value.TEN; // check.NGAYSINH = value.NGAYSINH; // check.NOISINH = value.NOISINH; // check.CMTND_SO = value.CMTND_SO; // check.CMTND_NGAYCAP = value.CMTND_NGAYCAP; // check.CMTND_NOICAP = value.CMTND_NOICAP; // check.GIOITINH = value.GIOITINH; // check.HONNHAN = value.HONNHAN; // check.TELEPHONE = value.TELEPHONE; // check.MOBILE = value.MOBILE; // check.CHIEUCAO = value.CHIEUCAO; // check.CANNANG = value.CANNANG; // check.EMAIL = value.EMAIL; // check.THUONGTRU = value.THUONGTRU; // check.TAMTRU = value.TAMTRU; // check.RM0001_ID = value.RM0001_ID; // check.RM0001_ID2 = value.RM0001_ID2; // check.NGAYCOTHELAM = value.NGAYCOTHELAM; // check.THUNHAPMONGMUON = value.THUNHAPMONGMUON; // check.COTHELAMTHEM = value.COTHELAMTHEM; // check.COTHEDICONGTAC = value.COTHEDICONGTAC; // check.COTHETHAYDOIDIADIEM = value.COTHETHAYDOIDIADIEM; // check.DATUNGTHITUYENMEIKO = value.DATUNGTHITUYENMEIKO; // check.NEUDATUNGTHITUYENMEIKO = value.NEUDATUNGTHITUYENMEIKO; // check.ID_NGUONTHONGTIN = value.ID_NGUONTHONGTIN; // check.DUDINHTUONGLAI = value.DUDINHTUONGLAI; // check.SOTHICH = value.SOTHICH; // check.KHONGTHICH = value.KHONGTHICH; // check.CACPHAMCHATKYNANG = value.CACPHAMCHATKYNANG; // check.HOTENNGUOITHAN = value.HOTENNGUOITHAN; // check.DIACHINGUOITHAN = value.DIACHINGUOITHAN; // check.MOBILENGUOITHAN = value.MOBILENGUOITHAN; // check.ANHCHANDUNG = value.ANHCHANDUNG; // check.RM0011_ID1 = value.RM0011_ID1; // check.RM0011_ID2 = value.RM0011_ID2; // check.trangthai = value.trangthai; // check.DUDINHHOCTIEPCHUYENNGANH = value.DUDINHHOCTIEPCHUYENNGANH; // check.DUDINHHOCTIEP = value.DUDINHHOCTIEP; // check.bophanid = value.bophanid; // try // { // db.SaveChanges(); // db.RM0081_A.RemoveRange(check.RM0081_A); // db.RM0081_B.RemoveRange(check.RM0081_B); // db.RM0081_C.RemoveRange(check.RM0081_C); // db.RM0081_D.RemoveRange(check.RM0081_D); // db.RM0081_E.RemoveRange(check.RM0081_E); // db.RM0081_F.RemoveRange(check.RM0081_F); // db.RM0080.RemoveRange(check.RM0080); // db.SaveChanges(); // check.RM0080 = value.RM0080; // check.RM0081_A = value.RM0081_A; // check.RM0081_B = value.RM0081_B; // check.RM0081_C = value.RM0081_C; // check.RM0081_D = value.RM0081_D; // check.RM0081_E = value.RM0081_E; // check.RM0081_F = value.RM0081_F; // db.SaveChanges(); // rel.set("OK", ungvienget.Getallungvien(new ungvienget.filterungvien() { id = value.RM0010_ID }), "Thành công"); // } // catch (Exception l) // { // rel.set("ERR", null, "Thất bại:" + l.Message); // } // } // else // { // rel.set("NaN", null, "Không tìm thấy dữ liệu."); // } // return rel.ToHttpResponseMessage(); //} } }