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