public IHttpActionResult PostCCTC_CONG_TY(CCTC_CONG_TY cCTC_CONG_TY) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.CCTC_CONG_TY.Add(cCTC_CONG_TY); try { db.SaveChanges(); } catch (DbUpdateException) { if (CCTC_CONG_TYExists(cCTC_CONG_TY.MA_CONG_TY)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = cCTC_CONG_TY.MA_CONG_TY }, cCTC_CONG_TY)); }
public IHttpActionResult PutCCTC_CONG_TY(string id, CCTC_CONG_TY cCTC_CONG_TY) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != cCTC_CONG_TY.MA_CONG_TY) { return(BadRequest()); } db.Entry(cCTC_CONG_TY).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CCTC_CONG_TYExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GetCCTC_CONG_TY(string id) { CCTC_CONG_TY cCTC_CONG_TY = db.CCTC_CONG_TY.Find(id); if (cCTC_CONG_TY == null) { return(NotFound()); } return(Ok(cCTC_CONG_TY)); }
public IHttpActionResult DeleteCCTC_CONG_TY(string id) { CCTC_CONG_TY cCTC_CONG_TY = db.CCTC_CONG_TY.Find(id); if (cCTC_CONG_TY == null) { return(NotFound()); } db.CCTC_CONG_TY.Remove(cCTC_CONG_TY); db.SaveChanges(); return(Ok(cCTC_CONG_TY)); }
public IHttpActionResult PostCCTC_CONG_TY(CongTy CONGTY) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } CCTC_CONG_TY nv = new CCTC_CONG_TY(); nv.MA_CONG_TY = CONGTY.MA_CONG_TY; nv.TEN_CONG_TY = CONGTY.TEN_CONG_TY; if (CONGTY.NGAY_THANH_LAP != null) { nv.NGAY_THANH_LAP = xlnt.Xulydatetime(CONGTY.NGAY_THANH_LAP); } nv.EMAIL = CONGTY.EMAIL; nv.FAX = CONGTY.FAX; nv.SDT = CONGTY.SDT; nv.MST = CONGTY.MST; nv.LOGO = CONGTY.LOGO; nv.DIA_CHI = CONGTY.DIA_CHI; nv.DIA_CHI_XUAT_HOA_DON = CONGTY.DIA_CHI_XUAT_HOA_DON; nv.CONG_TY_ME = CONGTY.CONG_TY_ME; nv.CAP_TO_CHUC = CONGTY.CAP_TO_CHUC; nv.GHI_CHU = CONGTY.GHI_CHU; db.CCTC_CONG_TY.Add(nv); try { db.SaveChanges(); } catch (DbUpdateException) { if (CCTC_CONG_TYExists(CONGTY.MA_CONG_TY)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = nv.MA_CONG_TY }, nv)); }
public ActionResult Import_Congty(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++) { CCTC_CONG_TY congty = new CCTC_CONG_TY(); congty.MA_CONG_TY = workSheet.Cells[rowIterator, 1].Value.ToString(); congty.TEN_CONG_TY = workSheet.Cells[rowIterator, 2].Value.ToString(); if (workSheet.Cells[rowIterator, 3].Value != null) { congty.NGAY_THANH_LAP = xulydate.Xulydatetime(workSheet.Cells[rowIterator, 3].Value.ToString()); } if (workSheet.Cells[rowIterator, 4].Value != null) { congty.EMAIL = workSheet.Cells[rowIterator, 4].Value.ToString(); } if (workSheet.Cells[rowIterator, 5].Value != null) { congty.FAX = workSheet.Cells[rowIterator, 5].Value.ToString(); } if (workSheet.Cells[rowIterator, 6].Value != null) { congty.SDT = workSheet.Cells[rowIterator, 6].Value.ToString(); } if (workSheet.Cells[rowIterator, 7].Value != null) { congty.MST = workSheet.Cells[rowIterator, 7].Value.ToString(); } if (workSheet.Cells[rowIterator, 8].Value != null) { congty.LOGO = workSheet.Cells[rowIterator, 8].Value.ToString(); } if (workSheet.Cells[rowIterator, 9].Value != null) { congty.DIA_CHI = workSheet.Cells[rowIterator, 9].Value.ToString(); } if (workSheet.Cells[rowIterator, 10].Value != null) { congty.DIA_CHI_XUAT_HOA_DON = workSheet.Cells[rowIterator, 10].Value.ToString(); } if (workSheet.Cells[rowIterator, 11].Value != null) { congty.CONG_TY_ME = workSheet.Cells[rowIterator, 11].Value.ToString(); } congty.CAP_TO_CHUC = workSheet.Cells[rowIterator, 12].Value.ToString(); if (workSheet.Cells[rowIterator, 13].Value != null) { congty.GHI_CHU = workSheet.Cells[rowIterator, 13].Value.ToString(); } db.CCTC_CONG_TY.Add(congty); 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")); }