public IHttpActionResult PostDM_HANG_HOA(DM_HANG_HOA dM_HANG_HOA) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.DM_HANG_HOA.Add(dM_HANG_HOA); try { db.SaveChanges(); } catch (DbUpdateException) { if (DM_HANG_HOAExists(dM_HANG_HOA.MA_HANG)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = dM_HANG_HOA.MA_HANG }, dM_HANG_HOA)); }
public IHttpActionResult PutDM_HANG_HOA(string id, DM_HANG_HOA dM_HANG_HOA) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != dM_HANG_HOA.MA_HANG) { return(BadRequest()); } db.Entry(dM_HANG_HOA).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!DM_HANG_HOAExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult DeleteConfirmed(string id) { DM_HANG_HOA dM_HANG_HOA = db.DM_HANG_HOA.Find(id); db.DM_HANG_HOA.Remove(dM_HANG_HOA); db.SaveChanges(); return(RedirectToAction("Index")); }
public IHttpActionResult GetDM_HANG_HOA(string id) { DM_HANG_HOA dM_HANG_HOA = db.DM_HANG_HOA.Find(id); if (dM_HANG_HOA == null) { return(NotFound()); } return(Ok(dM_HANG_HOA)); }
public IHttpActionResult DeleteDM_HANG_HOA(string id) { DM_HANG_HOA dM_HANG_HOA = db.DM_HANG_HOA.Find(id); if (dM_HANG_HOA == null) { return(NotFound()); } db.DM_HANG_HOA.Remove(dM_HANG_HOA); db.SaveChanges(); return(Ok(dM_HANG_HOA)); }
public ActionResult Edit([Bind(Include = "MA_HANG_HT,MA_HANG_NHAP,TEN_HANG,MA_NHOM_HANG,SERI,DON_VI_TINH,MODEL_DAC_BIET,HINH_ANH,DAC_TINH,GHI_CHU,TK_HACH_TOAN_KHO,TK_DOANH_THU,TK_CHI_PHI")] DM_HANG_HOA dM_HANG_HOA) { if (ModelState.IsValid) { db.Entry(dM_HANG_HOA).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.MA_NHOM_HANG = new SelectList(db.DM_HANG_SP, "MA_NHOM_HANG", "TEN_NHOM_HANG", dM_HANG_HOA.MA_NHOM_HANG); ViewBag.TK_HACH_TOAN_KHO = new SelectList(db.DM_TAI_KHOAN_HACH_TOAN, "SO_TK", "TEN_TK", dM_HANG_HOA.TK_HACH_TOAN_KHO); ViewBag.TK_DOANH_THU = new SelectList(db.DM_TAI_KHOAN_HACH_TOAN, "SO_TK", "TEN_TK", dM_HANG_HOA.TK_DOANH_THU); ViewBag.TK_CHI_PHI = new SelectList(db.DM_TAI_KHOAN_HACH_TOAN, "SO_TK", "TEN_TK", dM_HANG_HOA.TK_CHI_PHI); return(View(dM_HANG_HOA)); }
// GET: TruongAnHCM/HangHoaTAHCM/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DM_HANG_HOA dM_HANG_HOA = db.DM_HANG_HOA.Find(id); if (dM_HANG_HOA == null) { return(HttpNotFound()); } return(View(dM_HANG_HOA)); }
// GET: TruongAnHCM/HangHoaTAHCM/Edit/5 public ActionResult Edit(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DM_HANG_HOA dM_HANG_HOA = db.DM_HANG_HOA.Find(id); if (dM_HANG_HOA == null) { return(HttpNotFound()); } ViewBag.MA_NHOM_HANG = new SelectList(db.DM_HANG_SP, "MA_NHOM_HANG", "TEN_NHOM_HANG", dM_HANG_HOA.MA_NHOM_HANG); ViewBag.TK_HACH_TOAN_KHO = new SelectList(db.DM_TAI_KHOAN_HACH_TOAN, "SO_TK", "TEN_TK", dM_HANG_HOA.TK_HACH_TOAN_KHO); ViewBag.TK_DOANH_THU = new SelectList(db.DM_TAI_KHOAN_HACH_TOAN, "SO_TK", "TEN_TK", dM_HANG_HOA.TK_DOANH_THU); ViewBag.TK_CHI_PHI = new SelectList(db.DM_TAI_KHOAN_HACH_TOAN, "SO_TK", "TEN_TK", dM_HANG_HOA.TK_CHI_PHI); return(View(dM_HANG_HOA)); }
public ActionResult Import_Hanghoa(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++) { DM_HANG_HOA HH = new DM_HANG_HOA(); HH.MA_HANG_HT = workSheet.Cells[rowIterator, 1].Value.ToString(); HH.MA_HANG_NHAP = workSheet.Cells[rowIterator, 2].Value.ToString(); if (workSheet.Cells[rowIterator, 3].Value != null) { HH.TEN_HANG = workSheet.Cells[rowIterator, 3].Value.ToString(); } HH.MA_NHOM_HANG = workSheet.Cells[rowIterator, 4].Value.ToString(); if (workSheet.Cells[rowIterator, 5].Value != null) { HH.SERI = workSheet.Cells[rowIterator, 5].Value.ToString(); } if (workSheet.Cells[rowIterator, 6].Value != null) { HH.DON_VI_TINH = workSheet.Cells[rowIterator, 6].Value.ToString(); } if (workSheet.Cells[rowIterator, 7].Value != null) { HH.XUAT_XU = workSheet.Cells[rowIterator, 7].Value.ToString(); } if (workSheet.Cells[rowIterator, 8].Value != null) { HH.MODEL_DAC_BIET = Convert.ToBoolean(workSheet.Cells[rowIterator, 8].Value); } if (workSheet.Cells[rowIterator, 9].Value != null) { HH.HINH_ANH = workSheet.Cells[rowIterator, 9].Value.ToString(); } if (workSheet.Cells[rowIterator, 10].Value != null) { HH.DAC_TINH = workSheet.Cells[rowIterator, 10].Value.ToString(); } if (workSheet.Cells[rowIterator, 11].Value != null) { HH.GHI_CHU = workSheet.Cells[rowIterator, 11].Value.ToString(); } if (workSheet.Cells[rowIterator, 12].Value != null) { HH.TK_HACH_TOAN_KHO = workSheet.Cells[rowIterator, 12].Value.ToString(); } if (workSheet.Cells[rowIterator, 13].Value != null) { HH.TK_DOANH_THU = workSheet.Cells[rowIterator, 13].Value.ToString(); } if (workSheet.Cells[rowIterator, 14].Value != null) { HH.TK_CHI_PHI = workSheet.Cells[rowIterator, 14].Value.ToString(); } db.DM_HANG_HOA.Add(HH); 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("Index")); }