public IHttpActionResult PutKH_SALES_PHU_TRACH(int id, SalesPhuTrach sale)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != sale.ID)
{
return(BadRequest());
}
var nv = db.KH_SALES_PHU_TRACH.Where(x => x.ID == id).FirstOrDefault();
nv.ID_LIEN_HE = sale.ID_LIEN_HE;
nv.SALES_PHU_TRACH = sale.SALES_PHU_TRACH;
if (sale.NGAY_KET_THUC_PHU_TRACH != null)
{
nv.NGAY_KET_THUC_PHU_TRACH = xlnt.Xulydatetime(sale.NGAY_KET_THUC_PHU_TRACH);
}
if (sale.NGAY_BAT_DAU_PHU_TRACH != null)
{
nv.NGAY_BAT_DAU_PHU_TRACH = xlnt.Xulydatetime(sale.NGAY_BAT_DAU_PHU_TRACH);
}
nv.TRANG_THAI = sale.TRANG_THAI;
if (sale.SALES_CU == false && sale.SALES_MOI == false)
{
nv.SALES_MOI = true;
nv.SALES_CU = false;
}
else
{
nv.SALES_CU = sale.SALES_CU;
nv.SALES_MOI = sale.SALES_MOI;
}
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!KH_SALES_PHU_TRACHExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostKH_SALES_PHU_TRACH(SalesPhuTrach sale)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
KH_SALES_PHU_TRACH nv = new KH_SALES_PHU_TRACH();
nv.ID_LIEN_HE = sale.ID_LIEN_HE;
nv.SALES_PHU_TRACH = sale.SALES_PHU_TRACH;
nv.NGAY_BAT_DAU_PHU_TRACH = DateTime.Today.Date;
nv.TRANG_THAI = sale.TRANG_THAI;
if (sale.SALES_CU == false && sale.SALES_MOI == false)
{
nv.SALES_MOI = true;
nv.SALES_CU = false;
}
else
{
nv.SALES_CU = sale.SALES_CU;
nv.SALES_MOI = sale.SALES_MOI;
}
db.KH_SALES_PHU_TRACH.Add(nv);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (KH_SALES_PHU_TRACHExists(sale.ID_LIEN_HE))
{
return(Conflict());
}
else
{
throw;
}
}
return(CreatedAtRoute("DefaultApi", new { id = nv.ID_LIEN_HE }, nv));
}
public IHttpActionResult EditSalePhuTrach(int id, SalesPhuTrach sale)
{
var nv = db.KH_SALES_PHU_TRACH.Where(x => x.ID == id).FirstOrDefault();
if (nv != null)
{
nv.SALES_PHU_TRACH = sale.SALES_PHU_TRACH;
if (sale.NGAY_KET_THUC_PHU_TRACH != null)
{
nv.NGAY_KET_THUC_PHU_TRACH = xlnt.Xulydatetime(sale.NGAY_KET_THUC_PHU_TRACH);
}
nv.TRANG_THAI = sale.TRANG_THAI;
}
else
{
nv.ID_LIEN_HE = sale.ID_LIEN_HE;
nv.SALES_PHU_TRACH = sale.SALES_PHU_TRACH;
nv.NGAY_BAT_DAU_PHU_TRACH = DateTime.Today.Date;
db.KH_SALES_PHU_TRACH.Add(nv);
db.SaveChanges();
}
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!KH_SALES_PHU_TRACHExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutKH_SALES_PHU_TRACH(string username, int idlienhe, SalesPhuTrach sale)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (idlienhe != sale.ID_LIEN_HE)
{
return(BadRequest());
}
var nv = db.KH_SALES_PHU_TRACH.Where(x => x.ID_LIEN_HE == idlienhe).FirstOrDefault();
if (nv != null)
{
nv.ID_LIEN_HE = idlienhe;
nv.SALES_PHU_TRACH = sale.SALES_PHU_TRACH;
if (sale.NGAY_KET_THUC_PHU_TRACH != null)
{
nv.NGAY_KET_THUC_PHU_TRACH = xlnt.Xulydatetime(sale.NGAY_KET_THUC_PHU_TRACH);
}
nv.TRANG_THAI = sale.TRANG_THAI;
}
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!KH_SALES_PHU_TRACHExists(idlienhe))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
