public IHttpActionResult PostDM_TAI_KHOAN_HACH_TOAN(DM_TAI_KHOAN_HACH_TOAN dM_TAI_KHOAN_HACH_TOAN) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.DM_TAI_KHOAN_HACH_TOAN.Add(dM_TAI_KHOAN_HACH_TOAN); try { db.SaveChanges(); } catch (DbUpdateException) { if (DM_TAI_KHOAN_HACH_TOANExists(dM_TAI_KHOAN_HACH_TOAN.SO_TK)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = dM_TAI_KHOAN_HACH_TOAN.SO_TK }, dM_TAI_KHOAN_HACH_TOAN)); }
public IHttpActionResult PutDM_TAI_KHOAN_HACH_TOAN(string id, DM_TAI_KHOAN_HACH_TOAN dM_TAI_KHOAN_HACH_TOAN) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != dM_TAI_KHOAN_HACH_TOAN.SO_TK) { return(BadRequest()); } db.Entry(dM_TAI_KHOAN_HACH_TOAN).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!DM_TAI_KHOAN_HACH_TOANExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public IHttpActionResult GetDM_TAI_KHOAN_HACH_TOAN(string id) { DM_TAI_KHOAN_HACH_TOAN dM_TAI_KHOAN_HACH_TOAN = db.DM_TAI_KHOAN_HACH_TOAN.Find(id); if (dM_TAI_KHOAN_HACH_TOAN == null) { return(NotFound()); } return(Ok(dM_TAI_KHOAN_HACH_TOAN)); }
public ActionResult Import_HTtaikhoan(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_TAI_KHOAN_HACH_TOAN taikhoan = new DM_TAI_KHOAN_HACH_TOAN(); taikhoan.SO_TK = workSheet.Cells[rowIterator, 1].Value.ToString(); taikhoan.TEN_TK = workSheet.Cells[rowIterator, 2].Value.ToString(); taikhoan.TINH_CHAT = workSheet.Cells[rowIterator, 3].Value.ToString(); taikhoan.TEN_TA = workSheet.Cells[rowIterator, 4].Value.ToString(); taikhoan.TK_CAP_CHA = workSheet.Cells[rowIterator, 5].Value.ToString(); taikhoan.DIEN_GIAI = workSheet.Cells[rowIterator, 6].Value.ToString(); db.DM_TAI_KHOAN_HACH_TOAN.Add(taikhoan); 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_TAI_KHOAN_HACH_TOAN(string id) { DM_TAI_KHOAN_HACH_TOAN dM_TAI_KHOAN_HACH_TOAN = db.DM_TAI_KHOAN_HACH_TOAN.Find(id); if (dM_TAI_KHOAN_HACH_TOAN == null) { return(NotFound()); } db.DM_TAI_KHOAN_HACH_TOAN.Remove(dM_TAI_KHOAN_HACH_TOAN); db.SaveChanges(); return(Ok(dM_TAI_KHOAN_HACH_TOAN)); }