public List <GetAll_List_XuatHang_Result> GetListXuatHang(bool isadmin, string username, DataDSXuatKho data)
{
if (data.ngay == null && data.tukhoa == null)
{
var query = db.Database.SqlQuery <GetAll_List_XuatHang_Result>("GetAll_List_XuatHang @macongty,@isadmin,@username,@tukhoa,@ngay", new SqlParameter("macongty", "HOPLONG"), new SqlParameter("isadmin", isadmin), new SqlParameter("username", username), new SqlParameter("tukhoa", DBNull.Value), new SqlParameter("ngay", DBNull.Value));
resultDSXuatKho = query.ToList();
}
if (data.ngay == null && data.tukhoa != null)
{
var query = db.Database.SqlQuery <GetAll_List_XuatHang_Result>("GetAll_List_XuatHang @macongty,@isadmin,@username,@tukhoa,@ngay", new SqlParameter("macongty", "HOPLONG"), new SqlParameter("isadmin", isadmin), new SqlParameter("username", username), new SqlParameter("tukhoa", data.tukhoa), new SqlParameter("ngay", DBNull.Value));
resultDSXuatKho = query.ToList();
}
if (data.ngay != null && data.tukhoa == null)
{
DateTime ngay1 = xlnt.Xulydatetime(data.ngay);
var query = db.Database.SqlQuery <GetAll_List_XuatHang_Result>("GetAll_List_XuatHang @macongty,@isadmin,@username,@tukhoa,@ngay", new SqlParameter("macongty", "HOPLONG"), new SqlParameter("isadmin", isadmin), new SqlParameter("username", username), new SqlParameter("tukhoa", DBNull.Value), new SqlParameter("ngay", ngay1));
resultDSXuatKho = query.ToList();
}
if (data.ngay != null && data.tukhoa != null)
{
DateTime ngay = xlnt.Xulydatetime(data.ngay);
var query = db.Database.SqlQuery <GetAll_List_XuatHang_Result>("GetAll_List_XuatHang @macongty,@isadmin,@username,@tukhoa,@ngay", new SqlParameter("macongty", "HOPLONG"), new SqlParameter("isadmin", isadmin), new SqlParameter("username", username), new SqlParameter("tukhoa", data.tukhoa), new SqlParameter("ngay", ngay));
resultDSXuatKho = query.ToList();
}
return(resultDSXuatKho);
}
public IHttpActionResult PutBH_DON_HANG_PO(string id, ThongTinDonPO bH_DON_HANG_PO)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != bH_DON_HANG_PO.MA_SO_PO)
{
return(BadRequest());
}
var edit = db.BH_DON_HANG_PO.Where(x => x.MA_SO_PO == id).FirstOrDefault();
if (edit != null)
{
if (bH_DON_HANG_PO.NGAY_LEN_PO != null)
{
edit.NGAY_LEN_PO = xlnt.Xulydatetime(bH_DON_HANG_PO.NGAY_LEN_PO);
}
edit.MA_KHACH_HANG = bH_DON_HANG_PO.MA_KHACH_HANG;
edit.TEN_LIEN_HE = bH_DON_HANG_PO.TEN_LIEN_HE;
edit.HINH_THUC_THANH_TOAN = bH_DON_HANG_PO.HINH_THUC_THANH_TOAN;
edit.TONG_TIEN_HANG = bH_DON_HANG_PO.TONG_TIEN_HANG;
edit.SO_TIEN_VIET_BANG_CHU = bH_DON_HANG_PO.SO_TIEN_VIET_BANG_CHU;
if (bH_DON_HANG_PO.NGAY_GIAO_HANG != null)
{
edit.NGAY_GIAO_HANG = xlnt.Xulydatetime(bH_DON_HANG_PO.NGAY_GIAO_HANG.ToString());
}
edit.DIA_DIEM_GIAO_HANG = bH_DON_HANG_PO.DIA_DIEM_GIAO_HANG;
edit.TONG_TIEN_THANH_TOAN = bH_DON_HANG_PO.TONG_TIEN_THANH_TOAN;
edit.TONG_TIEN_THUE_GTGT = bH_DON_HANG_PO.TONG_TIEN_THUE_GTGT;
edit.DA_HUY = bH_DON_HANG_PO.DA_HUY;
edit.LY_DO_HUY = bH_DON_HANG_PO.LY_DO_HUY;
edit.CAN_XUAT_NGAY = bH_DON_HANG_PO.CAN_XUAT_NGAY;
edit.CAN_LAY_HOA_DON = bH_DON_HANG_PO.CAN_LAY_HOA_DON;
}
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!BH_DON_HANG_POExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutKH_SALES_PHU_TRACH(int id, SalesPhuTrach sale)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != sale.ID)
{
return(BadRequest());
}
var nv = db.KH_SALES_PHU_TRACH.Where(x => x.ID == id).FirstOrDefault();
nv.ID_LIEN_HE = sale.ID_LIEN_HE;
nv.SALES_PHU_TRACH = sale.SALES_PHU_TRACH;
if (sale.NGAY_KET_THUC_PHU_TRACH != null)
{
nv.NGAY_KET_THUC_PHU_TRACH = xlnt.Xulydatetime(sale.NGAY_KET_THUC_PHU_TRACH);
}
if (sale.NGAY_BAT_DAU_PHU_TRACH != null)
{
nv.NGAY_BAT_DAU_PHU_TRACH = xlnt.Xulydatetime(sale.NGAY_BAT_DAU_PHU_TRACH);
}
nv.TRANG_THAI = sale.TRANG_THAI;
if (sale.SALES_CU == false && sale.SALES_MOI == false)
{
nv.SALES_MOI = true;
nv.SALES_CU = false;
}
else
{
nv.SALES_CU = sale.SALES_CU;
nv.SALES_MOI = sale.SALES_MOI;
}
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!KH_SALES_PHU_TRACHExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutBH_DON_BAN_HANG(string masobh, DonBanHang bH_DON_BAN_HANG)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (masobh != bH_DON_BAN_HANG.MA_SO_BH)
{
return(BadRequest());
}
var query = db.BH_DON_BAN_HANG.Where(x => x.MA_SO_BH == masobh).FirstOrDefault();
if (query != null)
{
query.NGAY_BH = xlnt.Xulydatetime(bH_DON_BAN_HANG.NGAY_BH.ToString());
query.MA_KHACH_HANG = bH_DON_BAN_HANG.MA_KHACH_HANG;
query.TEN_LIEN_HE = bH_DON_BAN_HANG.TEN_LIEN_HE;
query.HINH_THUC_THANH_TOAN = bH_DON_BAN_HANG.HINH_THUC_THANH_TOAN;
query.TONG_TIEN_HANG = bH_DON_BAN_HANG.TONG_TIEN_HANG;
query.SO_TIEN_VIET_BANG_CHU = bH_DON_BAN_HANG.SO_TIEN_VIET_BANG_CHU;
query.NGAY_GIAO_HANG = xlnt.Xulydatetime(bH_DON_BAN_HANG.NGAY_GIAO_HANG.ToString());
query.DIA_DIEM_GIAO_HANG = bH_DON_BAN_HANG.DIA_DIEM_GIAO_HANG;
query.DA_XUAT_KHO = bH_DON_BAN_HANG.DA_XUAT_KHO;
query.TONG_TIEN_THANH_TOAN = bH_DON_BAN_HANG.TONG_TIEN_THANH_TOAN;
query.TONG_TIEN_THUE_GTGT = bH_DON_BAN_HANG.TONG_TIEN_THUE_GTGT;
query.DA_LAP_HOA_DON = bH_DON_BAN_HANG.DA_LAP_HOA_DON;
}
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!BH_DON_BAN_HANGExists(masobh))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutCCTC_CONG_TY(string id, CongTy CONGTY)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != CONGTY.MA_CONG_TY)
{
return(BadRequest());
}
var nv = db.CCTC_CONG_TY.Where(x => x.MA_CONG_TY == id).FirstOrDefault();
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;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CCTC_CONG_TYExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PuttNCC_LIEN_HE(LienHeNCC lh)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var lienhe = db.NCC_LIEN_HE.Where(x => x.ID_LIEN_HE == lh.ID_LIEN_HE).FirstOrDefault();
lienhe.MA_NHA_CUNG_CAP = lh.MA_NHA_CUNG_CAP;
lienhe.NGUOI_LIEN_HE = lh.NGUOI_LIEN_HE;
lienhe.CHUC_VU = lh.CHUC_VU;
lienhe.PHONG_BAN = lh.PHONG_BAN;
lienhe.NGAY_SINH = xlnt.Xulydatetime(lh.NGAY_SINH);
lienhe.GIOI_TINH = lh.GIOI_TINH;
lienhe.EMAIL_CA_NHAN = lh.EMAIL_CA_NHAN;
lienhe.EMAIL_CONG_TY = lh.EMAIL_CONG_TY;
lienhe.SKYPE = lh.SKYPE;
lienhe.FACEBOOK = lh.FACEBOOK;
lienhe.GHI_CHU = lh.GHI_CHU;
lienhe.SO_DIEN_THOAI_1 = lh.SO_DIEN_THOAI_1;
lienhe.SO_DIEN_THOAI_2 = lh.SO_DIEN_THOAI_2;
db.SaveChanges();
return(Ok());
}
public List <Search_SearchByType_Result> SearchByTypeWithDate(DataCondition data)
{
if (data.ToTime == "" && data.FromTime == "")
{
var query = db.Database.SqlQuery <Search_SearchByType_Result>("Search_SearchByType @LoaiChungTu,@macongty", new SqlParameter("LoaiChungTu", data.GiaTriChungTu), new SqlParameter("macongty", "HOPLONG"));
result = query.ToList();
}
else
{
DateTime FromDate = xlnt.Xulydatetime(data.FromTime);
DateTime ToDate = xlnt.Xulydatetime(data.ToTime);
var query = db.Database.SqlQuery <Search_SearchByType_Result>("Search_SearchByTypeWithDate @LoaiChungTu,@FromDate,@ToDate, @macongty", new SqlParameter("LoaiChungTu", data.GiaTriChungTu), new SqlParameter("FromDate", FromDate), new SqlParameter("ToDate", ToDate), new SqlParameter("macongty", "HOPLONG"));
result = query.ToList();
}
return(result);
}
public IHttpActionResult PutCCTC_NHAN_VIEN(string id, NHAN_VIEN_MODEL nhanvien)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != nhanvien.USERNAME)
{
return(BadRequest());
}
CCTC_NHAN_VIEN nv = new CCTC_NHAN_VIEN();
nv.USERNAME = nhanvien.USERNAME;
nv.GIOI_TINH = nhanvien.GIOI_TINH;
if (nhanvien.NGAY_SINH != null)
{
nv.NGAY_SINH = xlnt.Xulydatetime(nhanvien.NGAY_SINH);
}
nv.QUE_QUAN = nhanvien.QUE_QUAN;
nv.THANH_TICH_CONG_TAC = nhanvien.THANH_TICH_CONG_TAC;
nv.LINH_VUC_CONG_TAC = nhanvien.LINH_VUC_CONG_TAC;
nv.TRINH_DO_HOC_VAN = nhanvien.TRINH_DO_HOC_VAN;
nv.MA_PHONG_BAN = nhanvien.MA_PHONG_BAN;
db.Entry(nv).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!CCTC_NHAN_VIENExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public List <GetAll_PhieuChuyenKho_Result> GetKHO_CHUYEN_KHO(DataDSChuyenKho data)
{
if (data.tungay == null && data.denngay == null)
{
var query = db.Database.SqlQuery <GetAll_PhieuChuyenKho_Result>("GetAll_PhieuChuyenKho @macongty,@tungay,@denngay", new SqlParameter("macongty", "HOPLONG"), new SqlParameter("tungay", DBNull.Value), new SqlParameter("denngay", DBNull.Value));
resultDSChuyen = query.ToList();
}
else
{
DateTime FromDate = xlnt.Xulydatetime(data.tungay);
DateTime ToDate = xlnt.Xulydatetime(data.denngay);
var query = db.Database.SqlQuery <GetAll_PhieuChuyenKho_Result>("GetAll_PhieuChuyenKho @macongty,@tungay,@denngay", new SqlParameter("macongty", "HOPLONG"), new SqlParameter("tungay", FromDate), new SqlParameter("denngay", ToDate));
resultDSChuyen = query.ToList();
return(resultDSChuyen);
}
return(resultDSChuyen);
}
public IHttpActionResult PutBH_CT_BAO_GIA(List <ChiTietBaoGia> bH_CT_BAO_GIA)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
foreach (var item in bH_CT_BAO_GIA)
{
var baogia = db.BH_CT_BAO_GIA.Where(x => x.ID == item.ID).FirstOrDefault();
if (baogia != null)
{
baogia.SO_BAO_GIA = item.SO_BAO_GIA;
baogia.MA_HANG = item.MA_HANG;
baogia.SO_LUONG = item.SO_LUONG;
baogia.DON_GIA = item.DON_GIA;
baogia.CHIET_KHAU = item.CHIET_KHAU;
baogia.CACH_TINH_THANH_TIEN = item.CACH_TINH_THANH_TIEN;
baogia.DON_GIA_SAU_CHIET_KHAU = item.DON_GIA_SAU_CHIET_KHAU;
baogia.THANH_TIEN = item.THANH_TIEN;
baogia.CK_VAT = item.CK_VAT;
baogia.TIEN_VAT = item.TIEN_VAT;
baogia.TINH_TRANG_HANG = item.TINH_TRANG_HANG;
baogia.THOI_GIAN_GIAO_HANG = item.THOI_GIAN_GIAO_HANG;
if (item.NGAY_GIAO_HANG != null)
{
baogia.NGAY_GIAO_HANG = xlnt.Xulydatetime(item.NGAY_GIAO_HANG.ToString());
}
baogia.DIA_DIEM_GIAO_HANG = item.DIA_DIEM_GIAO_HANG;
baogia.GHI_CHU = item.GHI_CHU;
}
}
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
throw;
}
return(Ok(bH_CT_BAO_GIA));
}
public IHttpActionResult PutNCC_PUR_PHU_TRACH(int id, PurPhuTrach pur)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != pur.ID)
{
return(BadRequest());
}
var nv = db.NCC_PUR_PHU_TRACH.Where(x => x.ID == id).FirstOrDefault();
nv.ID_LIEN_HE = pur.ID_LIEN_HE;
nv.PUR_PHU_TRACH = pur.PUR_PHU_TRACH;
if (pur.NGAY_KET_THUC_PHU_TRACH != null)
{
nv.NGAY_KET_THUC_PHU_TRACH = xlnt.Xulydatetime(pur.NGAY_KET_THUC_PHU_TRACH);
}
if (pur.NGAY_BAT_DAU_PHU_TRACH != null)
{
nv.NGAY_BAT_DAU_PHU_TRACH = xlnt.Xulydatetime(pur.NGAY_BAT_DAU_PHU_TRACH);
}
nv.TRANG_THAI = pur.TRANG_THAI;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!NCC_PUR_PHU_TRACHExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostKH_LIEN_HE(LienHeKH lh)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
//if(lh.NGUOI_LIEN_HE != "")
//{
KH_LIEN_HE lienhe = new KH_LIEN_HE();
lienhe.MA_KHACH_HANG = lh.MA_KHACH_HANG;
lienhe.NGUOI_LIEN_HE = lh.NGUOI_LIEN_HE;
lienhe.CHUC_VU = lh.CHUC_VU;
lienhe.PHONG_BAN = lh.PHONG_BAN;
if (lh.NGAY_SINH != null)
{
lienhe.NGAY_SINH = xlnt.Xulydatetime(lh.NGAY_SINH);
}
lienhe.GIOI_TINH = lh.GIOI_TINH;
lienhe.EMAIL_CA_NHAN = lh.EMAIL_CA_NHAN;
lienhe.EMAIL_CONG_TY = lh.EMAIL_CONG_TY;
lienhe.SKYPE = lh.SKYPE;
lienhe.FACEBOOK = lh.FACEBOOK;
lienhe.GHI_CHU = lh.GHI_CHU;
lienhe.SDT1 = lh.SDT1;
lienhe.SDT2 = lh.SDT2;
lienhe.TINH_TRANG_LAM_VIEC = lh.TINH_TRANG_LAM_VIEC;
lienhe.NGAY_TAO = DateTime.Today.Date;
db.KH_LIEN_HE.Add(lienhe);
db.SaveChanges();
var query = db.KH_LIEN_HE.Where(x => x.SDT1 == lh.SDT1).ToList();
var data = query.LastOrDefault();
KH_SALES_PHU_TRACH salept = new KH_SALES_PHU_TRACH();
salept.ID_LIEN_HE = data.ID_LIEN_HE;
salept.SALES_PHU_TRACH = lh.SALES_PHU_TRACH;
salept.NGAY_BAT_DAU_PHU_TRACH = DateTime.Today.Date;
salept.TRANG_THAI = true;
if (lh.SALES_CU == false && lh.SALES_MOI == false)
{
salept.SALES_MOI = true;
salept.SALES_CU = false;
}
else
{
salept.SALES_CU = lh.SALES_CU;
salept.SALES_MOI = lh.SALES_MOI;
}
db.KH_SALES_PHU_TRACH.Add(salept);
db.SaveChanges();
//}
return(Ok(lienhe));
}
public ActionResult Create([Bind(Include = "NGAY_TAO,MA_KHACH_HANG,THANH_CONG,THAT_BAI,LY_DO_THAT_BAI")] BH_DON_HANG_DU_KIEN bH_DON_HANG_DU_KIEN)
{
if (ModelState.IsValid)
{
var ngaytao = bH_DON_HANG_DU_KIEN.NGAY_TAO.ToString("dd/MM/yyyy");
bH_DON_HANG_DU_KIEN.NGAY_TAO = XLNT.Xulydatetime(ngaytao);
bH_DON_HANG_DU_KIEN.TRUC_THUOC = "HOPLONG";
bH_DON_HANG_DU_KIEN.SALES_QUAN_LY = Session["USERNAME"].ToString();
db.BH_DON_HANG_DU_KIEN.Add(bH_DON_HANG_DU_KIEN);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MA_KHACH_HANG = new SelectList(db.KHs, "MA_KHACH_HANG", "TEN_CONG_TY", bH_DON_HANG_DU_KIEN.MA_KHACH_HANG);
return(View("Index"));
}
public IHttpActionResult PostMH_DE_NGHI_NHAP_KHO(ChiTietPOMuaHang denghinhapkho)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
MH_DE_NGHI_NHAP_KHO newdenghi = new MH_DE_NGHI_NHAP_KHO();
newdenghi.MA_SO_DN = GenerateMaSoDeNghi();
newdenghi.NGAY_DN = DateTime.Today.Date;
if (denghinhapkho.NGAY_VE_DU_KIEN != "")
{
newdenghi.NGAY_VE_DU_KIEN = xlnt.Xulydatetime(denghinhapkho.NGAY_VE_DU_KIEN);
}
newdenghi.NGUOI_DN = denghinhapkho.NGUOI_DN;
newdenghi.MA_NCC = denghinhapkho.MA_NCC;
newdenghi.ID_NGUOI_LIEN_HE = denghinhapkho.ID_NGUOI_LIEN_HE;
newdenghi.MA_SO_PO = denghinhapkho.MA_SO_PO;
newdenghi.HINH_THUC_THANH_TOAN = denghinhapkho.HINH_THUC_THANH_TOAN;
newdenghi.HINH_THUC_VAN_CHUYEN = denghinhapkho.HINH_THUC_VAN_CHUYEN;
newdenghi.THOI_HAN_THANH_TOAN = denghinhapkho.THOI_HAN_THANH_TOAN;
newdenghi.DIEN_GIAI = denghinhapkho.DIEN_GIAI;
newdenghi.TONG_TIEN_HANG = denghinhapkho.TONG_TIEN_HANG;
newdenghi.THUE_GTGT = denghinhapkho.THUE_GTGT;
newdenghi.TIEN_THUE_VAT = denghinhapkho.TIEN_THUE_VAT;
newdenghi.TONG_TIEN_DA_BAO_GOM_VAT = denghinhapkho.TONG_TIEN_DA_BAO_GOM_VAT;
newdenghi.TONG_TIEN_BANG_CHU = denghinhapkho.TONG_TIEN_BANG_CHU;
db.MH_DE_NGHI_NHAP_KHO.Add(newdenghi);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (MH_DE_NGHI_NHAP_KHOExists(denghinhapkho.MA_SO_DN))
{
return(Conflict());
}
else
{
throw;
}
}
return(Ok(newdenghi));
}
public void PostKHO_CT_GIU_HANG(List <Khogiuhang> lh)
{
if (!ModelState.IsValid)
{
BadRequest(ModelState);
}
foreach (var item in lh)
{
KHO_CT_GIU_HANG lienhe = new KHO_CT_GIU_HANG();
lienhe.MA_GIU_KHO = item.MA_GIU_KHO;
lienhe.MA_HANG = item.MA_HANG;
lienhe.SL_GIU = item.SL_GIU;
lienhe.DA_XUAT = item.DA_XUAT;
lienhe.GHI_CHU = item.GHI_CHU;
if (item.NGAY_XUAT != "")
{
lienhe.NGAY_XUAT = xlnt.Xulydatetime(item.NGAY_XUAT);
}
db.KHO_CT_GIU_HANG.Add(lienhe);
db.SaveChanges();
}
}
public void PostKH_LIEN_HE(List <LienHeKH> lh)
{
if (!ModelState.IsValid)
{
BadRequest(ModelState);
}
foreach (var item in lh)
{
KH_LIEN_HE lienhe = new KH_LIEN_HE();
lienhe.MA_KHACH_HANG = item.MA_KHACH_HANG;
lienhe.NGUOI_LIEN_HE = item.NGUOI_LIEN_HE;
lienhe.CHUC_VU = item.CHUC_VU;
lienhe.PHONG_BAN = item.PHONG_BAN;
if (item.NGAY_SINH != null)
{
lienhe.NGAY_SINH = xlnt.Xulydatetime(item.NGAY_SINH);
}
lienhe.GIOI_TINH = item.GIOI_TINH;
lienhe.EMAIL_CA_NHAN = item.EMAIL_CA_NHAN;
lienhe.EMAIL_CONG_TY = item.EMAIL_CONG_TY;
lienhe.SKYPE = item.SKYPE;
lienhe.FACEBOOK = item.FACEBOOK;
lienhe.GHI_CHU = item.GHI_CHU;
lienhe.SDT1 = item.SDT1;
lienhe.SDT2 = item.SDT2;
lienhe.NGAY_TAO = DateTime.Today.Date;
db.KH_LIEN_HE.Add(lienhe);
db.SaveChanges();
var query = db.KH_LIEN_HE.Where(x => x.SDT1 == item.SDT1).ToList();
var data = query.LastOrDefault();
KH_SALES_PHU_TRACH salept = new KH_SALES_PHU_TRACH();
salept.ID_LIEN_HE = data.ID_LIEN_HE;
salept.SALES_PHU_TRACH = item.SALES_PHU_TRACH;
salept.NGAY_BAT_DAU_PHU_TRACH = DateTime.Today.Date;
salept.TRANG_THAI = true;
db.KH_SALES_PHU_TRACH.Add(salept);
db.SaveChanges();
}
}
public IHttpActionResult PostKHO_GIU_HANG(Khogiuhang kHO_GIU_HANG)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
String nam = DateTime.Today.Year.ToString();
String nam2so = nam.Substring(2);
var query = db.Database.SqlQuery <string>("XL_LayMaGiuHangMoiNhat");
if (query.Count() > 0)
{
string prefixID = "GH" + nam2so;
var data = query.FirstOrDefault();
string LastID = data;
int nextID = int.Parse(LastID.Remove(0, prefixID.Length)) + 1;
int lengthNumerID = LastID.Length - prefixID.Length;
string zeroNumber = "";
for (int i = 1; i <= lengthNumerID; i++)
{
if (nextID < Math.Pow(10, i))
{
for (int j = 1; j <= lengthNumerID - i; i++)
{
zeroNumber += "0";
}
}
}
// int ma = Convert.ToInt32(makhach.Substring(4));
magiuhang = prefixID + zeroNumber + nextID.ToString();
}
else
{
magiuhang = "GH" + nam2so + "000001";
}
KHO_GIU_HANG nv = new KHO_GIU_HANG();
nv.MA_GIU_KHO = magiuhang;
nv.SALES_GIU = kHO_GIU_HANG.SALES_GIU;
if (kHO_GIU_HANG.NGAY_GIU != null)
{
nv.NGAY_GIU = xlnt.Xulydatetime(kHO_GIU_HANG.NGAY_GIU);
}
nv.MA_KHACH_HANG = kHO_GIU_HANG.MA_KHACH_HANG;
nv.HUY_DON_GIU = kHO_GIU_HANG.HUY_DON_GIU;
nv.DON_DANG_XUAT = kHO_GIU_HANG.DON_DANG_XUAT;
nv.DON_DA_HOAN_THANH = kHO_GIU_HANG.DON_DA_HOAN_THANH;
nv.GIU_PO = kHO_GIU_HANG.GIU_PO;
nv.TRUC_THUOC = kHO_GIU_HANG.TRUC_THUOC;
db.KHO_GIU_HANG.Add(nv);
try
{
db.SaveChanges();
}
catch (DbUpdateException)
{
if (KHO_GIU_HANGExists(kHO_GIU_HANG.MA_GIU_KHO))
{
return(Conflict());
}
else
{
throw;
}
}
return(Ok(nv));
}
public IHttpActionResult PostKT_SO_NHAT_KY_CHUNG(DonBanHang kT_SO_NHAT_KY_CHUNG)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
foreach (var item in kT_SO_NHAT_KY_CHUNG.ChiTietBH)
{
KT_SO_NHAT_KY_CHUNG chitiet1 = new KT_SO_NHAT_KY_CHUNG();
chitiet1.NGAY_HACH_TOAN = xlnt.Xulydatetime(kT_SO_NHAT_KY_CHUNG.NGAY_BH);
chitiet1.NGAY_CHUNG_TU = xlnt.Xulydatetime(kT_SO_NHAT_KY_CHUNG.NGAY_BH);
chitiet1.SO_CHUNG_TU = kT_SO_NHAT_KY_CHUNG.MA_SO_BH;
chitiet1.DOI_TUONG = kT_SO_NHAT_KY_CHUNG.MA_KHACH_HANG;
chitiet1.TRUC_THUOC = kT_SO_NHAT_KY_CHUNG.TRUC_THUOC;
chitiet1.DIEN_GIAI_CHUNG = kT_SO_NHAT_KY_CHUNG.DIEN_GIAI_CHUNG;
chitiet1.DIEN_GIAI_CHI_TIET = item.MA_HANG;
chitiet1.TAI_KHOAN_HACH_TOAN = item.TK_NO;
chitiet1.TAI_KHOAN_DOI_UNG = item.TK_CO;
chitiet1.PHAT_SINH_NO = Convert.ToDecimal(item.TIEN_THANH_TOAN);
chitiet1.PHAT_SINH_CO = 0;
db.KT_SO_NHAT_KY_CHUNG.Add(chitiet1);
KT_SO_NHAT_KY_CHUNG chitiet2 = new KT_SO_NHAT_KY_CHUNG();
chitiet2.NGAY_HACH_TOAN = xlnt.Xulydatetime(kT_SO_NHAT_KY_CHUNG.NGAY_BH);
chitiet2.NGAY_CHUNG_TU = xlnt.Xulydatetime(kT_SO_NHAT_KY_CHUNG.NGAY_BH);
chitiet2.SO_CHUNG_TU = kT_SO_NHAT_KY_CHUNG.MA_SO_BH;
chitiet2.DOI_TUONG = kT_SO_NHAT_KY_CHUNG.MA_KHACH_HANG;
chitiet2.TRUC_THUOC = kT_SO_NHAT_KY_CHUNG.TRUC_THUOC;
chitiet2.DIEN_GIAI_CHUNG = kT_SO_NHAT_KY_CHUNG.DIEN_GIAI_CHUNG;
chitiet2.DIEN_GIAI_CHI_TIET = item.MA_HANG;
chitiet2.TAI_KHOAN_HACH_TOAN = item.TK_CO;
chitiet2.TAI_KHOAN_DOI_UNG = item.TK_NO;
chitiet2.PHAT_SINH_NO = 0;
chitiet2.PHAT_SINH_CO = Convert.ToDecimal(item.TIEN_THANH_TOAN);
db.KT_SO_NHAT_KY_CHUNG.Add(chitiet2);
if (item.TK_THUE != null)
{
KT_SO_NHAT_KY_CHUNG chitiet3 = new KT_SO_NHAT_KY_CHUNG();
chitiet3.NGAY_HACH_TOAN = xlnt.Xulydatetime(kT_SO_NHAT_KY_CHUNG.NGAY_BH);
chitiet3.NGAY_CHUNG_TU = xlnt.Xulydatetime(kT_SO_NHAT_KY_CHUNG.NGAY_BH);
chitiet3.SO_CHUNG_TU = kT_SO_NHAT_KY_CHUNG.MA_SO_BH;
chitiet3.DOI_TUONG = kT_SO_NHAT_KY_CHUNG.MA_KHACH_HANG;
chitiet3.TRUC_THUOC = kT_SO_NHAT_KY_CHUNG.TRUC_THUOC;
chitiet3.DIEN_GIAI_CHUNG = kT_SO_NHAT_KY_CHUNG.DIEN_GIAI_CHUNG;
chitiet3.DIEN_GIAI_CHI_TIET = item.DIEN_GIAI_THUE;
chitiet3.TAI_KHOAN_HACH_TOAN = item.TK_NO;
chitiet3.TAI_KHOAN_DOI_UNG = item.TK_THUE;
chitiet3.PHAT_SINH_NO = Convert.ToDecimal(item.TIEN_THUE_GTGT);
chitiet3.PHAT_SINH_CO = 0;
db.KT_SO_NHAT_KY_CHUNG.Add(chitiet3);
KT_SO_NHAT_KY_CHUNG chitiet4 = new KT_SO_NHAT_KY_CHUNG();
chitiet4.NGAY_HACH_TOAN = xlnt.Xulydatetime(kT_SO_NHAT_KY_CHUNG.NGAY_BH);
chitiet4.NGAY_CHUNG_TU = xlnt.Xulydatetime(kT_SO_NHAT_KY_CHUNG.NGAY_BH);
chitiet4.SO_CHUNG_TU = kT_SO_NHAT_KY_CHUNG.MA_SO_BH;
chitiet4.DOI_TUONG = kT_SO_NHAT_KY_CHUNG.MA_KHACH_HANG;
chitiet4.TRUC_THUOC = kT_SO_NHAT_KY_CHUNG.TRUC_THUOC;
chitiet4.DIEN_GIAI_CHUNG = kT_SO_NHAT_KY_CHUNG.DIEN_GIAI_CHUNG;
chitiet4.DIEN_GIAI_CHI_TIET = item.DIEN_GIAI_THUE;
chitiet4.TAI_KHOAN_HACH_TOAN = item.TK_THUE;
chitiet4.TAI_KHOAN_DOI_UNG = item.TK_NO;
chitiet4.PHAT_SINH_NO = 0;
chitiet4.PHAT_SINH_CO = Convert.ToDecimal(item.TIEN_THUE_GTGT);
db.KT_SO_NHAT_KY_CHUNG.Add(chitiet4);
db.SaveChanges();
}
db.SaveChanges();
}
return(Ok("Hoàn Thành"));
}
public ActionResult Import_Nhanvien(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++)
{
HT_NGUOI_DUNG user = new HT_NGUOI_DUNG();
user.USERNAME = workSheet.Cells[rowIterator, 2].Value.ToString();
user.PASSWORD = workSheet.Cells[rowIterator, 3].Value.ToString();
user.HO_VA_TEN = workSheet.Cells[rowIterator, 1].Value.ToString();
if (workSheet.Cells[rowIterator, 6].Value != null)
{
user.SDT = workSheet.Cells[rowIterator, 6].Value.ToString();
}
if (workSheet.Cells[rowIterator, 7].Value != null)
{
user.EMAIL = workSheet.Cells[rowIterator, 7].Value.ToString();
}
if (workSheet.Cells[rowIterator, 10].Value != null)
{
user.AVATAR = workSheet.Cells[rowIterator, 10].Value.ToString();
}
if (workSheet.Cells[rowIterator, 13].Value != null)
{
user.IS_ADMIN = Convert.ToBoolean(workSheet.Cells[rowIterator, 13].Value);
}
user.ALLOWED = Convert.ToBoolean(workSheet.Cells[rowIterator, 14].Value);
user.MA_CONG_TY = workSheet.Cells[rowIterator, 12].Value.ToString();
db.HT_NGUOI_DUNG.Add(user);
CCTC_NHAN_VIEN nhanvien = new CCTC_NHAN_VIEN();
nhanvien.USERNAME = workSheet.Cells[rowIterator, 2].Value.ToString();
if (workSheet.Cells[rowIterator, 5].Value != null)
{
nhanvien.GIOI_TINH = workSheet.Cells[rowIterator, 5].Value.ToString();
}
if (workSheet.Cells[rowIterator, 4].Value != null)
{
nhanvien.NGAY_SINH = xulydate.Xulydatetime(workSheet.Cells[rowIterator, 4].Value.ToString());
}
if (workSheet.Cells[rowIterator, 8].Value != null)
{
nhanvien.QUE_QUAN = workSheet.Cells[rowIterator, 8].Value.ToString();
}
if (workSheet.Cells[rowIterator, 9].Value != null)
{
nhanvien.TRINH_DO_HOC_VAN = workSheet.Cells[rowIterator, 9].Value.ToString();
}
if (workSheet.Cells[rowIterator, 11].Value != null)
{
nhanvien.MA_PHONG_BAN = workSheet.Cells[rowIterator, 11].Value.ToString();
}
db.CCTC_NHAN_VIEN.Add(nhanvien);
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"));
}
public ActionResult Import_KhachHang(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++)
{
string makhach = workSheet.Cells[rowIterator, 1].Value.ToString();
var query = db.KHs.Where(x => x.MA_KHACH_HANG == makhach).FirstOrDefault();
if (query == null)
{
KH khachhang = new KH();
khachhang.MA_KHACH_HANG = makhach;
khachhang.TEN_CONG_TY = workSheet.Cells[rowIterator, 2].Value.ToString();
if (workSheet.Cells[rowIterator, 5].Value != null)
{
khachhang.VAN_PHONG_GIAO_DICH = workSheet.Cells[rowIterator, 5].Value.ToString();
}
if (workSheet.Cells[rowIterator, 6].Value != null)
{
khachhang.DIA_CHI_XUAT_HOA_DON = workSheet.Cells[rowIterator, 6].Value.ToString();
}
if (workSheet.Cells[rowIterator, 7].Value != null)
{
khachhang.MST = workSheet.Cells[rowIterator, 7].Value.ToString();
}
if (workSheet.Cells[rowIterator, 8].Value != null)
{
khachhang.HOTLINE = workSheet.Cells[rowIterator, 8].Value.ToString();
}
if (workSheet.Cells[rowIterator, 9].Value != null)
{
khachhang.FAX = workSheet.Cells[rowIterator, 9].Value.ToString();
}
if (workSheet.Cells[rowIterator, 10].Value != null)
{
khachhang.EMAIL = workSheet.Cells[rowIterator, 10].Value.ToString();
}
if (workSheet.Cells[rowIterator, 11].Value != null)
{
khachhang.LOGO = workSheet.Cells[rowIterator, 11].Value.ToString();
}
if (workSheet.Cells[rowIterator, 12].Value != null)
{
khachhang.WEBSITE = workSheet.Cells[rowIterator, 12].Value.ToString();
}
if (workSheet.Cells[rowIterator, 13].Value != null)
{
khachhang.TINH = workSheet.Cells[rowIterator, 13].Value.ToString();
}
if (workSheet.Cells[rowIterator, 14].Value != null)
{
khachhang.QUOC_GIA = workSheet.Cells[rowIterator, 14].Value.ToString();
}
if (workSheet.Cells[rowIterator, 15].Value != null)
{
khachhang.DIEU_KHOAN_THANH_TOAN = workSheet.Cells[rowIterator, 15].Value.ToString();
}
if (workSheet.Cells[rowIterator, 16].Value != null)
{
khachhang.SO_NGAY_DUOC_NO = Convert.ToInt32(workSheet.Cells[rowIterator, 16].Value);
}
if (workSheet.Cells[rowIterator, 17].Value != null)
{
khachhang.SO_NO_TOI_DA = Convert.ToInt32(workSheet.Cells[rowIterator, 17].Value);
}
khachhang.TRUC_THUOC = "HOPLONG";
if (workSheet.Cells[rowIterator, 19].Value != null)
{
khachhang.GHI_CHU = workSheet.Cells[rowIterator, 19].Value.ToString();
}
db.KHs.Add(khachhang);
db.SaveChanges();
var DATA = db.KHs.Where(x => x.MA_KHACH_HANG == makhach).FirstOrDefault();
if (DATA != null)
{
KH_PHAN_LOAI_KHACH plkhach = new KH_PHAN_LOAI_KHACH();
plkhach.MA_KHACH_HANG = makhach;
plkhach.MA_LOAI_KHACH = workSheet.Cells[rowIterator, 3].Value.ToString();
if (workSheet.Cells[rowIterator, 4].Value != null)
{
plkhach.NHOM_NGANH = workSheet.Cells[rowIterator, 4].Value.ToString();
}
db.KH_PHAN_LOAI_KHACH.Add(plkhach);
db.SaveChanges();
}
if (workSheet.Cells[rowIterator, 20].Value != null)
{
KH_LIEN_HE lhkhach = new KH_LIEN_HE();
lhkhach.MA_KHACH_HANG = makhach;
lhkhach.NGUOI_LIEN_HE = workSheet.Cells[rowIterator, 20].Value.ToString();
if (workSheet.Cells[rowIterator, 21].Value != null)
{
lhkhach.CHUC_VU = workSheet.Cells[rowIterator, 21].Value.ToString();
}
if (workSheet.Cells[rowIterator, 22].Value != null)
{
lhkhach.PHONG_BAN = workSheet.Cells[rowIterator, 22].Value.ToString();
}
if (workSheet.Cells[rowIterator, 23].Value != null)
{
lhkhach.NGAY_SINH = xulydate.Xulydatetime(workSheet.Cells[rowIterator, 23].Value.ToString());
}
if (workSheet.Cells[rowIterator, 24].Value != null)
{
lhkhach.GIOI_TINH = workSheet.Cells[rowIterator, 24].Value.ToString();
}
lhkhach.SDT1 = workSheet.Cells[rowIterator, 25].Value.ToString();
if (workSheet.Cells[rowIterator, 26].Value != null)
{
lhkhach.SDT2 = workSheet.Cells[rowIterator, 26].Value.ToString();
}
if (workSheet.Cells[rowIterator, 27].Value != null)
{
lhkhach.EMAIL_CA_NHAN = workSheet.Cells[rowIterator, 27].Value.ToString();
}
if (workSheet.Cells[rowIterator, 28].Value != null)
{
lhkhach.EMAIL_CONG_TY = workSheet.Cells[rowIterator, 28].Value.ToString();
}
if (workSheet.Cells[rowIterator, 29].Value != null)
{
lhkhach.SKYPE = workSheet.Cells[rowIterator, 29].Value.ToString();
}
if (workSheet.Cells[rowIterator, 30].Value != null)
{
lhkhach.FACEBOOK = workSheet.Cells[rowIterator, 30].Value.ToString();
}
if (workSheet.Cells[rowIterator, 31].Value != null)
{
lhkhach.GHI_CHU = workSheet.Cells[rowIterator, 31].Value.ToString();
}
db.KH_LIEN_HE.Add(lhkhach);
db.SaveChanges();
string idlh = workSheet.Cells[rowIterator, 25].Value.ToString();
var datalienhe = db.KH_LIEN_HE.Where(x => x.SDT1 == idlh).FirstOrDefault();
if (datalienhe != null)
{
KH_SALES_PHU_TRACH salept = new KH_SALES_PHU_TRACH();
salept.ID_LIEN_HE = datalienhe.ID_LIEN_HE;
salept.SALES_PHU_TRACH = workSheet.Cells[rowIterator, 32].Value.ToString();
salept.NGAY_BAT_DAU_PHU_TRACH = DateTime.Today.Date;
salept.TRANG_THAI = true;
db.KH_SALES_PHU_TRACH.Add(salept);
db.SaveChanges();
}
if (workSheet.Cells[rowIterator, 33].Value != null)
{
KH_TK_NGAN_HANG tkkhach = new KH_TK_NGAN_HANG();
tkkhach.MA_KHACH_HANG = makhach;
tkkhach.SO_TAI_KHOAN = workSheet.Cells[rowIterator, 33].Value.ToString();
if (workSheet.Cells[rowIterator, 34].Value != null)
{
tkkhach.TEN_TAI_KHOAN = workSheet.Cells[rowIterator, 34].Value.ToString();
}
if (workSheet.Cells[rowIterator, 35].Value != null)
{
tkkhach.TEN_NGAN_HANG = workSheet.Cells[rowIterator, 35].Value.ToString();
}
if (workSheet.Cells[rowIterator, 36].Value != null)
{
tkkhach.CHI_NHANH = workSheet.Cells[rowIterator, 36].Value.ToString();
}
if (workSheet.Cells[rowIterator, 37].Value != null)
{
tkkhach.TINH_TP = workSheet.Cells[rowIterator, 37].Value.ToString();
}
if (workSheet.Cells[rowIterator, 38].Value != null)
{
tkkhach.LOAI_TAI_KHOAN = workSheet.Cells[rowIterator, 38].Value.ToString();
}
if (workSheet.Cells[rowIterator, 39].Value != null)
{
tkkhach.GHI_CHU = workSheet.Cells[rowIterator, 39].Value.ToString();
}
db.KH_TK_NGAN_HANG.Add(tkkhach);
db.SaveChanges();
}
}
}
else
if (query != null)
{
if (workSheet.Cells[rowIterator, 20].Value != null)
{
KH_LIEN_HE lhkhach = new KH_LIEN_HE();
lhkhach.MA_KHACH_HANG = makhach;
lhkhach.NGUOI_LIEN_HE = workSheet.Cells[rowIterator, 20].Value.ToString();
if (workSheet.Cells[rowIterator, 21].Value != null)
{
lhkhach.CHUC_VU = workSheet.Cells[rowIterator, 21].Value.ToString();
}
if (workSheet.Cells[rowIterator, 22].Value != null)
{
lhkhach.PHONG_BAN = workSheet.Cells[rowIterator, 22].Value.ToString();
}
if (workSheet.Cells[rowIterator, 23].Value != null)
{
lhkhach.NGAY_SINH = xulydate.Xulydatetime(workSheet.Cells[rowIterator, 23].Value.ToString());
}
if (workSheet.Cells[rowIterator, 24].Value != null)
{
lhkhach.GIOI_TINH = workSheet.Cells[rowIterator, 24].Value.ToString();
}
lhkhach.SDT1 = workSheet.Cells[rowIterator, 25].Value.ToString();
if (workSheet.Cells[rowIterator, 26].Value != null)
{
lhkhach.SDT2 = workSheet.Cells[rowIterator, 26].Value.ToString();
}
if (workSheet.Cells[rowIterator, 27].Value != null)
{
lhkhach.EMAIL_CA_NHAN = workSheet.Cells[rowIterator, 27].Value.ToString();
}
if (workSheet.Cells[rowIterator, 28].Value != null)
{
lhkhach.EMAIL_CONG_TY = workSheet.Cells[rowIterator, 28].Value.ToString();
}
if (workSheet.Cells[rowIterator, 29].Value != null)
{
lhkhach.SKYPE = workSheet.Cells[rowIterator, 29].Value.ToString();
}
if (workSheet.Cells[rowIterator, 30].Value != null)
{
lhkhach.FACEBOOK = workSheet.Cells[rowIterator, 30].Value.ToString();
}
if (workSheet.Cells[rowIterator, 31].Value != null)
{
lhkhach.GHI_CHU = workSheet.Cells[rowIterator, 31].Value.ToString();
}
db.KH_LIEN_HE.Add(lhkhach);
db.SaveChanges();
string idlh = workSheet.Cells[rowIterator, 25].Value.ToString();
var datalienhe = db.KH_LIEN_HE.Where(x => x.SDT1 == idlh).FirstOrDefault();
if (datalienhe != null)
{
KH_SALES_PHU_TRACH salept = new KH_SALES_PHU_TRACH();
salept.ID_LIEN_HE = datalienhe.ID_LIEN_HE;
salept.SALES_PHU_TRACH = workSheet.Cells[rowIterator, 32].Value.ToString();
salept.NGAY_BAT_DAU_PHU_TRACH = DateTime.Today.Date;
salept.TRANG_THAI = true;
db.KH_SALES_PHU_TRACH.Add(salept);
db.SaveChanges();
}
if (workSheet.Cells[rowIterator, 33].Value != null)
{
KH_TK_NGAN_HANG tkkhach = new KH_TK_NGAN_HANG();
tkkhach.MA_KHACH_HANG = makhach;
tkkhach.SO_TAI_KHOAN = workSheet.Cells[rowIterator, 33].Value.ToString();
if (workSheet.Cells[rowIterator, 34].Value != null)
{
tkkhach.TEN_TAI_KHOAN = workSheet.Cells[rowIterator, 34].Value.ToString();
}
if (workSheet.Cells[rowIterator, 35].Value != null)
{
tkkhach.TEN_NGAN_HANG = workSheet.Cells[rowIterator, 35].Value.ToString();
}
if (workSheet.Cells[rowIterator, 36].Value != null)
{
tkkhach.CHI_NHANH = workSheet.Cells[rowIterator, 36].Value.ToString();
}
if (workSheet.Cells[rowIterator, 37].Value != null)
{
tkkhach.TINH_TP = workSheet.Cells[rowIterator, 37].Value.ToString();
}
if (workSheet.Cells[rowIterator, 38].Value != null)
{
tkkhach.LOAI_TAI_KHOAN = workSheet.Cells[rowIterator, 38].Value.ToString();
}
if (workSheet.Cells[rowIterator, 39].Value != null)
{
tkkhach.GHI_CHU = workSheet.Cells[rowIterator, 39].Value.ToString();
}
db.KH_TK_NGAN_HANG.Add(tkkhach);
db.SaveChanges();
}
}
}
so_dong_thanh_cong++;
dong = rowIterator;
}
}
}
}
}
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());
}
public async Task <IHttpActionResult> PutBH_CT_BAO_GIA([FromBody] List <ChiTietBaoGia> bH_CT_BAO_GIA)
{
//if (!ModelState.IsValid)
//{
// return BadRequest(ModelState);
//}
//try
//{
foreach (var item in bH_CT_BAO_GIA)
{
var baogia = db.BH_CT_BAO_GIA.Where(x => x.ID == item.ID).FirstOrDefault();
if (baogia != null)
{
baogia.SO_BAO_GIA = item.SO_BAO_GIA;
baogia.MA_HANG = item.MA_HANG;
baogia.SO_LUONG = item.SO_LUONG;
baogia.DON_GIA = item.DON_GIA;
baogia.DON_GIA_LIST = item.DON_GIA_LIST;
baogia.DON_GIA_NHAP = item.DON_GIA_NHAP;
baogia.HE_SO_LOI_NHUAN = item.HE_SO_LOI_NHUAN;
baogia.CHIET_KHAU = item.CHIET_KHAU;
baogia.THANH_TIEN = item.THANH_TIEN;
baogia.TINH_TRANG_HANG = item.TINH_TRANG_HANG;
baogia.THOI_GIAN_GIAO_HANG = item.THOI_GIAN_GIAO_HANG;
if (item.NGAY_GIAO_HANG != null)
{
baogia.NGAY_GIAO_HANG = xlnt.Xulydatetime(item.NGAY_GIAO_HANG.ToString());
}
baogia.DIA_DIEM_GIAO_HANG = item.DIA_DIEM_GIAO_HANG;
baogia.GHI_CHU = item.GHI_CHU;
}
else if (baogia == null)
{
BH_CT_BAO_GIA newbaogia = new BH_CT_BAO_GIA();
newbaogia.SO_BAO_GIA = item.SO_BAO_GIA;
newbaogia.MA_HANG = item.MA_HANG;
newbaogia.SO_LUONG = item.SO_LUONG;
newbaogia.DON_GIA = item.DON_GIA;
newbaogia.CHIET_KHAU = item.CHIET_KHAU;
newbaogia.THANH_TIEN = item.THANH_TIEN;
newbaogia.DON_GIA_LIST = item.DON_GIA_LIST;
newbaogia.DON_GIA_NHAP = item.DON_GIA_NHAP;
newbaogia.HE_SO_LOI_NHUAN = item.HE_SO_LOI_NHUAN;
newbaogia.TINH_TRANG_HANG = item.TINH_TRANG_HANG;
newbaogia.THOI_GIAN_GIAO_HANG = item.THOI_GIAN_GIAO_HANG;
if (item.NGAY_GIAO_HANG != null && item.NGAY_GIAO_HANG != "")
{
newbaogia.NGAY_GIAO_HANG = xlnt.Xulydatetime(item.NGAY_GIAO_HANG.ToString());
}
newbaogia.DIA_DIEM_GIAO_HANG = item.DIA_DIEM_GIAO_HANG;
newbaogia.GHI_CHU = item.GHI_CHU;
db.BH_CT_BAO_GIA.Add(newbaogia);
}
}
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateException)
{
throw;
}
//return this.CreatedAtRoute("GetNH_NTTK", new { id = nH_NTTK.SO_CHUNG_TU }, nH_NTTK);
return(Ok(bH_CT_BAO_GIA));
}
public ActionResult Import_KhachHang(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++)
{
makhach = workSheet.Cells[rowIterator, 1].Value.ToString();
tencongty = workSheet.Cells[rowIterator, 2].Value.ToString();
if (workSheet.Cells[rowIterator, 3].Value != null)
{
phanloaikhach = workSheet.Cells[rowIterator, 3].Value.ToString();
}
else
{
phanloaikhach = "";
}
if (workSheet.Cells[rowIterator, 4].Value != null)
{
nhomnganh = workSheet.Cells[rowIterator, 4].Value.ToString();
}
else
{
nhomnganh = "";
}
if (workSheet.Cells[rowIterator, 4].Value != null)
{
nhomnganh = workSheet.Cells[rowIterator, 4].Value.ToString();
}
else
{
nhomnganh = "";
}
if (workSheet.Cells[rowIterator, 5].Value != null)
{
diachivpgiaodich = workSheet.Cells[rowIterator, 5].Value.ToString();
}
else
{
diachivpgiaodich = "";
}
if (workSheet.Cells[rowIterator, 6].Value != null)
{
diachixuathoadon = workSheet.Cells[rowIterator, 6].Value.ToString();
}
else
{
diachixuathoadon = "";
}
if (workSheet.Cells[rowIterator, 7].Value != null)
{
MST = workSheet.Cells[rowIterator, 7].Value.ToString();
}
else
{
MST = "";
}
if (workSheet.Cells[rowIterator, 8].Value != null)
{
somayban = workSheet.Cells[rowIterator, 8].Value.ToString();
}
else
{
somayban = "";
}
if (workSheet.Cells[rowIterator, 9].Value != null)
{
fax = workSheet.Cells[rowIterator, 9].Value.ToString();
}
else
{
fax = "";
}
if (workSheet.Cells[rowIterator, 10].Value != null)
{
email = workSheet.Cells[rowIterator, 10].Value.ToString();
}
else
{
email = "";
}
if (workSheet.Cells[rowIterator, 11].Value != null)
{
logo = workSheet.Cells[rowIterator, 11].Value.ToString();
}
else
{
logo = "";
}
if (workSheet.Cells[rowIterator, 12].Value != null)
{
website = workSheet.Cells[rowIterator, 12].Value.ToString();
}
else
{
website = "";
}
if (workSheet.Cells[rowIterator, 13].Value != null)
{
tinh = workSheet.Cells[rowIterator, 13].Value.ToString();
}
else
{
tinh = "";
}
if (workSheet.Cells[rowIterator, 14].Value != null)
{
quocgia = workSheet.Cells[rowIterator, 14].Value.ToString();
}
else
{
quocgia = "";
}
if (workSheet.Cells[rowIterator, 15].Value != null)
{
dieukhoanthanhtoan = workSheet.Cells[rowIterator, 15].Value.ToString();
}
else
{
dieukhoanthanhtoan = "";
}
if (workSheet.Cells[rowIterator, 16].Value != null)
{
songayduocno = workSheet.Cells[rowIterator, 16].Value.ToString();
}
else
{
songayduocno = "";
}
if (workSheet.Cells[rowIterator, 17].Value != null)
{
sonotoida = workSheet.Cells[rowIterator, 17].Value.ToString();
}
else
{
sonotoida = "";
}
if (workSheet.Cells[rowIterator, 18].Value != null)
{
tinhtranghoatdong = workSheet.Cells[rowIterator, 18].Value.ToString();
}
else
{
tinhtranghoatdong = "";
}
if (workSheet.Cells[rowIterator, 19].Value != null)
{
tructhuoc = workSheet.Cells[rowIterator, 19].Value.ToString();
}
else
{
tructhuoc = "";
}
if (workSheet.Cells[rowIterator, 20].Value != null)
{
ghichu = workSheet.Cells[rowIterator, 20].Value.ToString();
}
else
{
ghichu = "";
}
if (workSheet.Cells[rowIterator, 21].Value != null)
{
phutrachhienthoi = workSheet.Cells[rowIterator, 21].Value.ToString();
}
else
{
phutrachhienthoi = "";
}
if (workSheet.Cells[rowIterator, 22].Value != null)
{
nguoilienhe = workSheet.Cells[rowIterator, 22].Value.ToString();
}
else
{
nguoilienhe = "";
}
if (workSheet.Cells[rowIterator, 23].Value != null)
{
chucvu = workSheet.Cells[rowIterator, 23].Value.ToString();
}
else
{
chucvu = "";
}
if (workSheet.Cells[rowIterator, 24].Value != null)
{
phongban = workSheet.Cells[rowIterator, 24].Value.ToString();
}
else
{
phongban = "";
}
if (workSheet.Cells[rowIterator, 25].Value != null)
{
ngaysinh = workSheet.Cells[rowIterator, 25].Value.ToString();
}
else
{
ngaysinh = "";
}
if (workSheet.Cells[rowIterator, 26].Value != null)
{
gioitinh = workSheet.Cells[rowIterator, 26].Value.ToString();
}
else
{
gioitinh = "";
}
if (workSheet.Cells[rowIterator, 27].Value != null)
{
sdt1 = workSheet.Cells[rowIterator, 27].Value.ToString();
}
else
{
sdt1 = "";
}
if (workSheet.Cells[rowIterator, 28].Value != null)
{
sdt2 = workSheet.Cells[rowIterator, 28].Value.ToString();
}
else
{
sdt2 = "";
}
if (workSheet.Cells[rowIterator, 29].Value != null)
{
emailcanhan = workSheet.Cells[rowIterator, 29].Value.ToString();
}
else
{
emailcanhan = "";
}
if (workSheet.Cells[rowIterator, 30].Value != null)
{
emailcongty = workSheet.Cells[rowIterator, 30].Value.ToString();
}
else
{
emailcongty = "";
}
if (workSheet.Cells[rowIterator, 31].Value != null)
{
skype = workSheet.Cells[rowIterator, 31].Value.ToString();
}
else
{
skype = "";
}
if (workSheet.Cells[rowIterator, 32].Value != null)
{
facebook = workSheet.Cells[rowIterator, 32].Value.ToString();
}
else
{
facebook = "";
}
if (workSheet.Cells[rowIterator, 33].Value != null)
{
ghichulienhe = workSheet.Cells[rowIterator, 33].Value.ToString();
}
else
{
ghichulienhe = "";
}
if (workSheet.Cells[rowIterator, 34].Value != null)
{
salephutrach = workSheet.Cells[rowIterator, 34].Value.ToString();
}
else
{
salephutrach = "";
}
if (workSheet.Cells[rowIterator, 35].Value != null)
{
sotknganhang = workSheet.Cells[rowIterator, 36].Value.ToString();
}
else
{
sotknganhang = "";
}
if (workSheet.Cells[rowIterator, 36].Value != null)
{
tentaikhoan = workSheet.Cells[rowIterator, 36].Value.ToString();
}
else
{
tentaikhoan = "";
}
if (workSheet.Cells[rowIterator, 37].Value != null)
{
tennganhang = workSheet.Cells[rowIterator, 37].Value.ToString();
}
else
{
tennganhang = "";
}
if (workSheet.Cells[rowIterator, 38].Value != null)
{
chinhanhnganhang = workSheet.Cells[rowIterator, 38].Value.ToString();
}
else
{
chinhanhnganhang = "";
}
if (workSheet.Cells[rowIterator, 39].Value != null)
{
tinhnganhang = workSheet.Cells[rowIterator, 39].Value.ToString();
}
else
{
tinhnganhang = "";
}
if (workSheet.Cells[rowIterator, 40].Value != null)
{
loaitaikhoan = workSheet.Cells[rowIterator, 40].Value.ToString();
}
else
{
loaitaikhoan = "";
}
if (workSheet.Cells[rowIterator, 41].Value != null)
{
ghichu = workSheet.Cells[rowIterator, 41].Value.ToString();
}
else
{
ghichu = "";
}
//Thêm khách hàng
var query = db.KHs.Where(x => x.MA_KHACH_HANG == makhach).FirstOrDefault();
if (query == null)
{
KH khachhang = new KH();
khachhang.MA_KHACH_HANG = makhach;
khachhang.TEN_CONG_TY = tencongty;
if (diachivpgiaodich != "")
{
khachhang.VAN_PHONG_GIAO_DICH = diachivpgiaodich;
}
if (diachixuathoadon != "")
{
khachhang.DIA_CHI_XUAT_HOA_DON = diachixuathoadon;
}
if (MST != "")
{
khachhang.MST = MST;
}
if (somayban != "")
{
khachhang.HOTLINE = somayban;
}
if (fax != "")
{
khachhang.FAX = fax;
}
if (email != "")
{
khachhang.EMAIL = email;
}
if (logo != "")
{
khachhang.LOGO = logo;
}
if (website != "")
{
khachhang.WEBSITE = website;
}
if (tinh != "")
{
khachhang.TINH = tinh;
}
if (quocgia != "")
{
khachhang.QUOC_GIA = quocgia;
}
if (dieukhoanthanhtoan != "")
{
khachhang.DIEU_KHOAN_THANH_TOAN = dieukhoanthanhtoan;
}
if (songayduocno != "")
{
khachhang.SO_NGAY_DUOC_NO = Convert.ToInt32(songayduocno);
}
if (sonotoida != "")
{
khachhang.SO_NO_TOI_DA = Convert.ToInt32(sonotoida);
}
if (tinhtranghoatdong != "")
{
khachhang.TINH_TRANG_HOAT_DONG = tinhtranghoatdong;
}
if (tructhuoc != "")
{
khachhang.TRUC_THUOC = tructhuoc;
}
if (ghichu != "")
{
khachhang.GHI_CHU = ghichu;
}
db.KHs.Add(khachhang);
db.SaveChanges();
//thêm phụ trách hiện thời
if (phutrachhienthoi != "")
{
KH_CHUYEN_SALES chuyensale = new KH_CHUYEN_SALES();
chuyensale.MA_KHACH_HANG = makhach;
chuyensale.SALE_HIEN_THOI = phutrachhienthoi;
db.KH_CHUYEN_SALES.Add(chuyensale);
}
//Thêm phân loại khách
var DATA = db.KH_PHAN_LOAI_KHACH.Where(x => x.MA_KHACH_HANG == makhach).FirstOrDefault();
if (DATA != null && phanloaikhach != "")
{
KH_PHAN_LOAI_KHACH plkhach = new KH_PHAN_LOAI_KHACH();
plkhach.MA_KHACH_HANG = makhach;
plkhach.MA_LOAI_KHACH = phanloaikhach;
if (nhomnganh != "")
{
plkhach.NHOM_NGANH = nhomnganh;
}
db.KH_PHAN_LOAI_KHACH.Add(plkhach);
db.SaveChanges();
}
//thêm người liên hệ
if (nguoilienhe != "")
{
KH_LIEN_HE lhkhach = new KH_LIEN_HE();
lhkhach.MA_KHACH_HANG = makhach;
lhkhach.NGUOI_LIEN_HE = nguoilienhe;
if (chucvu != "")
{
lhkhach.CHUC_VU = chucvu;
}
if (phongban != "")
{
lhkhach.PHONG_BAN = phongban;
}
if (ngaysinh != "")
{
lhkhach.NGAY_SINH = xulydate.Xulydatetime(ngaysinh);
}
if (gioitinh != "")
{
lhkhach.GIOI_TINH = gioitinh;
}
lhkhach.SDT1 = sdt1;
if (sdt2 != "")
{
lhkhach.SDT2 = sdt2;
}
if (emailcanhan != "")
{
lhkhach.EMAIL_CA_NHAN = emailcanhan;
}
if (emailcongty != "")
{
lhkhach.EMAIL_CONG_TY = emailcongty;
}
if (skype != "")
{
lhkhach.SKYPE = skype;
}
if (facebook != "")
{
lhkhach.FACEBOOK = facebook;
}
if (ghichulienhe != "")
{
lhkhach.GHI_CHU = ghichu;
}
db.KH_LIEN_HE.Add(lhkhach);
db.SaveChanges();
//thêm sale phụ trách
var datalienhe = db.KH_LIEN_HE.Where(x => x.SDT1 == sdt1).FirstOrDefault();
if (datalienhe != null)
{
KH_SALES_PHU_TRACH salept = new KH_SALES_PHU_TRACH();
salept.ID_LIEN_HE = datalienhe.ID_LIEN_HE;
salept.SALES_PHU_TRACH = salephutrach;
salept.NGAY_BAT_DAU_PHU_TRACH = DateTime.Today.Date;
salept.TRANG_THAI = true;
db.KH_SALES_PHU_TRACH.Add(salept);
db.SaveChanges();
}
//thêm tài khoản ngân hàng
if (sotknganhang != "")
{
KH_TK_NGAN_HANG tkkhach = new KH_TK_NGAN_HANG();
tkkhach.MA_KHACH_HANG = makhach;
tkkhach.SO_TAI_KHOAN = sotknganhang;
if (tentaikhoan != "")
{
tkkhach.TEN_TAI_KHOAN = tentaikhoan;
}
if (tennganhang != "")
{
tkkhach.TEN_NGAN_HANG = tennganhang;
}
if (chinhanhnganhang != "")
{
tkkhach.CHI_NHANH = chinhanhnganhang;
}
if (tinhnganhang != "")
{
tkkhach.TINH_TP = tinhnganhang;
}
if (loaitaikhoan != "")
{
tkkhach.LOAI_TAI_KHOAN = loaitaikhoan;
}
if (ghichutaikhoan != "")
{
tkkhach.GHI_CHU = ghichutaikhoan;
}
db.KH_TK_NGAN_HANG.Add(tkkhach);
db.SaveChanges();
}
}
}
//trường hợp đã có khách hàng, chỉ thêm liên hệ, ...
else
if (query != null)
{
//thêm liên hệ
if (nguoilienhe != "")
{
KH_LIEN_HE lhkhach = new KH_LIEN_HE();
lhkhach.MA_KHACH_HANG = makhach;
lhkhach.NGUOI_LIEN_HE = nguoilienhe;
if (chucvu != "")
{
lhkhach.CHUC_VU = chucvu;
}
if (phongban != "")
{
lhkhach.PHONG_BAN = phongban;
}
if (ngaysinh != "")
{
lhkhach.NGAY_SINH = xulydate.Xulydatetime(ngaysinh);
}
if (gioitinh != "")
{
lhkhach.GIOI_TINH = gioitinh;
}
lhkhach.SDT1 = sdt1;
if (sdt2 != "")
{
lhkhach.SDT2 = sdt2;
}
if (emailcanhan != "")
{
lhkhach.EMAIL_CA_NHAN = emailcanhan;
}
if (emailcongty != "")
{
lhkhach.EMAIL_CONG_TY = emailcongty;
}
if (skype != "")
{
lhkhach.SKYPE = skype;
}
if (facebook != "")
{
lhkhach.FACEBOOK = facebook;
}
if (ghichu != "")
{
lhkhach.GHI_CHU = ghichu;
}
db.KH_LIEN_HE.Add(lhkhach);
db.SaveChanges();
//thêm sale phụ trách
var datalienhe = db.KH_LIEN_HE.Where(x => x.SDT1 == sdt1).FirstOrDefault();
if (datalienhe != null)
{
KH_SALES_PHU_TRACH salept = new KH_SALES_PHU_TRACH();
salept.ID_LIEN_HE = datalienhe.ID_LIEN_HE;
salept.SALES_PHU_TRACH = salephutrach;
salept.NGAY_BAT_DAU_PHU_TRACH = DateTime.Today.Date;
salept.TRANG_THAI = true;
db.KH_SALES_PHU_TRACH.Add(salept);
db.SaveChanges();
}
//thêm tài khoản ngân hàng
if (sotknganhang != "")
{
KH_TK_NGAN_HANG tkkhach = new KH_TK_NGAN_HANG();
tkkhach.MA_KHACH_HANG = makhach;
tkkhach.SO_TAI_KHOAN = sotknganhang;
if (tentaikhoan != "")
{
tkkhach.TEN_TAI_KHOAN = tentaikhoan;
}
if (tennganhang != "")
{
tkkhach.TEN_NGAN_HANG = tennganhang;
}
if (chinhanhnganhang != "")
{
tkkhach.CHI_NHANH = chinhanhnganhang;
}
if (tinhnganhang != "")
{
tkkhach.TINH_TP = tinhnganhang;
}
if (loaitaikhoan != "")
{
tkkhach.LOAI_TAI_KHOAN = loaitaikhoan;
}
if (ghichutaikhoan != "")
{
tkkhach.GHI_CHU = ghichutaikhoan;
}
db.KH_TK_NGAN_HANG.Add(tkkhach);
db.SaveChanges();
}
}
}
so_dong_thanh_cong++;
dong = rowIterator;
}
}
}
}
}
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 các dòng: " + dong;
}
finally
{
ViewBag.Message = "Đã import thành công " + so_dong_thanh_cong + " dòng";
}
return(View());
}
