public IHttpActionResult PostDM_HANG_SP(HH_NHOM_VTHH Hh_NHOM_VTHH) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.HH_NHOM_VTHH.Add(Hh_NHOM_VTHH); try { db.SaveChanges(); } catch (DbUpdateException) { if (DM_HANG_SPExists(Hh_NHOM_VTHH.MA_NHOM_HANG_CHI_TIET)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = Hh_NHOM_VTHH.MA_NHOM_HANG_CHI_TIET }, Hh_NHOM_VTHH)); }
public IHttpActionResult PutDM_HANG_SP(string id, HH_NHOM_VTHH Hh_NHOM_VTHH) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != Hh_NHOM_VTHH.MA_NHOM_HANG_CHI_TIET) { return(BadRequest()); } db.Entry(Hh_NHOM_VTHH).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!DM_HANG_SPExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GetHH_NHOM_VTHH(string id) { HH_NHOM_VTHH HH_NHOM_VTHH = db.HH_NHOM_VTHH.Find(id); if (HH_NHOM_VTHH == null) { return NotFound(); } return Ok(HH_NHOM_VTHH); }
public IHttpActionResult GetDM_HANG_SP(string id) { HH_NHOM_VTHH dM_HANG_SP = db.HH_NHOM_VTHH.Find(id); if (dM_HANG_SP == null) { return(NotFound()); } return(Ok(dM_HANG_SP)); }
public IHttpActionResult DeleteHH_NHOM_VTHH(string id) { HH_NHOM_VTHH HH_NHOM_VTHH = db.HH_NHOM_VTHH.Find(id); if (HH_NHOM_VTHH == null) { return NotFound(); } db.HH_NHOM_VTHH.Remove(HH_NHOM_VTHH); db.SaveChanges(); return Ok(HH_NHOM_VTHH); }
public ActionResult Import_Hangsp(HttpPostedFileBase file) { try { if (Request != null) { HttpPostedFileBase filetonkho = Request.Files["UploadedFile"]; if ((filetonkho != null) && (filetonkho.ContentLength > 0) && !string.IsNullOrEmpty(filetonkho.FileName)) { string fileName = filetonkho.FileName; string fileContentType = filetonkho.ContentType; byte[] fileBytes = new byte[filetonkho.ContentLength]; var data = filetonkho.InputStream.Read(fileBytes, 0, Convert.ToInt32(filetonkho.ContentLength)); //var usersList = new List<Users>(); using (var package = new ExcelPackage(filetonkho.InputStream)) { var currentSheet = package.Workbook.Worksheets; var workSheet = currentSheet.First(); var noOfCol = workSheet.Dimension.End.Column; var noOfRow = workSheet.Dimension.End.Row; for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++) { HH_NHOM_VTHH hangsp = new HH_NHOM_VTHH(); hangsp.MA_NHOM_HANG_CHI_TIET = workSheet.Cells[rowIterator, 1].Value.ToString(); hangsp.CHUNG_LOAI_HANG = workSheet.Cells[rowIterator, 2].Value.ToString(); hangsp.MA_NHOM_HANG_CHA = workSheet.Cells[rowIterator, 3].Value.ToString(); hangsp.GHI_CHU = workSheet.Cells[rowIterator, 4].Value.ToString(); db.HH_NHOM_VTHH.Add(hangsp); db.SaveChanges(); so_dong_thanh_cong++; dong = rowIterator - 1; } } } } } catch (Exception Ex) { ViewBag.Error = " Đã xảy ra lỗi, Liên hệ ngay với admin. " + Environment.NewLine + " Thông tin chi tiết về lỗi:" + Environment.NewLine + Ex; ViewBag.Information = "Lỗi tại dòng thứ: " + dong; } finally { ViewBag.Message = "Đã import thành công " + so_dong_thanh_cong + " dòng"; } return(View("Import_Hanghoa")); }
public IHttpActionResult DeleteDM_HANG_SP(string id) { HH_NHOM_VTHH dM_HANG_SP = db.HH_NHOM_VTHH.Find(id); if (dM_HANG_SP == null) { return(NotFound()); } db.HH_NHOM_VTHH.Remove(dM_HANG_SP); db.SaveChanges(); return(Ok(dM_HANG_SP)); }
public IHttpActionResult PostKH_POLICY(khachhang_policy kH_POLICY) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var query = db.HH_NHOM_VTHH.Where(x => x.MA_NHOM_HANG_CHI_TIET == kH_POLICY.MA_NHOM_HANG).FirstOrDefault(); if (query != null) { KH_POLICY newpolicy = new KH_POLICY(); newpolicy.MA_NHOM_HANG = kH_POLICY.MA_NHOM_HANG; newpolicy.MA_KHACH_HANG = kH_POLICY.MA_KHACH_HANG; newpolicy.NGAY_CAP_NHAT = DateTime.Today.Date; newpolicy.GIA_BAN = kH_POLICY.GIA_BAN; newpolicy.CK = kH_POLICY.CK; newpolicy.NGUOI_CAP_NHAT = kH_POLICY.NGUOI_CAP_NHAT; db.KH_POLICY.Add(newpolicy); db.SaveChanges(); } else { HH_NHOM_VTHH newvthh = new HH_NHOM_VTHH(); newvthh.MA_NHOM_HANG_CHI_TIET = kH_POLICY.MA_NHOM_HANG; newvthh.MA_NHOM_HANG_CHA = kH_POLICY.MA_NHOM_HANG_CHA; newvthh.PURC_PHU_TRACH = kH_POLICY.PURC_PHU_TRACH; newvthh.MARK_PHU_TRACH = kH_POLICY.MARK_PHU_TRACH; db.HH_NHOM_VTHH.Add(newvthh); db.SaveChanges(); KH_POLICY newpolicy = new KH_POLICY(); newpolicy.MA_NHOM_HANG = newvthh.MA_NHOM_HANG_CHI_TIET; newpolicy.MA_KHACH_HANG = kH_POLICY.MA_KHACH_HANG; newpolicy.GIA_BAN = kH_POLICY.GIA_BAN; newpolicy.CK = kH_POLICY.CK; newpolicy.NGUOI_CAP_NHAT = kH_POLICY.NGUOI_CAP_NHAT; newpolicy.NGAY_CAP_NHAT = DateTime.Now; db.KH_POLICY.Add(newpolicy); db.SaveChanges(); } return(Ok(kH_POLICY)); }