public string Delete(string[] ids, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { var checkID = db.SingleOrDefault <Merchant_Product>("id={0}", ids[0]); foreach (var id in ids) { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@id", id)); new SqlHelper().ExecuteNoneQuery("delete Merchant_Product_Promotion_Detail where id = @id", param, CommandType.Text); } dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }
public ActionResult CreateSONew() { var dbConn = new OrmliteConnection().openConn(); try { string SONumber = String.Empty; string datetimeSO = DateTime.Now.ToString("yyMMdd"); var existSO = dbConn.SingleOrDefault <SOHeader>("SELECT id, SONumber FROM SOHeader ORDER BY Id DESC"); if (existSO != null) { var nextNo = Int32.Parse(existSO.SONumber.Substring(8, 5)) + 1; SONumber = "SO" + datetimeSO + String.Format("{0:00000}", nextNo); } else { SONumber = "SO" + datetimeSO + "00001"; } return(Json(new { success = true, SONumber = SONumber })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } }
public string ChangeStatus(string[] ids, string connectionString, string Username, string status) { using (var db = new OrmliteConnection().openConn(connectionString)) { try { foreach (var id in ids) { var checkID = db.SingleOrDefault <Merchant_Warehouse>("id={0}", id); if (checkID != null) { checkID.trang_thai = (status == AllConstant.trang_thai.DANG_SU_DUNG) ? AllConstant.trang_thai.DANG_SU_DUNG : AllConstant.trang_thai.KHONG_SU_DUNG; checkID.nguoi_cap_nhat = Username; checkID.ngay_cap_nhat = DateTime.Now; db.UpdateOnly(checkID, onlyFields: p => new { p.trang_thai, p.nguoi_cap_nhat, p.ngay_cap_nhat }, where : p => p.id == checkID.id); } } return("true"); } catch (Exception e) { return(e.Message.ToString()); } } }
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 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 ActionResult UpdateDetail([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <SODetail> list) { var dbConn = new OrmliteConnection().openConn(); if (userAsset.ContainsKey("Update") && userAsset["Update"]) { if (list != null)//&& ModelState.IsValid) { foreach (var item in list) { if (dbConn.Select <SOHeader>(s => s.SONumber == item.SONumber && s.Status != "Mới").Count() > 0) { return(Json(new { success = false, message = "Đơn hàng đã xác nhận nên không được xóa." })); } else if (item.Qty > 0) { var isExist = dbConn.SingleOrDefault <SODetail>("SONumber = {0} AND ItemCode = {1}", item.SONumber, item.ItemCode); if (isExist != null) { try { isExist.Qty = item.Qty; isExist.TotalAmt = item.Qty * item.Price; isExist.UpdatedAt = DateTime.Now; isExist.UpdatedBy = currentUser.UserID; dbConn.Update <SODetail>(isExist); //dbConn.Update<SODetail>(set: "Qty = '" + item.Qty + "', TotalAmt = '" + item.Qty * item.Price + "',UpdatedAt = '" + DateTime.Now + "', UpdatedBy ='" + currentUser.UserID + "'", where: "SONumber = '" + item.SONumber + "' AND ItemCode ='" + item.ItemCode + "'"); dbConn.Update <SOHeader>(set: "UpdatedBy='" + currentUser.UserID + "',TotalQty ='" + dbConn.Select <SODetail>(s => s.SONumber == item.SONumber).Sum(s => s.Qty) + "', TotalAmt = '" + dbConn.Select <SODetail>(s => s.SONumber == item.SONumber).Sum(s => s.TotalAmt) + "'", where : "SONumber ='" + item.SONumber + "'"); var success = dbConn.Execute(@"UPDATE SOHeader Set UpdatedAt = @UpdatedAt WHERE SONumber = '" + item.SONumber + "'", new { UpdatedAt = DateTime.Now, }) == 1; } catch (Exception ex) { ModelState.AddModelError("error", ex.Message); return(Json(list.ToDataSourceResult(request, ModelState))); } } } else { ModelState.AddModelError("error", "Đơn hàng được tạo khi số lượng > 0"); return(Json(list.ToDataSourceResult(request, ModelState))); } } } dbConn.Close(); return(Json(new { sussess = true })); } else { dbConn.Close(); ModelState.AddModelError("error", "Bạn không có quyền cập nhật."); return(Json(list.ToDataSourceResult(request, ModelState))); } }
public string UpdateStatus(string id, string UserName, string type, string status, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { var checkID = db.SingleOrDefault <Product_Info>("id={0}", id); if (checkID != null) { if (type == "duyet") { if (checkID.trang_thai == AllConstant.trang_thai.DANG_SU_DUNG) { checkID.trang_thai_duyet = status; } else { return("Không được duyệt do sản phẩm chưa hoạt động"); } //db.Update(set: "trang_thai_duyet={0}".Params(status), where: "id='" + id +"'"); } if (type == "xuatban") { if (checkID.trang_thai == AllConstant.trang_thai.DANG_SU_DUNG) { if (checkID.trang_thai_duyet != AllConstant.trang_thai_duyet.TU_CHOI) { checkID.trang_thai_duyet = AllConstant.trang_thai_duyet.DA_DUYET; checkID.trang_thai_xuat_ban = status; //db.Update(set: "trang_thai_xuat_ban={0},ngay_cap_nhat={1},nguoi_cap_nhat={2}".Params(status, DateTime.Now, UserName), where: "id='" + id + "'"); } else { return("Không được phép xuất bản do sản phẩm đã bị từ chối duyệt"); } } else { return("Chưa được xuất bản do sản phẩm chưa hoạt động"); } } checkID.ngay_cap_nhat = DateTime.Now; checkID.nguoi_cap_nhat = UserName; db.Update(checkID); } dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }
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); } } }
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()); } } } }
// // 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 <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 Merchant_Info ReadByMerchantID(string ma_gian_hang, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { Merchant_Info data = db.SingleOrDefault <Merchant_Info>("ma_gian_hang = {0}", ma_gian_hang); if (data == null) { return(new Merchant_Info()); } return(data); } }
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 <Merchant_Image_Info> list, string UserName, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { // using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (Merchant_Image_Info row in list) { var checkID = db.SingleOrDefault <Merchant_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 { row.nguoi_tao = UserName; row.nguoi_cap_nhat = UserName; List <SqlParameter> lstParameter = new List <SqlParameter>(); lstParameter.Add(new SqlParameter("@ma_gian_hang", row.ma_gian_hang)); lstParameter.Add(new SqlParameter("@ten_anh", row.ten_anh)); lstParameter.Add(new SqlParameter("@loai", row.loai)); lstParameter.Add(new SqlParameter("@ma_anh_goc", row.ma_anh_goc)); lstParameter.Add(new SqlParameter("@mo_ta", row.mo_ta)); lstParameter.Add(new SqlParameter("@mo_ta_khong_dau", row.mo_ta_khong_dau)); lstParameter.Add(new SqlParameter("@thu_muc", row.thu_muc)); lstParameter.Add(new SqlParameter("@url", row.url)); lstParameter.Add(new SqlParameter("@duong_dan_day_du", row.duong_dan_day_du)); lstParameter.Add(new SqlParameter("@dung_luong", row.dung_luong)); lstParameter.Add(new SqlParameter("@chieu_rong", row.chieu_rong)); lstParameter.Add(new SqlParameter("@chieu_cao", row.chieu_cao)); lstParameter.Add(new SqlParameter("@nguoi_tao", row.nguoi_tao)); lstParameter.Add(new SqlParameter("@nguoi_cap_nhat", row.nguoi_cap_nhat)); new SqlHelper(connectionString).ExecuteNoneQuery("p_Merchant_Image_Info_Create", lstParameter); } } // dbTrans.Commit(); return("true"); } catch (Exception e) { // dbTrans.Rollback(); return(e.Message.ToString()); } } } }
public ActionResult UpdateAction([DataSourceRequest] DataSourceRequest request, int roleid, string menuid, [Bind(Prefix = "models")] IEnumerable <Auth_Action> lst) { if (userAsset.ContainsKey("Update") && userAsset["Update"]) { 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) { try { item.RoleID = roleid; item.MenuID = menuid; item.Note = ""; item.RowCreatedAt = isExist.RowCreatedAt; item.RowCreatedBy = isExist.RowCreatedBy; item.RowUpdatedAt = DateTime.Now; item.RowUpdatedBy = currentUser.UserID; db.Update <Auth_Action>(item, p => p.RoleID == roleid && p.MenuID == menuid && p.Action == item.Action); } catch (Exception ex) { ModelState.AddModelError("er", ex.Message); return(Json(lst.ToDataSourceResult(request, ModelState))); } } else { ModelState.AddModelError("er", "Quyền không tồn tại"); return(Json(lst.ToDataSourceResult(request, ModelState))); } } } db.Close(); return(Json(lst.ToDataSourceResult(request))); } else { ModelState.AddModelError("er", "Bạn không có quyền cập nhật"); return(Json(lst.ToDataSourceResult(request, ModelState))); } }
public ActionResult GetPrinterbycode(string PrinterID) { IDbConnection dbConn = new OrmliteConnection().openConn(); try { var data = dbConn.SingleOrDefault <DC_AD_Printer>("PrinterID={0}", PrinterID); return(Json(new { success = true, data = data })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { dbConn.Close(); } }
public ActionResult GetFormulaByID(string FormulaID) { IDbConnection dbConn = new OrmliteConnection().openConn(); try { var data = dbConn.SingleOrDefault <DC_Formula>("FormulaID={0}", FormulaID); return(Json(new { success = true, data = data })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { dbConn.Close(); } }
public ActionResult GetDiscountionCode(string DiscountionID) { IDbConnection dbConn = new OrmliteConnection().openConn(); try { var data = dbConn.SingleOrDefault <DC_LG_Discountion>("DiscountionID={0}", DiscountionID); return(Json(new { success = true, data = data })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { dbConn.Close(); } }
public ActionResult GetDeliveryByCode(string TransporterID) { IDbConnection dbConn = new OrmliteConnection().openConn(); try { var data = dbConn.SingleOrDefault <DC_LG_Transporter>("TransporterID={0}", TransporterID); return(Json(new { success = true, data = data })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { dbConn.Close(); } }
public static FE_ContactRequest GetDefaultContactRequest(int UserId) { try { IDbConnection dbConn = new OrmliteConnection().openConn(); var item = dbConn.SingleOrDefault <ContactRequest>("isactive={0} and userid = {1} and userid <> 0", 1, UserId); if (item == null) { return(new FE_ContactRequest()); } return(Mapper.Map <FE_ContactRequest>(item)); } catch (Exception ex) { return(new FE_ContactRequest()); } }
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()); } } }
//Chuyển trạng thái sản phẩm sang trạng thái ngưng sử dụng public string ChangeStatus(string[] ids, string connectionString, string Username, string status) { using (var db = new OrmliteConnection().openConn(connectionString)) { try { foreach (var id in ids) { var checkID = db.SingleOrDefault <Merchant_Product>("id={0}", id); if (checkID != null) { checkID.trang_thai = (status == AllConstant.trang_thai.DANG_SU_DUNG) ? AllConstant.trang_thai.DANG_SU_DUNG : AllConstant.trang_thai.KHONG_SU_DUNG; checkID.trang_thai_duyet = AllConstant.trang_thai_duyet.CHUA_DUYET; checkID.trang_thai_xuat_ban = AllConstant.trang_thai_xuat_ban.CHUA_XUAT_BAN; checkID.nguoi_cap_nhat = Username; checkID.ngay_cap_nhat = DateTime.Now; db.UpdateOnly(checkID, onlyFields: p => new { p.trang_thai, p.trang_thai_xuat_ban, p.trang_thai_duyet, p.nguoi_cap_nhat, p.ngay_cap_nhat }, where : p => p.id == checkID.id); string rs = SyncToMySQL(id, connectionString); if (rs != "true") { return("Lỗi đồng bộ!"); } } } 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 ChangeStatusApproval(string[] ids, string connectionString, string Username) { using (var db = new OrmliteConnection().openConn(connectionString)) { try { foreach (var id in ids) { var checkID = db.SingleOrDefault <Merchant_Info>("id={0}", id); if (checkID != null) { checkID.trang_thai_duyet = (checkID.trang_thai_duyet == AllConstant.trang_thai_duyet.DA_DUYET) ? AllConstant.trang_thai_duyet.TU_CHOI : AllConstant.trang_thai_duyet.DA_DUYET; checkID.nguoi_duyet = checkID.nguoi_cap_nhat = Username; checkID.ngay_duyet = checkID.ngay_cap_nhat = DateTime.Now; db.UpdateOnly(checkID, onlyFields: p => new { p.trang_thai_duyet, p.nguoi_duyet, p.ngay_duyet, p.nguoi_cap_nhat, p.ngay_cap_nhat }, where : p => p.id == checkID.id); string rs = SyncToMySQL(id, connectionString); if (rs != "true") { return("Lỗi đồng bộ!"); } } } return("true"); } catch (Exception e) { return(e.Message.ToString()); } } }
public string Delete(string ma_thuong_hieu, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { try { var checkID = db.SingleOrDefault <BrandManagement>("ma_thuong_hieu={0}", ma_thuong_hieu); if (checkID == null) { return("Không có thương hiệu này!"); } List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@ma_thuong_hieu", ma_thuong_hieu)); new SqlHelper().ExecuteNoneQuery("delete BrandManagement where ma_thuong_hieu = @ma_thuong_hieu", param, CommandType.Text); return("true"); } catch (Exception e) { return(e.Message.ToString()); } } }
public void UpSert(List <Product_Merchant> lstProduct_Merchant, string UserName, string Type, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (Product_Merchant row in lstProduct_Merchant) { var checkID = db.SingleOrDefault <Product_Merchant>("id={0}", row.id); if (checkID != null) { row.ngay_cap_nhat = DateTime.Now; row.nguoi_cap_nhat = UserName; if (checkID.trang_thai_duyet != row.trang_thai_duyet && (row.trang_thai_duyet == BIBIAM.Core.AllConstant.trang_thai_duyet.DA_DUYET || row.trang_thai_duyet == BIBIAM.Core.AllConstant.trang_thai_duyet.TU_CHOI)) { row.ngay_duyet = DateTime.Now; row.nguoi_duyet = UserName; } db.Update(row); } else { row.ngay_tao = row.ngay_cap_nhat = DateTime.Now; row.nguoi_tao = row.nguoi_cap_nhat = UserName; db.Save(row); } } dbTrans.Commit(); } catch { dbTrans.Rollback(); } } } }
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 Delete(string[] ids, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { var checkID = db.SingleOrDefault <Image_Info>("id={0}", ids[0]); foreach (var id in ids) { db.Delete <Image_Info>(s => s.id == int.Parse(id)); } dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }