public ActionResult AddUserToGroup(string id, string data) { IDbConnection db = new OrmliteConnection().openConn(); try { // Delete All Group of User if (string.IsNullOrEmpty(id)) { return(Json(new { success = false, message = "Chọn người dùng trước khi thêm nhóm." })); } db.DeleteById <Auth_UserInRole>(id); // Add User Group if (!string.IsNullOrEmpty(data)) { string[] arr = data.Split(','); foreach (string item in arr) { var detail = new Auth_UserInRole(); detail.UserID = id; detail.RoleID = int.Parse(item); detail.RowCreatedAt = DateTime.Now; detail.RowCreatedBy = currentUser.UserID; db.Insert <Auth_UserInRole>(detail); } } return(Json(new { success = true })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public string Insert(Merchant_Folder_Info item, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { var checkID = db.FirstOrDefault <Merchant_Folder_Info>(s => s.ten_thu_muc == item.ten_thu_muc && s.ma_gian_hang == item.ma_gian_hang); if (checkID != null) { return("Folder was exists"); } else { item.ngay_tao = DateTime.Now; db.Insert(item); } dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }
public ActionResult Create(Auth_User item) { IDbConnection db = new OrmliteConnection().openConn(); try { if (!string.IsNullOrEmpty(item.UserID) && !string.IsNullOrEmpty(item.DisplayName) && !string.IsNullOrEmpty(item.FullName)) { var isExist = db.GetByIdOrDefault <Auth_User>(item.UserID); item.Phone = !string.IsNullOrEmpty(item.Phone) ? item.Phone : ""; item.Email = !string.IsNullOrEmpty(item.Email) ? item.Email : ""; item.Note = !string.IsNullOrEmpty(item.Note) ? item.Note : ""; if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.RowCreatedAt == null && item.RowCreatedBy == null) { if (isExist != null) { return(Json(new { success = false, message = "Người dùng đã tồn tại." })); } item.Password = SqlHelper.GetMd5Hash("123456"); item.RowCreatedAt = DateTime.Now; item.RowCreatedBy = currentUser.UserID; db.Insert <Auth_User>(item); return(Json(new { success = true, UserID = item.UserID, RowCreatedAt = item.RowCreatedAt, RowCreatedBy = item.RowCreatedBy })); } else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null) { item.Password = isExist.Password; item.RowUpdatedAt = DateTime.Now; item.RowUpdatedBy = currentUser.UserID; if (isExist.RowCreatedBy != "system") { db.Update <Auth_User>(item); } else { return(Json(new { success = false, message = "Dữ liệu này không cho chỉnh sửa liên hệ admin để biết thêm chi tiết" })); } return(Json(new { success = true })); } else { return(Json(new { success = false, message = "Bạn không có quyền" })); } } else { return(Json(new { success = false, message = "Chưa nhập giá trị" })); } } catch (Exception e) { log.Error("AD_User - Create - " + e.Message); return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public string UpSert(List <Product_Hierarchy_Property> lstProductHierarchyProperty, string UserName, string Type, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (Product_Hierarchy_Property row in lstProductHierarchyProperty) { if (Type == "Insert") { row.ngay_tao = row.ngay_cap_nhat = DateTime.Now; row.nguoi_tao = row.nguoi_cap_nhat = UserName; db.Insert(row); } else { row.ngay_cap_nhat = DateTime.Now; row.nguoi_cap_nhat = UserName; db.Update(row); } } dbTrans.Commit(); return("true"); } catch (Exception ex) { dbTrans.Rollback(); return(ex.Message); } } } }
//public ActionResult ReadDetail([DataSourceRequest] DataSourceRequest request, string SONumber) //{ // log4net.Config.XmlConfigurator.Configure(); // string whereCondition = ""; // if (request.Filters.Count > 0) // { // whereCondition = " AND " + new KendoApplyFilter().ApplyFilter(request.Filters[0]); // } // var data = new DC_AD_SO_Detail().GetPage(request, whereCondition, SONumber); // return Json(data); //} public ActionResult Update([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <Products> list, string SONumber) { var dbConn = new OrmliteConnection().openConn(); try { if (list != null && ModelState.IsValid) { foreach (var item in list) { if (item.Qty > 0) { //string SONumber = Request["SONumber"]; var header = new SOHeader(); var detail = new SODetail(); if (dbConn.Select <SODetail>(s => s.SONumber == SONumber && s.ItemCode == item.Code).Count() > 0) { dbConn.Update <SODetail>(set: "Qty = '" + item.Qty + "', TotalAmt = '" + item.Qty * item.Price + "'", where : "SONumber = '" + SONumber + "'"); } else { var data = new SODetail(); data.ItemName = item.Name; data.ItemCode = item.Code; data.Note = ""; data.Price = item.VATPrice; data.Qty = item.Qty; data.SONumber = SONumber; data.UnitID = item.Unit; data.UnitName = dbConn.Select <INUnit>(s => s.UnitID == item.Unit).FirstOrDefault().UnitName; data.TotalAmt = item.Qty * item.VATPrice; data.Status = ""; data.CreatedAt = DateTime.Now; data.CreatedBy = currentUser.UserID; //data.UpdatedAt = DateTime.Parse("1900-01-01"); data.UpdatedAt = DateTime.Now; data.UpdatedBy = ""; dbConn.Insert <SODetail>(data); } dbConn.Update <SOHeader>(set: "TotalQty ='" + dbConn.Select <SODetail>(s => s.SONumber == SONumber).Sum(s => s.Qty) + "', TotalAmt = '" + +dbConn.Select <SODetail>(s => s.SONumber == SONumber).Sum(s => s.TotalAmt) + "'", where : "SONumber ='" + SONumber + "'"); } else { dbConn.Delete <SOHeader>(s => s.SONumber == SONumber); ModelState.AddModelError("error", "Đơn hàng được tạo khi số lượng > 0"); return(Json(list.ToDataSourceResult(request, ModelState))); } } } dbConn.Close(); } catch (Exception e) { dbConn.Close(); ModelState.AddModelError("error", e.Message); return(Json(list.ToDataSourceResult(request, ModelState))); } return(Json(new { sussess = true })); }
public ActionResult AddTranporterToContract(string id, string data) { IDbConnection db = new OrmliteConnection().openConn(); try { db.Delete <DC_LG_Contract_Transporter>(p => p.ContractID == id); if (!string.IsNullOrEmpty(data)) { string[] arr = data.Split(','); foreach (string item in arr) { var detail = new DC_LG_Contract_Transporter(); detail.ContractID = id; detail.TransporterID = int.Parse(item); detail.Note = ""; detail.UpdatedAt = DateTime.Now; detail.CreatedAt = DateTime.Now; detail.CreatedBy = currentUser.UserID; detail.UpdatedBy = currentUser.UserID; db.Insert <DC_LG_Contract_Transporter>(detail); } } return(Json(new { success = true })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult AddUserToGroup(int id, string data) { IDbConnection db = new OrmliteConnection().openConn(); try { // Delete All User in Role db.Delete <Auth_UserInRole>(p => p.RoleID == id); // Add User Role if (!string.IsNullOrEmpty(data)) { string[] arr = data.Split(','); foreach (string item in arr) { var detail = new Auth_UserInRole(); detail.UserID = item; detail.RoleID = id; detail.RowCreatedAt = DateTime.Now; detail.RowCreatedBy = currentUser.UserID; db.Insert <Auth_UserInRole>(detail); } } return(Json(new { success = true })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult Create(DC_LG_Discountion item) { IDbConnection db = new OrmliteConnection().openConn(); try { if (!string.IsNullOrEmpty(item.DiscountionID) && !string.IsNullOrEmpty(item.DiscountionName) ) { var isExist = db.SingleOrDefault <DC_LG_Discountion>("DiscountionID={0}", item.DiscountionID); item.FromDate = item.FromDate != null ? item.FromDate : DateTime.Now; item.EndDate = item.EndDate != null ? item.EndDate : DateTime.Now; item.EndDate = item.EndDate != null ? item.EndDate : DateTime.Now; if (item.FromDate > item.EndDate) { return(Json(new { success = false, message = "Ngày kết thúc không thể lớn hơn " + item.FromDate })); } item.Note = !string.IsNullOrEmpty(item.Note) ? item.Note : ""; item.DiscountionType = !string.IsNullOrEmpty(item.DiscountionType) ? item.DiscountionType : ""; if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.CreatedAt == null && item.CreatedBy == null) { if (isExist != null) { return(Json(new { success = false, message = "Mã chương trình chiết khấu đã tồn tại" })); } item.DiscountionName = !string.IsNullOrEmpty(item.DiscountionName) ? item.DiscountionName : ""; item.CreatedAt = DateTime.Now; item.UpdatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; db.Insert(item); return(Json(new { success = true, DiscountionID = item.DiscountionID, CreatedBy = item.CreatedBy, CreatedAt = item.CreatedAt })); } else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null) { item.DiscountionName = !string.IsNullOrEmpty(item.DiscountionName) ? item.DiscountionName : ""; item.CreatedAt = item.CreatedAt; item.UpdatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; db.Update(item); return(Json(new { success = true })); } else { return(Json(new { success = false, message = "Bạn không có quyền" })); } } else { return(Json(new { success = false, message = "Chưa nhập đủ giá trị" })); } } catch (Exception e) { log.Error("DeliveryDiscountion - Create - " + e.Message); return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public string CreateUpdate(Footer footer, string UserName, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { try { var checkID = db.SingleOrDefault <Footer>("ma_footer={0}", footer.ma_footer); if (checkID != null) { footer.id = checkID.id; footer.nguoi_tao = checkID.nguoi_tao; footer.ngay_tao = checkID.ngay_tao; footer.nguoi_cap_nhat = UserName; footer.ngay_cap_nhat = DateTime.Now; db.Update(footer); } else { var lastId = db.FirstOrDefault <Footer>("SELECT TOP 1 * FROM Footer ORDER BY id DESC"); if (lastId != null) { if (lastId.ma_footer.Contains("FOO")) { var nextNo = Int32.Parse(lastId.ma_footer.Substring(3, 10)) + 1; footer.ma_footer = "FOO" + String.Format("{0:0000000000}", nextNo); } } else { footer.ma_footer = "FOO" + "0000000001"; } footer.ten_footer = !string.IsNullOrEmpty(footer.ten_footer) ? footer.ten_footer : ""; footer.url_link = !string.IsNullOrEmpty(footer.url_link) ? footer.url_link : ""; footer.image_link = !string.IsNullOrEmpty(footer.image_link) ? footer.image_link : ""; footer.noi_dung = !string.IsNullOrEmpty(footer.noi_dung) ? footer.noi_dung : ""; footer.levels = footer.levels != 0 ? footer.levels : 0; footer.orders = footer.orders != 0 ? footer.orders : 0; footer.hinh_anh = footer.hinh_anh; footer.loai = !string.IsNullOrEmpty(footer.loai) ? footer.loai : ""; footer.nguoi_tao = UserName; footer.ngay_tao = DateTime.Now; footer.nguoi_cap_nhat = UserName; footer.ngay_cap_nhat = DateTime.Parse("01/01/1900"); db.Insert(footer); } //SyncToMySQL List <SqlParameter> lstParameter = new List <SqlParameter>(); lstParameter.Clear(); lstParameter.Add(new SqlParameter("@ma_footer", footer.ma_footer)); new SqlHelper(connectionString).ExecuteNoneQuery("p_Footer_SyncToMySQL", lstParameter); return("true@@" + footer.ma_footer); } catch (Exception e) { return("false@@" + e.Message); } } }
public string CreateUpdate(BrandManagement brand, string UserName, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { try { var checkID = db.SingleOrDefault <BrandManagement>("ma_thuong_hieu={0}", brand.ma_thuong_hieu); if (checkID != null) { checkID.logo = (!string.IsNullOrEmpty(brand.logo) && checkID.logo != brand.logo) ? brand.logo : checkID.logo; checkID.ten_thuong_hieu = !string.IsNullOrEmpty(brand.ten_thuong_hieu) ? brand.ten_thuong_hieu : checkID.ten_thuong_hieu; checkID.trang_thai = !string.IsNullOrEmpty(brand.trang_thai) ? brand.trang_thai : checkID.trang_thai; checkID.mo_ta = !string.IsNullOrEmpty(brand.mo_ta) ? brand.mo_ta : checkID.mo_ta; checkID.slug = StringHelper.convertToUnSign3(brand.ten_thuong_hieu); checkID.nguoi_cap_nhat = UserName; checkID.ngay_cap_nhat = DateTime.Now; db.Update(checkID); } else { var lastId = db.FirstOrDefault <BrandManagement>("SELECT TOP 1 * FROM BrandManagement ORDER BY id DESC"); if (lastId != null) { if (lastId.ma_thuong_hieu.Contains("BRA")) { var nextNo = Int32.Parse(lastId.ma_thuong_hieu.Substring(3, 10)) + 1; brand.ma_thuong_hieu = "BRA" + String.Format("{0:0000000000}", nextNo); } } else { brand.ma_thuong_hieu = "BRA" + "0000000001"; } brand.logo = !string.IsNullOrEmpty(brand.logo) ? brand.logo : ""; brand.ten_thuong_hieu = !string.IsNullOrEmpty(brand.ten_thuong_hieu) ? brand.ten_thuong_hieu : ""; brand.trang_thai = !string.IsNullOrEmpty(brand.trang_thai) ? brand.trang_thai : AllConstant.trang_thai.DANG_SU_DUNG; brand.mo_ta = !string.IsNullOrEmpty(brand.mo_ta) ? brand.mo_ta : ""; brand.slug = StringHelper.convertToUnSign3(brand.ten_thuong_hieu); brand.nguoi_tao = UserName; brand.ngay_tao = DateTime.Now; brand.nguoi_cap_nhat = UserName; brand.ngay_cap_nhat = DateTime.Now; db.Insert(brand); } //SyncToMySQL List <SqlParameter> lstParameter = new List <SqlParameter>(); lstParameter.Clear(); lstParameter.Add(new SqlParameter("@ma_thuong_hieu", brand.ma_thuong_hieu)); new SqlHelper(connectionString).ExecuteNoneQuery("p_Brand_SyncToMySQL", lstParameter); return("true@@" + brand.ma_thuong_hieu); } catch (Exception e) { return("false@@" + e.Message); } } }
// // GET: /DeliveryManage/Create public ActionResult Create(DC_LG_Transporter item) { IDbConnection db = new OrmliteConnection().openConn(); try { if (//!string.IsNullOrEmpty(item.TransporterID) && !string.IsNullOrEmpty(item.TransporterName) ) { int n; var isExist = db.SingleOrDefault <DC_LG_Transporter>("TransporterID={0}", item.TransporterID); item.Weight = int.TryParse(item.Weight.ToString(), out n) ? item.Weight : 0; item.Note = !string.IsNullOrEmpty(item.Note) ? item.Note : ""; if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.CreatedAt == null && item.CreatedBy == null) { if (isExist != null) { return(Json(new { success = false, message = "Mã đơn vị vận chuyển đã tồn tại!" })); } item.TransporterName = !string.IsNullOrEmpty(item.TransporterName) ? item.TransporterName : ""; item.CreatedAt = DateTime.Now; item.UpdatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; item.UpdatedBy = currentUser.UserID; db.Insert(item); return(Json(new { success = true, TransporterID = item.TransporterID, CreatedBy = item.CreatedBy, CreatedAt = item.CreatedAt })); } else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null) { item.TransporterName = !string.IsNullOrEmpty(item.TransporterName) ? item.TransporterName : ""; item.CreatedAt = item.CreatedAt; item.UpdatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; item.UpdatedBy = currentUser.UserID; db.Update(item); return(Json(new { success = true })); } else { return(Json(new { success = false, message = "Bạn không có quyền" })); } } else { return(Json(new { success = false, message = "Chưa nhập giá trị" })); } } catch (Exception e) { log.Error("Transporter - Create - " + e.Message); return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public string Upsert(List <Merchant_Product_Promotion> list, string UserName, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (Merchant_Product_Promotion item in list) { var checkID = db.SingleOrDefault <Merchant_Product_Promotion>("id={0}", item.id); if (checkID != null) { checkID.nguoi_cap_nhat = UserName; checkID.ngay_cap_nhat = DateTime.Now; checkID.ten_chuong_trinh_km = item.ten_chuong_trinh_km; checkID.loai = item.loai; checkID.gia_tri = item.gia_tri; db.Update(checkID); } else { string PromotionID = String.Empty; var lastId = db.FirstOrDefault <Merchant_Product_Promotion>("SELECT TOP 1 * FROM Merchant_Product_Promotion ORDER BY id DESC"); if (lastId != null) { if (lastId.ma_chuong_trinh_km.Contains("KM")) { var nextNo = Int32.Parse(lastId.ma_chuong_trinh_km.Substring(2, 7)) + 1; PromotionID = "KM" + String.Format("{0:0000000}", nextNo); } } else { PromotionID = "KM" + "0000001"; } item.trang_thai = AllConstant.trang_thai.DANG_SU_DUNG; item.ma_chuong_trinh_km = PromotionID; item.ngay_tao = DateTime.Now; item.nguoi_tao = UserName; item.ngay_cap_nhat = DateTime.Parse("1900-1-1"); db.Insert(item); } } dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }
public string CreateMerchant(Merchant_Info row, string UserName, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { //using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { var checkID = db.SingleOrDefault <Merchant_Info>("id={0}", row.id); if (checkID == null) { string ma_gian_hang = String.Empty; var lastId = db.FirstOrDefault <Merchant_Info>("SELECT TOP 1 * FROM Merchant_Info ORDER BY id DESC"); if (lastId != null) { if (lastId.ma_gian_hang.Contains("GH")) { var nextNo = Int32.Parse(lastId.ma_gian_hang.Substring(7, 2)) + 1; ma_gian_hang = "GH" + String.Format("{0:0000000}", nextNo); } } else { ma_gian_hang = "GH0000001"; } row.ma_gian_hang = ma_gian_hang; row.slug = StringHelper.convertToUnSign3(row.ten_gian_hang); row.ngay_tao = DateTime.Now; row.nguoi_tao = UserName; row.ngay_tiep_xuc = !string.IsNullOrEmpty(row.ngay_tiep_xuc.ToString()) ? row.ngay_tiep_xuc : DateTime.Parse("1900-01-01"); row.ngay_ky_hop_dong = !string.IsNullOrEmpty(row.ngay_tiep_xuc.ToString()) ? row.ngay_tiep_xuc : DateTime.Parse("1900-01-01"); row.ngay_duyet = !string.IsNullOrEmpty(row.ngay_duyet.ToString()) ? row.ngay_duyet : DateTime.Parse("1900-01-01"); row.ngay_hoat_dong = !string.IsNullOrEmpty(row.ngay_hoat_dong.ToString()) ? row.ngay_hoat_dong : DateTime.Parse("1900-01-01"); row.trang_thai_duyet = AllConstant.trang_thai_duyet.CHUA_DUYET; row.trang_thai_xuat_ban = AllConstant.trang_thai_xuat_ban.CHUA_XUAT_BAN; row.trang_thai_xac_thuc = AllConstant.trang_thai_xac_thuc.CHUA_XAC_THUC; row.ngay_tao = DateTime.Now; row.nguoi_tao = "System"; row.ngay_cap_nhat = DateTime.Now; row.nguoi_cap_nhat = "System"; db.Insert(row); new SqlHelper().ExecuteNoneQuery("update tw_User set ma_gian_hang='" + ma_gian_hang + "' where name='" + UserName + "'", new List <SqlParameter>(), CommandType.Text); } //dbTrans.Commit(); return("true"); } catch (Exception e) { //dbTrans.Rollback(); return(e.Message.ToString()); } } } }
public string UpSert(List <Image_Info> list, string UserName, string Type, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (Image_Info row in list) { var checkID = db.SingleOrDefault <Image_Info>("id={0}", row.id); if (checkID != null) { row.ngay_cap_nhat = DateTime.Now; row.nguoi_cap_nhat = UserName; row.nguoi_tao = checkID.nguoi_tao; row.ngay_tao = checkID.ngay_tao; db.Update(row); } else { string ma_tu_tang = String.Empty; var lastId = db.FirstOrDefault <Image_Info>("SELECT TOP 1 * FROM Image_Info ORDER BY id DESC"); if (lastId != null) { if (lastId.ma_thong_tin_anh.Contains("IM")) { var nextNo = Int32.Parse(lastId.ma_thong_tin_anh.Substring(2, 13)) + 1; ma_tu_tang = "IM" + String.Format("{0:0000000000000}", nextNo); } } else { ma_tu_tang = "IM0000000000001"; } row.ma_thong_tin_anh = ma_tu_tang; row.ngay_tao = DateTime.Now; row.ngay_duyet = row.ngay_cap_nhat = DateTime.Parse("1900-01-01"); row.nguoi_tao = UserName; row.nguoi_cap_nhat = row.nguoi_duyet = ""; db.Insert(row); } } dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }
public ActionResult Registry(RegistryModel item) { IDbConnection db = new OrmliteConnection().openConn(); try { var isExist = db.FirstOrDefault <Auth_User>(p => p.UserID == item.UserName); item.Phone = !string.IsNullOrEmpty(item.Phone) ? item.Phone : ""; item.Email = !string.IsNullOrEmpty(item.Email) ? item.Email : ""; item.UserName = !string.IsNullOrEmpty(item.UserName) ? item.UserName : ""; if (isExist != null) { return(Json(new { success = false, message = "Người dùng đã tồn tại" })); } var user = new Auth_User(); user.UserID = item.UserName; user.DisplayName = item.UserName; user.Phone = item.Phone; user.Email = item.Email; user.IsActive = true; user.FullName = item.UserName; user.Password = SqlHelper.GetMd5Hash(item.Password); user.RowCreatedAt = DateTime.Now; user.RowCreatedBy = "CustomerRegistry"; user.Note = ""; db.Insert <Auth_User>(user); var detail = new Auth_UserInRole(); detail.UserID = item.UserName; detail.RoleID = 3; detail.RowCreatedAt = DateTime.Now; detail.RowCreatedBy = "CustomerRegistry"; db.Insert <Auth_UserInRole>(detail); return(Json(new { success = true, message = "Đăng ký thành công" })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public string UpSert(List <Merchant_Image> lstProdInfo, string UserName, string Type, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (Merchant_Image row in lstProdInfo) { var checkID = db.SingleOrDefault <Merchant_Image>("id={0}", row.id); if (checkID != null) { if (String.IsNullOrEmpty(row.ten_anh)) { row.ten_anh = checkID.ten_anh; } else { if (!String.IsNullOrEmpty(checkID.ten_anh)) { var path = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Images/Merchant_Info/"), checkID.ten_anh); if (!String.IsNullOrEmpty(path)) { System.IO.File.Delete(path); } } } row.ngay_cap_nhat = DateTime.Now; row.nguoi_cap_nhat = UserName; db.Update(EmptyIfNull(row)); } else { //row.ngay_duyet = row.ngay_xuat_ban = DateTime.Now;//chua biet row.ngay_tao = row.ngay_cap_nhat = DateTime.Now; //row.nguoi_duyet = row.nguoi_tao = UserName; row.nguoi_tao = UserName; db.Insert(EmptyIfNull(row)); } } dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }
public string UpSert(List <Property_Detail> lstProperty, string UserName, string Type, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (Property_Detail row in lstProperty) { if (Type == "Insert") { string ma_thuoc_tinh = String.Empty; var lastId = db.FirstOrDefault <Property_Detail>("SELECT TOP 1 * FROM Property_Detail ORDER BY ma_thuoc_tinh DESC"); if (lastId != null) { if (lastId.ma_thuoc_tinh.Contains("MTT")) { var nextNo = Int32.Parse(lastId.ma_thuoc_tinh.Substring(3, 5)) + 1; ma_thuoc_tinh = "MTT" + String.Format("{0:00000}", nextNo); } } else { ma_thuoc_tinh = "MTT" + "00001"; } row.ma_thong_so = row.ma_thong_so; row.ma_thuoc_tinh = ma_thuoc_tinh; row.ngay_tao = row.ngay_cap_nhat = DateTime.Now; row.nguoi_tao = row.nguoi_cap_nhat = UserName; db.Insert(row); } else { row.ngay_cap_nhat = DateTime.Now; row.nguoi_cap_nhat = UserName; db.Update(row); } } dbTrans.Commit(); return("true"); } catch (Exception ex) { dbTrans.Rollback(); return(ex.Message); } } } }
// // GET: /DeliveryManage/Create public ActionResult Create(DC_Reason item) { IDbConnection db = new OrmliteConnection().openConn(); try { if (!string.IsNullOrEmpty(item.ReasonID) && item.ReasonType != "None") { var isExist = db.GetByIdOrDefault <DC_Reason>(item.ReasonID); item.Description = !string.IsNullOrEmpty(item.Description) ? item.Description : ""; if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.RowCreatedAt == null && item.RowCreatedBy == null) { if (isExist != null) { return(Json(new { success = false, message = "Mã lý do đã tồn tại!" })); } item.ReasonType = !string.IsNullOrEmpty(item.ReasonType) ? item.ReasonType : ""; item.RowCreatedAt = DateTime.Now; item.RowUpdatedAt = DateTime.Now; item.RowCreatedBy = currentUser.UserID; db.Insert <DC_Reason>(item); return(Json(new { success = true, ReasonID = item.ReasonID, RowCreatedBy = item.RowCreatedBy, RowCreatedAt = item.RowCreatedAt })); } else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null) { item.ReasonType = !string.IsNullOrEmpty(item.ReasonType) ? item.ReasonType : ""; item.RowCreatedAt = item.RowCreatedAt; item.RowUpdatedAt = DateTime.Now; item.RowCreatedBy = currentUser.UserID; db.Update <DC_Reason>(item); return(Json(new { success = true })); } else { return(Json(new { success = false, message = "Bạn không có quyền" })); } } else { return(Json(new { success = false, message = "Chưa nhập giá trị" })); } } catch (Exception e) { log.Error("DeliveryUOMManage - Create - " + e.Message); return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public int AddOrUpdate(int curruserid) { IDbConnection dbConn = new OrmliteConnection().openConn(); try { //var isexist = dbConn.GetByIdOrDefault<AuthUser>(10); var isexist = dbConn.FirstOrDefault <AuthUser>("entryid={0}", this.entryid); if (isexist == null) { this.isactive = true; this.createdat = DateTime.Now; this.createdby = curruserid; this.updatedat = DateTime.Now; this.updatedby = curruserid; this.lastlogin = DateTime.Now; dbConn.Insert <AuthUser>(this); long lastInsertId = dbConn.GetLastInsertId(); dbConn.Close(); this.entryid = Convert.ToInt32(lastInsertId); return(this.entryid); } else if (isexist != null) { this.isactive = isexist.isactive; this.loginprovider = isexist.loginprovider; this.logintype = isexist.logintype; this.createdat = isexist.createdat; this.createdby = isexist.createdby; this.updatedat = DateTime.Now; this.updatedby = curruserid; this.lastlogin = DateTime.Now; dbConn.Update <AuthUser>(this); dbConn.Close(); return(this.entryid); } else { return(0); } } catch (Exception ex) { return(0); } }
public ActionResult CreateAction([DataSourceRequest] DataSourceRequest request, int roleid, string menuid, [Bind(Prefix = "models")] IEnumerable <Auth_Action> lst) { if (userAsset.ContainsKey("Insert") && userAsset["Insert"]) { IDbConnection db = new OrmliteConnection().openConn(); foreach (var item in lst) { if (item != null) { if (string.IsNullOrEmpty(item.Action)) { ModelState.AddModelError("er", "Xin nhập quyền"); return(Json(lst.ToDataSourceResult(request, ModelState))); } var isExist = db.SingleOrDefault <Auth_Action>("RoleID = {0} AND MenuID = {1} AND Action = {2}", roleid, menuid, item.Action); if (isExist != null) { ModelState.AddModelError("er", "Quyền đã tồn tại"); return(Json(lst.ToDataSourceResult(request, ModelState))); } try { item.RoleID = roleid; item.MenuID = menuid; item.Note = ""; item.RowCreatedAt = DateTime.Now; item.RowCreatedBy = currentUser.UserID; db.Insert <Auth_Action>(item); } catch (Exception ex) { ModelState.AddModelError("er", ex.Message); return(Json(lst.ToDataSourceResult(request, ModelState))); } } } db.Close(); return(Json(lst.ToDataSourceResult(request))); } else { ModelState.AddModelError("er", "Bạn không có quyền tạo mới"); return(Json(lst.ToDataSourceResult(request, ModelState))); } }
public string UpSert(List <Banner> lstBanners, string UserName, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { try { foreach (Banner row in lstBanners) { var checkID = db.SingleOrDefault <Banner>("id={0}", row.id); if (checkID != null) { checkID.url_link = !string.IsNullOrEmpty(row.url_link.ToString()) ? row.url_link : ""; checkID.image = !string.IsNullOrEmpty(row.image) ? row.image : ""; checkID.ma_chuyen_muc = !string.IsNullOrEmpty(row.ma_chuyen_muc) ? row.ma_chuyen_muc : ""; checkID.vi_tri = !string.IsNullOrEmpty(row.vi_tri) ? row.vi_tri : ""; checkID.alt = !string.IsNullOrEmpty(row.alt) ? row.alt : ""; checkID.trang_thai = !string.IsNullOrEmpty(row.trang_thai) ? row.trang_thai : AllConstant.trang_thai.DANG_SU_DUNG; checkID.nguoi_cap_nhat = UserName; checkID.ngay_cap_nhat = DateTime.Now; db.Update(checkID); } else { row.url_link = !string.IsNullOrEmpty(row.url_link.ToString()) ? row.url_link : ""; row.image = !string.IsNullOrEmpty(row.image) ? row.image : ""; row.ma_chuyen_muc = !string.IsNullOrEmpty(row.ma_chuyen_muc) ? row.ma_chuyen_muc : ""; row.vi_tri = !string.IsNullOrEmpty(row.vi_tri) ? row.vi_tri : ""; row.trang_thai = !string.IsNullOrEmpty(row.trang_thai) ? row.trang_thai : AllConstant.trang_thai.DANG_SU_DUNG; row.alt = !string.IsNullOrEmpty(row.alt) ? row.alt : ""; row.nguoi_tao = UserName; row.ngay_tao = DateTime.Now; row.nguoi_cap_nhat = UserName; row.ngay_cap_nhat = DateTime.Now; db.Insert(row); } } return("true"); } catch (Exception e) { return(e.Message.ToString()); } } }
public string UpSert(Merchant_Catalog catalog, string UserName, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { try { var checkID = db.SingleOrDefault <Merchant_Catalog>("id={0}", catalog.id); if (checkID != null) { catalog.ngay_cap_nhat = DateTime.Now; catalog.nguoi_cap_nhat = UserName; catalog.nguoi_tao = checkID.nguoi_tao; catalog.ngay_tao = checkID.ngay_tao; db.Update(catalog); } else { catalog.nguoi_tao = UserName; catalog.nguoi_cap_nhat = UserName; catalog.ngay_tao = DateTime.Now; catalog.ngay_cap_nhat = DateTime.Now; var lastId = db.FirstOrDefault <Merchant_Catalog>("SELECT TOP 1 * FROM Merchant_Catalog ORDER BY id DESC"); if (lastId != null) { if (lastId.ma_catalog.Contains("CAT")) { var nextNo = Int32.Parse(lastId.ma_catalog.Substring(3, 10)) + 1; catalog.ma_catalog = "CAT" + String.Format("{0:0000000000}", nextNo); } } else { catalog.ma_catalog = "CAT" + "0000000001"; } db.Insert(catalog); } return("true"); } catch (Exception e) { return(e.Message.ToString()); } } }
public string UpSert(List <SEO_MerchantProduct> lstData, string UserName, string connectionString) { using (var dbConn = new OrmliteConnection().openConn(connectionString)) { try { foreach (SEO_MerchantProduct item in lstData) { if (item.id > 0) { var exist = dbConn.FirstOrDefault <SEO_MerchantProduct>(s => s.ma_san_pham == item.ma_san_pham); exist.og_description = !string.IsNullOrEmpty(item.og_description) ? item.og_description : ""; exist.og_title = !string.IsNullOrEmpty(item.og_title) ? item.og_title : ""; exist.og_image = !string.IsNullOrEmpty(item.og_image) ? item.og_image : ""; exist.og_keyword = !string.IsNullOrEmpty(item.og_keyword) ? item.og_keyword : ""; exist.robot = !string.IsNullOrEmpty(item.robot) ? item.robot : ""; exist.nguoi_cap_nhat = UserName; exist.ngay_cap_nhat = DateTime.Now; dbConn.Update(exist); } else { item.og_description = !string.IsNullOrEmpty(item.og_description) ? item.og_description : ""; item.og_title = !string.IsNullOrEmpty(item.og_title) ? item.og_title : ""; item.og_image = !string.IsNullOrEmpty(item.og_image) ? item.og_image : ""; item.og_keyword = !string.IsNullOrEmpty(item.og_keyword) ? item.og_keyword : ""; item.robot = !string.IsNullOrEmpty(item.robot) ? item.robot : ""; item.nguoi_tao = UserName; item.ngay_tao = DateTime.Now; item.nguoi_cap_nhat = UserName; item.ngay_cap_nhat = DateTime.Now; dbConn.Insert(item); } } return("true"); } catch (Exception e) { return(e.Message.ToString()); } } }
public string UpSert(List <Entities.Merchant_Product_Related> list, string ma_san_pham_de_nghi, string UserName, string Type, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (Entities.Merchant_Product_Related row in list) { var checkID = db.SingleOrDefault <Entities.Merchant_Product_Related>("ma_san_pham={0}", row.ma_san_pham_de_nghi); if (checkID == null) { string ma_tu_tang = String.Empty; var lastId = db.FirstOrDefault <Hierarchy>("SELECT TOP 1 * FROM Hierarchy ORDER BY id DESC"); if (lastId != null) { if (lastId.ma_phan_cap.Contains("CAP")) { var nextNo = Int32.Parse(lastId.ma_phan_cap.Substring(3, 3)) + 1; ma_tu_tang = "CAP" + String.Format("{0:000}", nextNo); } } else { ma_tu_tang = "CAP001"; } row.ma_san_pham_de_nghi = ma_tu_tang; db.Insert(row); } } dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }
public string UpSert(List <Merchant_Product_Hierarchy> list, string UserName, string ma_gian_hang, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (Merchant_Product_Hierarchy row in list) { var exit = db.FirstOrDefault <Merchant_Product_Hierarchy>(s => s.id == row.id); if (exit != null) { row.ngay_tao = exit.ngay_tao; row.nguoi_tao = exit.nguoi_tao; row.ngay_cap_nhat = DateTime.Now; row.nguoi_cap_nhat = UserName; db.Update(EmptyIfNull(row)); } else { row.trang_thai = AllConstant.trang_thai.DANG_SU_DUNG; row.ngay_tao = DateTime.Now; row.ngay_cap_nhat = DateTime.Parse("1900-01-01"); row.nguoi_tao = UserName; row.nguoi_cap_nhat = ""; row.ma_gian_hang = ma_gian_hang; db.Insert(EmptyIfNull(row)); } } dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }
public string UpSert(List <Merchant_Contact> list, string UserName, string Type, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (Merchant_Contact row in list) { var checkID = db.SingleOrDefault <Merchant_Contact>("id={0}", row.id); if (checkID != null) { row.ngay_cap_nhat = DateTime.Now; row.nguoi_cap_nhat = UserName; row.ngay_tao = checkID.ngay_tao; row.nguoi_cap_nhat = checkID.nguoi_tao; db.Update(EmptyIfNull(row)); } else { row.ngay_tao = row.ngay_cap_nhat = DateTime.Now; row.nguoi_tao = row.nguoi_cap_nhat = UserName; db.Insert(EmptyIfNull(row)); } } dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }
public string UpsertFull(Merchant_Voucher voucher, List <Merchant_Voucher_Detail> products, string UserName, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { Merchant_Voucher checkID; checkID = db.SingleOrDefault <Merchant_Voucher>("id={0} and ma_gian_hang = {1}", voucher.id, voucher.ma_gian_hang); //Transaction for voucher using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { if (checkID != null) { voucher.ma_khuyen_mai = checkID.ma_khuyen_mai; checkID.ten_khuyen_mai = voucher.ten_khuyen_mai; checkID.gia_tri = voucher.gia_tri; checkID.loai_khuyen_mai = voucher.loai_khuyen_mai; checkID.dieu_kien = voucher.dieu_kien; checkID.mieu_ta = voucher.mieu_ta; checkID.gia_ban = voucher.gia_ban; checkID.ngay_bat_dau = voucher.ngay_bat_dau; checkID.ngay_ket_thuc = voucher.ngay_ket_thuc; checkID.so_luong = voucher.so_luong; checkID.su_dung = voucher.su_dung; checkID.url = voucher.url; checkID.ma_anh_goc = voucher.ma_anh_goc; checkID.ngay_tao = voucher.ngay_tao; checkID.nguoi_tao = voucher.nguoi_tao; checkID.ngay_cap_nhat = DateTime.Now; checkID.nguoi_cap_nhat = UserName; checkID.trang_thai = voucher.trang_thai; db.Update(checkID); } else { var lastId = db.FirstOrDefault <Merchant_Voucher>("SELECT TOP 1 * FROM Merchant_Voucher ORDER BY id DESC"); if (lastId != null) { if (lastId.ma_khuyen_mai.Contains("VC")) { var nextNo = Int32.Parse(lastId.ma_khuyen_mai.Substring(2, 7)) + 1; voucher.ma_khuyen_mai = "VC" + String.Format("{0:0000000}", nextNo); } } else { voucher.ma_khuyen_mai = "VC" + "0000001"; } voucher.trang_thai = AllConstant.trang_thai.DANG_SU_DUNG; voucher.ngay_tao = DateTime.Now; voucher.nguoi_tao = UserName; voucher.ngay_cap_nhat = DateTime.Parse("1900-1-1"); db.Insert(voucher); } dbTrans.Commit(); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } //Transaction for voucher Details //using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) //{ // try // { // if (products != null) // { // var checkData = db.Select<Merchant_Product_Promotion_Detail>("ma_khuyen_mai = {0} and ma_gian_hang = {1}", voucher.ma_khuyen_mai, voucher.ma_gian_hang); // if (checkData == null) // { // foreach (string ma_san_pham in products) // { // Merchant_Product_Promotion_Detail item = new Merchant_Product_Promotion_Detail(); // item.id = 0; // item.ma_san_pham = ma_san_pham; // item.ma_gian_hang = voucher.ma_gian_hang; // item.ma_chuong_trinh_km = voucher.ma_khuyen_mai; // item.nguoi_tao = UserName; // item.ngay_tao = DateTime.Now; // db.Insert(item); // } // } // else // { // foreach (string ma_san_pham in products) // { // var checkProDetail = checkData.FirstOrDefault(s => s.ma_san_pham == ma_san_pham); // if (checkProDetail == null) // { // Merchant_Product_Promotion_Detail item = new Merchant_Product_Promotion_Detail(); // item.id = 0; // item.ma_san_pham = ma_san_pham; // item.ma_gian_hang = voucher.ma_gian_hang; // item.ma_chuong_trinh_km = voucher.ma_khuyen_mai; // item.nguoi_tao = UserName; // item.ngay_tao = DateTime.Now; // db.Insert(item); // } // else // { // checkData.Remove(checkProDetail); // } // } // if (checkData != null) // { // foreach (Merchant_Product_Promotion_Detail item in checkData) // db.Delete<Merchant_Product_Promotion_Detail>("ma_khuyen_mai = {0} and ma_gian_hang = {1} and ma_san_pham = {2}", item.ma_chuong_trinh_km, item.ma_gian_hang, item.ma_san_pham); // } // } // } // else // { // db.Delete<Merchant_Product_Promotion_Detail>("ma_khuyen_mai = {0} and ma_gian_hang = {1}", voucher.ma_khuyen_mai, voucher.ma_gian_hang); // } // dbTrans.Commit(); // } // catch (Exception e) // { // dbTrans.Rollback(); // return e.Message.ToString(); // } //} } return("true" + voucher.ma_khuyen_mai); }
public ActionResult Create(Products item) { IDbConnection db = new OrmliteConnection().openConn(); try { var isExist = db.SingleOrDefault <Products>("SELECT Code, Id FROM dbo.Products Where Code ='" + item.Code + "'"); if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.CreatedAt == null && item.CreatedBy == null) { if (isExist != null) { return(Json(new { success = false, message = "Sản phẩm đã tồn tại." })); } string id = ""; var checkID = db.SingleOrDefault <Products>("SELECT Code, Id FROM dbo.Products ORDER BY Id DESC"); if (checkID != null) { var nextNo = int.Parse(checkID.Code.Substring(2, checkID.Code.Length - 2)) + 1; id = "PR" + String.Format("{0:00000000}", nextNo); } else { id = "PR00000001"; } item.Code = id; item.Name = !string.IsNullOrEmpty(item.Name) ? item.Name.Trim() : ""; item.Price = item.VATPrice / 1.1; item.VATPrice = item.VATPrice; item.Size = !string.IsNullOrEmpty(item.Size) ? item.Size.Trim() : "";; item.Unit = !string.IsNullOrEmpty(item.Unit) ? item.Unit.Trim() : "";; item.Type = !string.IsNullOrEmpty(item.Type) ? item.Type.Trim() : "";; item.WHID = !string.IsNullOrEmpty(item.WHID) ? item.WHID : ""; item.WHLID = !string.IsNullOrEmpty(item.WHLID) ? item.WHLID : ""; item.Desc = !string.IsNullOrEmpty(item.Desc) ? item.Desc.Trim() : ""; item.ShapeTemplate = !string.IsNullOrEmpty(item.ShapeTemplate) ? item.ShapeTemplate.Trim() : ""; item.CreatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; item.UpdatedAt = DateTime.Parse("1900-01-01"); item.UpdatedBy = ""; item.Status = item.Status; db.Insert <Products>(item); return(Json(new { success = true, Code = item.Code, createdat = item.CreatedAt, createdby = item.CreatedBy })); } else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null) { var success = db.Execute(@"UPDATE Products SET Status = @Status, VATPrice = @VATPrice, Size= @Size, Unit=@Unit,Type=@Type, WHID=@WHID, WHLID=@WHLID, ShapeTemplate = @ShapeTemplate, UpdatedAt = @UpdatedAt,UpdatedBy =@UpdatedBy, Price=@Price,[Desc]=@Desc, Name = @Name WHERE Code = '" + item.Code + "'", new { Status = item.Status, Price = item.VATPrice / 1.1, VATPrice = item.VATPrice, Size = !string.IsNullOrEmpty(item.Size) ? item.Size.Trim() : "", Unit = !string.IsNullOrEmpty(item.Unit) ? item.Unit.Trim() : "", Type = !string.IsNullOrEmpty(item.Type) ? item.Type.Trim() : "", WHID = !string.IsNullOrEmpty(item.WHID) ? item.WHID : "", WHLID = !string.IsNullOrEmpty(item.WHLID) ? item.WHLID : "", ShapeTemplate = !string.IsNullOrEmpty(item.ShapeTemplate) ? item.ShapeTemplate.Trim() : "", UpdatedAt = DateTime.Now, UpdatedBy = currentUser.UserID, Desc = !string.IsNullOrEmpty(item.Desc) ? item.Desc.Trim() : "", Name = !string.IsNullOrEmpty(item.Name) ? item.Name.Trim() : "", }) == 1; if (!success) { return(Json(new { success = false, message = "Cập nhật không thành công." })); } return(Json(new { success = true })); } else { return(Json(new { success = false, message = "Bạn không có quyền" })); } } catch (Exception e) { log.Error(" ListProducts - Create - " + e.Message); return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult Create(Company item) { IDbConnection db = new OrmliteConnection().openConn(); try { if (!string.IsNullOrEmpty(item.CompanyID) && !string.IsNullOrEmpty(item.CompanyName) ) { var isExist = db.SingleOrDefault <Company>("CompanyID={0}", item.CompanyID); if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.CreatedAt == null && item.CreatedBy == null) { if (isExist != null) { return(Json(new { success = false, message = "Mã công ty đã tồn tại" })); } item.CompanyName = !string.IsNullOrEmpty(item.CompanyName) ? item.CompanyName : ""; item.ShortName = !string.IsNullOrEmpty(item.ShortName) ? item.ShortName : ""; item.EnglishName = !string.IsNullOrEmpty(item.EnglishName) ? item.EnglishName : ""; item.SubDomain = !string.IsNullOrEmpty(item.SubDomain) ? item.SubDomain : ""; item.Phone = !string.IsNullOrEmpty(item.Phone) ? item.Phone : ""; item.MobilePhone = !string.IsNullOrEmpty(item.MobilePhone) ? item.MobilePhone : ""; item.Fax = !string.IsNullOrEmpty(item.Fax) ? item.Fax : ""; item.Email = !string.IsNullOrEmpty(item.Email) ? item.Email : ""; item.PersonalEmail = !string.IsNullOrEmpty(item.PersonalEmail) ? item.PersonalEmail : ""; item.Address = !string.IsNullOrEmpty(item.Address) ? item.Address : ""; item.Website = !string.IsNullOrEmpty(item.Website) ? item.Website : ""; item.Descr = !string.IsNullOrEmpty(item.Descr) ? item.Descr : ""; item.CreatedAt = DateTime.Now; item.UpdatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; item.UpdatedBy = currentUser.UserID; db.Insert <Company>(item); return(Json(new { success = true, CompanyID = item.CompanyID, CreatedBy = item.CreatedBy, CreatedAt = item.CreatedAt, })); } else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null) { item.CompanyName = !string.IsNullOrEmpty(item.CompanyName) ? item.CompanyName : ""; item.ShortName = !string.IsNullOrEmpty(item.ShortName) ? item.ShortName : ""; item.EnglishName = !string.IsNullOrEmpty(item.EnglishName) ? item.EnglishName : ""; item.SubDomain = !string.IsNullOrEmpty(item.SubDomain) ? item.SubDomain : ""; item.Phone = !string.IsNullOrEmpty(item.Phone) ? item.Phone : ""; item.MobilePhone = !string.IsNullOrEmpty(item.MobilePhone) ? item.MobilePhone : ""; item.Fax = !string.IsNullOrEmpty(item.Fax) ? item.Fax : ""; item.Email = !string.IsNullOrEmpty(item.Email) ? item.Email : ""; item.PersonalEmail = !string.IsNullOrEmpty(item.PersonalEmail) ? item.PersonalEmail : ""; item.Address = !string.IsNullOrEmpty(item.Address) ? item.Address : ""; item.Website = !string.IsNullOrEmpty(item.Website) ? item.Website : ""; item.Descr = !string.IsNullOrEmpty(item.Descr) ? item.Descr : ""; item.CreatedBy = isExist.CreatedBy; item.CreatedAt = isExist.CreatedAt; item.UpdatedAt = DateTime.Now; item.UpdatedBy = currentUser.UserID; db.Update(item); return(Json(new { success = true })); } else { return(Json(new { success = false, message = "Bạn không có quyền" })); } } else { return(Json(new { success = false, message = "Chưa nhập đủ giá trị" })); } } catch (Exception e) { log.Error("Company - Create - " + e.Message); return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult ImportData() { try { if (Request.Files["FileUpload"] != null && Request.Files["FileUpload"].ContentLength > 0) { string fileExtension = System.IO.Path.GetExtension(Request.Files["FileUpload"].FileName); if (fileExtension == ".xlsx" || fileExtension == ".xls") { IDbConnection dbConn = new OrmliteConnection().openConn(); using (var dbTrans = dbConn.OpenTransaction(IsolationLevel.ReadCommitted)) { string datetime = DateTime.Now.ToString("yyyyMMddHHmmss"); string fileLocation = string.Format("{0}/{1}", Server.MapPath("~/ExcelImport"), "[" + currentUser.UserID + "-" + datetime + Request.Files["FileUpload"].FileName); string errorFileLocation = string.Format("{0}/{1}", Server.MapPath("~/ExcelImport"), "[" + currentUser.UserID + "-" + datetime + "-Error]" + Request.Files["FileUpload"].FileName); string linkerror = "[" + currentUser.UserID + "-" + datetime + "-Error]" + Request.Files["FileUpload"].FileName; if (System.IO.File.Exists(fileLocation)) { System.IO.File.Delete(fileLocation); } Request.Files["FileUpload"].SaveAs(fileLocation); var rownumber = 2; var total = 0; FileInfo fileInfo = new FileInfo(fileLocation); var excelPkg = new ExcelPackage(fileInfo); //FileInfo template = new FileInfo(Server.MapPath(errorFileLocation)); //template.CopyTo(errorFileLocation); //FileInfo _fileInfo = new FileInfo(errorFileLocation); //var _excelPkg = new ExcelPackage(_fileInfo); ExcelWorksheet oSheet = excelPkg.Workbook.Worksheets["Data"]; //ExcelWorksheet eSheet = _excelPkg.Workbook.Worksheets["Data"]; ExcelPackage pck = new ExcelPackage(new FileInfo(errorFileLocation)); ExcelWorksheet ws = pck.Workbook.Worksheets["Data"]; int totalRows = oSheet.Dimension.End.Row; for (int i = 2; i <= totalRows; i++) { string ID = oSheet.Cells[i, 1].Value != null ? oSheet.Cells[i, 1].Value.ToString() : ""; string Name = oSheet.Cells[i, 2].Value != null ? oSheet.Cells[i, 2].Value.ToString() : ""; string Size = oSheet.Cells[i, 3].Value != null ? oSheet.Cells[i, 3].Value.ToString() : ""; string Priece = oSheet.Cells[i, 4].Value != null ? oSheet.Cells[i, 4].Value.ToString() : "0"; string Type = oSheet.Cells[i, 5].Value != null ? oSheet.Cells[i, 5].Value.ToString() : ""; string Unit = oSheet.Cells[i, 6].Value != null ? oSheet.Cells[i, 6].Value.ToString() : ""; string[] UnitID = Unit.Split('/'); string WH = oSheet.Cells[i, 7].Value != null ? oSheet.Cells[i, 7].Value.ToString() : ""; string[] WHID = WH.Split('/'); string WHL = oSheet.Cells[i, 8].Value != null ? oSheet.Cells[i, 8].Value.ToString() : ""; string[] WHLID = WHL.Split('/'); string Templete = oSheet.Cells[i, 9].Value != null ? oSheet.Cells[i, 9].Value.ToString() : ""; //string Status = oSheet.Cells[i, 9].Value != null ? oSheet.Cells[i, 9].Value.ToString() : "Ngưng hoạt động"; string Status = "false"; if (oSheet.Cells[i, 10].Value != null) { if (oSheet.Cells[i, 10].Value.ToString() == "Đang hoạt động") { Status = "true"; } } try { if (string.IsNullOrEmpty(Name) || string.IsNullOrEmpty(Size) || string.IsNullOrEmpty(Priece)) { ws.Cells["A" + 2].Value = Name; ws.Cells[rownumber, 14].Value = "Vui lòng nhập (*)."; rownumber++; } else { var checkexists = dbConn.SingleOrDefault <Products>("SELECT * FROM Products WHERE Code = '" + ID + "'"); if (checkexists != null) { checkexists.Code = ID; checkexists.Name = Name; checkexists.Size = Name; checkexists.Price = int.Parse(Priece) / 1.1; checkexists.VATPrice = int.Parse(Priece); checkexists.Type = Type; checkexists.Unit = Unit != null ? UnitID[UnitID.Count() - 1] : ""; checkexists.WHID = WH != null ? WHID[WHID.Count() - 1] : ""; checkexists.WHLID = WHL != null ? WHLID[WHLID.Count() - 1] : ""; checkexists.ShapeTemplate = Templete; checkexists.Status = Boolean.Parse(Status); checkexists.UpdatedAt = DateTime.Now; checkexists.UpdatedBy = currentUser.UserID; dbConn.Update <Products>(checkexists); } else { string id = ""; var checkID = dbConn.SingleOrDefault <Products>("SELECT Code, Id FROM dbo.Products ORDER BY Id DESC"); if (checkID != null) { var nextNo = int.Parse(checkID.Code.Substring(2, checkID.Code.Length - 2)) + 1; id = "PR" + String.Format("{0:00000000}", nextNo); } else { id = "PR00000001"; } var item = new Products(); item.Code = ID; item.Name = Name; item.Size = Name; item.Price = int.Parse(Priece) / 1.1; item.VATPrice = int.Parse(Priece); item.Type = Type; item.Unit = Unit != null ? UnitID[UnitID.Count() - 1] : ""; item.WHID = WH != null ? WHID[WHID.Count() - 1] : ""; item.WHLID = WHL != null ? WHLID[WHLID.Count() - 1] : ""; item.ShapeTemplate = Templete; item.Status = Boolean.Parse(Status); item.CreatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; item.UpdatedAt = DateTime.Parse("1900-01-01"); item.UpdatedBy = ""; item.Status = Boolean.Parse(Status); dbConn.Insert <Products>(item); } total++; } } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } } return(Json(new { success = true, total = total, totalError = rownumber - 2, link = linkerror })); } } else { return(Json(new { success = false, message = "Không phải là file Excel. *.xlsx" })); } } else { return(Json(new { success = false, message = "Không có file hoặc file không phải là Excel" })); } } catch (Exception ex) { return(Json(new { success = false, message = ex.Message })); } }