public void PostNCC_LIEN_HE(List <LienHeNCC> lh) { if (!ModelState.IsValid) { BadRequest(ModelState); } foreach (var item in lh) { NCC_LIEN_HE lienhe = new NCC_LIEN_HE(); lienhe.MA_NHA_CUNG_CAP = item.MA_NHA_CUNG_CAP; lienhe.NGUOI_LIEN_HE = item.NGUOI_LIEN_HE; lienhe.CHUC_VU = item.CHUC_VU; lienhe.PHONG_BAN = item.PHONG_BAN; lienhe.NGAY_SINH = GeneralFunction.ConvertToTime(item.NGAY_SINH); lienhe.GIOI_TINH = item.GIOI_TINH; lienhe.EMAIL_CA_NHAN = item.EMAIL_CA_NHAN; lienhe.EMAIL_CONG_TY = item.EMAIL_CONG_TY; lienhe.SKYPE = item.SKYPE; lienhe.FACEBOOK = item.FACEBOOK; lienhe.GHI_CHU = item.GHI_CHU; lienhe.SO_DIEN_THOAI_1 = item.SO_DIEN_THOAI_1; lienhe.SO_DIEN_THOAI_2 = item.SO_DIEN_THOAI_2; db.NCC_LIEN_HE.Add(lienhe); db.SaveChanges(); var query = db.NCC_LIEN_HE.Where(x => x.SO_DIEN_THOAI_1 == item.SO_DIEN_THOAI_1).ToList(); var data = query.LastOrDefault(); NCC_PUR_PHU_TRACH salept = new NCC_PUR_PHU_TRACH(); salept.ID_LIEN_HE = data.ID_LIEN_HE; salept.PUR_PHU_TRACH = item.PUR_PHU_TRACH; salept.NGAY_BAT_DAU_PHU_TRACH = DateTime.Today.Date; salept.TRANG_THAI = true; db.NCC_PUR_PHU_TRACH.Add(salept); db.SaveChanges(); } }
public IHttpActionResult GetNCC_PUR_PHU_TRACH(int id) { NCC_PUR_PHU_TRACH nCC_PUR_PHU_TRACH = db.NCC_PUR_PHU_TRACH.Find(id); if (nCC_PUR_PHU_TRACH == null) { return(NotFound()); } return(Ok(nCC_PUR_PHU_TRACH)); }
public IHttpActionResult DeleteNCC_PUR_PHU_TRACH(int id) { NCC_PUR_PHU_TRACH nCC_PUR_PHU_TRACH = db.NCC_PUR_PHU_TRACH.Find(id); if (nCC_PUR_PHU_TRACH == null) { return(NotFound()); } db.NCC_PUR_PHU_TRACH.Remove(nCC_PUR_PHU_TRACH); db.SaveChanges(); return(Ok(nCC_PUR_PHU_TRACH)); }
public IHttpActionResult PostNCC_PUR_PHU_TRACH(PurPhuTrach pur) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } NCC_PUR_PHU_TRACH nv = new NCC_PUR_PHU_TRACH(); nv.ID_LIEN_HE = pur.ID_LIEN_HE; nv.PUR_PHU_TRACH = pur.PUR_PHU_TRACH; if (pur.NGAY_BAT_DAU_PHU_TRACH != null) { nv.NGAY_BAT_DAU_PHU_TRACH = xlnt.Xulydatetime(pur.NGAY_BAT_DAU_PHU_TRACH); } if (pur.NGAY_KET_THUC_PHU_TRACH != null) { nv.NGAY_KET_THUC_PHU_TRACH = xlnt.Xulydatetime(pur.NGAY_KET_THUC_PHU_TRACH); } nv.TRANG_THAI = pur.TRANG_THAI; db.NCC_PUR_PHU_TRACH.Add(nv); try { db.SaveChanges(); } catch (DbUpdateException) { if (NCC_PUR_PHU_TRACHExists(pur.ID_LIEN_HE)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = nv.ID_LIEN_HE }, nv)); }
public IHttpActionResult PostNCC_LIEN_HE(LienHeNCC lh) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } NCC_LIEN_HE lienhe = new NCC_LIEN_HE(); lienhe.MA_NHA_CUNG_CAP = lh.MA_NHA_CUNG_CAP; lienhe.NGUOI_LIEN_HE = lh.NGUOI_LIEN_HE; lienhe.CHUC_VU = lh.CHUC_VU; lienhe.PHONG_BAN = lh.PHONG_BAN; lienhe.NGAY_SINH = GeneralFunction.ConvertToTime(lh.NGAY_SINH); lienhe.GIOI_TINH = lh.GIOI_TINH; lienhe.EMAIL_CA_NHAN = lh.EMAIL_CA_NHAN; lienhe.EMAIL_CONG_TY = lh.EMAIL_CONG_TY; lienhe.SKYPE = lh.SKYPE; lienhe.FACEBOOK = lh.FACEBOOK; lienhe.GHI_CHU = lh.GHI_CHU; lienhe.SO_DIEN_THOAI_1 = lh.SO_DIEN_THOAI_1; lienhe.SO_DIEN_THOAI_2 = lh.SO_DIEN_THOAI_2; db.NCC_LIEN_HE.Add(lienhe); db.SaveChanges(); var query = db.NCC_LIEN_HE.Where(x => x.SO_DIEN_THOAI_1 == lh.SO_DIEN_THOAI_1).ToList(); var data = query.LastOrDefault(); NCC_PUR_PHU_TRACH salept = new NCC_PUR_PHU_TRACH(); salept.ID_LIEN_HE = data.ID_LIEN_HE; salept.PUR_PHU_TRACH = lh.PUR_PHU_TRACH; salept.NGAY_BAT_DAU_PHU_TRACH = DateTime.Today.Date; salept.TRANG_THAI = true; db.NCC_PUR_PHU_TRACH.Add(salept); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = lh.ID_LIEN_HE }, lh)); }