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