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