public string Authentication(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.FirstOrDefault <Merchant_Info>(s => s.id == row.id && s.ma_gian_hang == row.ma_gian_hang && s.trang_thai_xac_thuc == "A"); if (checkID == null) { dbTrans.Rollback(); return("Không xác định được gian hàng!"); } var newData = Newtonsoft.Json.JsonConvert.SerializeObject(checkID); Merchant_Info data = Newtonsoft.Json.JsonConvert.DeserializeObject <Merchant_Info>(new Merchant_History_DAO().getValueHistory("Merchant_Info", row.ma_gian_hang, db)); data.trang_thai_xac_thuc = AllConstant.trang_thai_xac_thuc.DA_XAC_THUC; db.Update(data); var rs = new Merchant_History_DAO().createHistory("Merchant_Info", checkID.ma_gian_hang, newData, UserName, db); if (rs != "true") { dbTrans.Rollback(); return(rs); } dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }
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 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); } } }
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 string Sync(Product_Info item, string UserName, string connectionString) { List <SqlParameter> lstParameter = new List <SqlParameter>(); if (!CheckBeforeSync(item)) { return("Sản phẩm chưa đủ điều kiện Sync !\n Vui lòng kiểm tra tất cả trạng thái !"); } lstParameter.Clear(); lstParameter.Add(new SqlParameter("@id", item.id)); lstParameter.Add(new SqlParameter("@ma_san_pham", item.ma_san_pham)); using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { var pro_hier = db.FirstOrDefault <Product_Hierarchy>(s => s.ma_san_pham == item.ma_san_pham && s.trang_thai == AllConstant.trang_thai.DANG_SU_DUNG); if (pro_hier != null) { pro_hier.ngay_cap_nhat = DateTime.Now; pro_hier.nguoi_cap_nhat = UserName; db.Update(pro_hier); } else { dbTrans.Rollback(); return("Cây phân cấp chưa có hoặc trạng thái không hoạt động!"); } var pro_price = db.Select <Product_Price>(s => s.ma_san_pham == item.ma_san_pham && s.trang_thai == AllConstant.trang_thai.DANG_SU_DUNG && s.trang_thai_duyet == AllConstant.trang_thai_duyet.DA_DUYET && s.trang_thai_xuat_ban == AllConstant.trang_thai_xuat_ban.DA_XUAT_BAN); if (pro_price == null) { return("Chưa có giá sản phẩm thõa mãn!"); } foreach (Product_Price iitem in pro_price) { iitem.ngay_cap_nhat = DateTime.Now; iitem.nguoi_cap_nhat = UserName; db.Update(iitem); } dbTrans.Commit(); } catch (Exception e) { dbTrans.Rollback(); return(e.Message); } } } new SqlHelper(connectionString).ExecuteNoneQuery("p_Product_SyncFullToMySQL", lstParameter); return(""); }
public string SyncToMySQL(string id, string connectionString)// if(type = full){ sync product+image+hierarchy} else{sync product} { Merchant_Product SyncProduct; using (var db = new OrmliteConnection().openConn(connectionString)) { try { SyncProduct = db.FirstOrDefault <Merchant_Product>("id = {0}", id); if (SyncProduct == null) { return("Không tìm thấy sản phẩm"); } } catch (Exception e) { return(e.Message.ToString()); } } try { List <SqlParameter> param = new List <SqlParameter>(); //Sync Product param.Add(new SqlParameter("@ma_san_pham", SyncProduct.ma_san_pham)); param.Add(new SqlParameter("@ma_gian_hang", SyncProduct.ma_gian_hang)); new SqlHelper(connectionString).ExecuteQuery("p_Merchant_Product_SyncToMySQL", param); //Sync Hierarchy param.Clear(); param.Add(new SqlParameter("@ma_san_pham", SyncProduct.ma_san_pham)); param.Add(new SqlParameter("@ma_gian_hang", SyncProduct.ma_gian_hang)); new SqlHelper(connectionString).ExecuteQuery("p_Merchant_Product_Hierarchy_SyncToMySQL", param); //Sync Warehouse param.Clear(); param.Add(new SqlParameter("@ma_san_pham", SyncProduct.ma_san_pham)); param.Add(new SqlParameter("@ma_gian_hang", SyncProduct.ma_gian_hang)); new SqlHelper(connectionString).ExecuteQuery("p_Merchant_Product_Warehouse_SyncToMySQL", param); //Sync Image param.Clear(); param.Add(new SqlParameter("@ma_san_pham", SyncProduct.ma_san_pham)); param.Add(new SqlParameter("@ma_gian_hang", SyncProduct.ma_gian_hang)); new SqlHelper(connectionString).ExecuteQuery("p_Merchant_Product_Image_SyncToMySQL", param); return("true"); } catch (Exception e) { 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); } } } }
public static AuthUser GetByCode(string entrycode, string typelogin) { IDbConnection dbConn = new OrmliteConnection().openConn(); try { var data = dbConn.FirstOrDefault <AuthUser>("entrycode={0} and loginprovider = {1}", entrycode, typelogin); return(data); } catch (Exception e) { return(null); } finally { dbConn.Close(); } }
public static FE_Product GetDetail(string productid) { try { IDbConnection dbConn = new OrmliteConnection().openConn(); var item = dbConn.FirstOrDefault <Product>("isactive={0} and entryid = {1}", 1, productid); var mapped = Mapper.Map <FE_Product>(item); var result = mapped; return(result); } catch (Exception ex) { return(new FE_Product()); } }
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 static FE_SubCategory GetDetail(string subcategoryid) { try { IDbConnection dbConn = new OrmliteConnection().openConn(); var item = dbConn.FirstOrDefault <SubCategory>("isactive={0} and entryid = {1}", 1, subcategoryid); if (item == null) { return(new FE_SubCategory()); } return(Mapper.Map <FE_SubCategory>(item)); } catch (Exception ex) { return(new FE_SubCategory()); } }
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 <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 <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 <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 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 Delete(string[] ids, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (var id in ids) { var checkID = db.FirstOrDefault <Product_Info>(s => s.id == int.Parse(id)); db.Delete <Product_Info>(s => s.id == int.Parse(id)); // Xóa ảnh if (checkID != null) { if (!String.IsNullOrEmpty(checkID.url)) { var path = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Images/Product_Info/"), checkID.url); if (!String.IsNullOrEmpty(path)) { System.IO.File.Delete(path); } } } } 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 { foreach (var id in ids) { var checkID = db.FirstOrDefault <Product_Promotion>(s => s.id == int.Parse(id)); db.Delete <Product_Promotion>(s => s.id == int.Parse(id)); } dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }
public string SyncToMySQL(string id, string connectionString) { Merchant_Info SyncMerchant; using (var db = new OrmliteConnection().openConn(connectionString)) { try { SyncMerchant = db.FirstOrDefault <Merchant_Info>("id = {0}", id); if (SyncMerchant == null) { return("Không tìm thấy sản phẩm"); } } catch (Exception e) { return(e.Message.ToString()); } } using (MySqlConnection con = new MySqlConnection(AppConfigs.FEConnectionString)) { con.Open(); try { List <SqlParameter> param = new List <SqlParameter>(); //Sync Product param.Add(new SqlParameter("@ma_gian_hang", SyncMerchant.ma_gian_hang)); new SqlHelper(connectionString).ExecuteQuery("p_Merchant_Info_SyncToMySQL", param); return("true"); } catch (Exception e) { 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 string Update(Merchant_Info row, string UserName, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { try { var checkID = db.SingleOrDefault <Merchant_Info>("ma_gian_hang = {0}", row.ma_gian_hang); if (checkID != null) { bool changeFlag = false; if (!String.IsNullOrEmpty(row.ten_viet_tat) && checkID.ten_viet_tat != row.ten_viet_tat) { checkID.ten_viet_tat = row.ten_viet_tat; changeFlag = true; } if (!String.IsNullOrEmpty(row.ten_tieng_anh) && checkID.ten_tieng_anh != row.ten_tieng_anh) { checkID.ten_tieng_anh = row.ten_tieng_anh; changeFlag = true; } if (!String.IsNullOrEmpty(row.website) && checkID.website != row.website) { checkID.website = row.website; changeFlag = true; } if (!String.IsNullOrEmpty(row.dien_thoai) && checkID.dien_thoai != row.dien_thoai) { checkID.dien_thoai = row.dien_thoai; changeFlag = true; } if (!String.IsNullOrEmpty(row.fax) && checkID.fax != row.fax) { checkID.fax = row.fax; changeFlag = true; } if (!String.IsNullOrEmpty(row.dia_chi_tru_so) && checkID.dia_chi_tru_so != row.dia_chi_tru_so) { checkID.dia_chi_tru_so = row.dia_chi_tru_so; changeFlag = true; } if (!String.IsNullOrEmpty(row.mo_ta) && checkID.mo_ta != row.mo_ta) { checkID.mo_ta = row.mo_ta; changeFlag = true; } if (!String.IsNullOrEmpty(row.email) && checkID.email != row.email) { var checkEmail = db.FirstOrDefault <Merchant_Info>("email = {0} and ma_gian_hang!={1}", row.email, row.ma_gian_hang); if (checkEmail != null) { return("Email đã tồn tại!"); } checkID.email = row.email; changeFlag = true; } if (!String.IsNullOrEmpty(row.tai_khoan_thanh_toan) && checkID.tai_khoan_thanh_toan != row.tai_khoan_thanh_toan) { checkID.tai_khoan_thanh_toan = row.tai_khoan_thanh_toan; changeFlag = true; } checkID.logo_gian_hang = string.IsNullOrEmpty(row.logo_gian_hang) ? checkID.logo_gian_hang : row.logo_gian_hang; checkID.ma_tinh_tp = string.IsNullOrEmpty(row.ma_tinh_tp) ? checkID.ma_tinh_tp : row.ma_tinh_tp; checkID.ten_tinh_tp = string.IsNullOrEmpty(row.ten_tinh_tp) ? checkID.ten_tinh_tp : row.ten_tinh_tp; checkID.ma_quan_huyen = string.IsNullOrEmpty(row.ma_quan_huyen) ? checkID.ma_quan_huyen : row.ma_quan_huyen; checkID.ten_quan_huyen = string.IsNullOrEmpty(row.ten_quan_huyen) ? checkID.ten_quan_huyen : row.ten_quan_huyen; if (changeFlag) { checkID.ngay_cap_nhat = DateTime.Now; checkID.nguoi_cap_nhat = UserName; checkID.trang_thai_xac_thuc = AllConstant.trang_thai_xac_thuc.CHUA_XAC_THUC; var newData = Newtonsoft.Json.JsonConvert.SerializeObject(checkID); //var rs = new Merchant_History_DAO().createHistory("Merchant_Info", checkID.ma_gian_hang, newData, UserName, db); //if (rs != "true") //{ // return "Ghi lịch sử thất bại!"; //} if (db.ExecuteNonQuery("update Merchant_Info set trang_thai_xac_thuc = '" + AllConstant.trang_thai_xac_thuc.CHUA_XAC_THUC + "' where id = {0} and ma_gian_hang = {1}".Params(checkID.id, checkID.ma_gian_hang)) > 0) { checkID.ngay_cap_nhat = DateTime.Now; checkID.nguoi_cap_nhat = UserName; db.Update(checkID); return("true"); } else { return("Xác thực không thành công!"); } } else { checkID.ngay_cap_nhat = DateTime.Now; checkID.nguoi_cap_nhat = UserName; db.Update(checkID); return("true"); } } return("Thông tin không xác định!"); } catch (Exception) { return("Error"); } } }
public string UpSert(List <Merchant_Info> lstMerchant_Info, string UserName, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (Merchant_Info row in lstMerchant_Info) { var checkID = db.SingleOrDefault <Merchant_Info>("id={0}", row.id); if (checkID == null) { string CustomerID = 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; CustomerID = "GH" + String.Format("{0:0000000}", nextNo); } } else { CustomerID = "GH0000001"; } row.ma_gian_hang = CustomerID; 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.ngay_cap_nhat = !string.IsNullOrEmpty(row.ngay_cap_nhat.ToString()) ? row.ngay_cap_nhat : DateTime.Parse("1900-01-01"); db.Insert(row); //List<SqlParameter> param = new List<SqlParameter>(); //param.Add(new SqlParameter("@1", row.ma_gian_hang)); //param.Add(new SqlParameter("@2", row.tai_khoan_thanh_toan)); //param.Add(new SqlParameter("@3", row.website)); //new SqlHelper().ExecuteNoneQuery("insert into Merchant_Info(ma_gian_hang,trang_thai_xuat_ban,website) values(@1,@2,@3)", param, CommandType.Text); } else { checkID.ten_gian_hang = !string.IsNullOrEmpty(row.ten_gian_hang) ? row.ten_gian_hang : ""; checkID.slug = StringHelper.convertToUnSign3(checkID.ten_gian_hang); checkID.ten_viet_tat = !string.IsNullOrEmpty(row.ten_viet_tat) ? row.ten_viet_tat : ""; checkID.website = !string.IsNullOrEmpty(row.website) ? row.website : ""; checkID.dien_thoai = !string.IsNullOrEmpty(row.dien_thoai) ? row.dien_thoai : ""; checkID.email = !string.IsNullOrEmpty(row.email) ? row.email : ""; checkID.fax = !string.IsNullOrEmpty(row.fax) ? row.fax : ""; checkID.logo_gian_hang = !string.IsNullOrEmpty(row.logo_gian_hang) ? row.logo_gian_hang : ""; checkID.ten_tieng_anh = !string.IsNullOrEmpty(row.ten_tieng_anh) ? row.ten_tieng_anh : ""; checkID.dia_chi_tru_so = !string.IsNullOrEmpty(row.dia_chi_tru_so) ? row.dia_chi_tru_so : ""; checkID.ten_tinh_tp = !string.IsNullOrEmpty(row.ten_tinh_tp) ? row.ten_tinh_tp : ""; checkID.ten_quan_huyen = !string.IsNullOrEmpty(row.ten_quan_huyen) ? row.ten_quan_huyen : ""; checkID.trang_thai_xuat_ban = !string.IsNullOrEmpty(row.trang_thai_xuat_ban) ? row.trang_thai_xuat_ban : AllConstant.trang_thai_xuat_ban.CHUA_XUAT_BAN; checkID.ma_quan_huyen = !string.IsNullOrEmpty(row.ma_quan_huyen) ? row.ma_quan_huyen : ""; checkID.ma_tinh_tp = !string.IsNullOrEmpty(row.ma_tinh_tp) ? row.ma_tinh_tp : ""; checkID.ngay_tiep_xuc = !string.IsNullOrEmpty(row.ngay_tiep_xuc.ToString()) ? row.ngay_tiep_xuc : DateTime.Parse("1900-01-01"); checkID.ngay_ky_hop_dong = !string.IsNullOrEmpty(row.ngay_tiep_xuc.ToString()) ? row.ngay_tiep_xuc : DateTime.Parse("1900-01-01"); checkID.nguoi_duyet = !string.IsNullOrEmpty(row.nguoi_duyet) ? row.nguoi_duyet : ""; checkID.ngay_duyet = !string.IsNullOrEmpty(row.ngay_duyet.ToString()) ? row.ngay_duyet : DateTime.Parse("1900-01-01"); checkID.ngay_hoat_dong = !string.IsNullOrEmpty(row.ngay_hoat_dong.ToString()) ? row.ngay_hoat_dong : DateTime.Parse("1900-01-01"); checkID.trang_thai_duyet = !string.IsNullOrEmpty(row.trang_thai_duyet) ? row.trang_thai_duyet : AllConstant.trang_thai_duyet.CHUA_DUYET; checkID.ly_do_giay_to_phap_ly = !string.IsNullOrEmpty(row.ly_do_giay_to_phap_ly) ? row.ly_do_giay_to_phap_ly : ""; checkID.tai_khoan_thanh_toan = !string.IsNullOrEmpty(row.tai_khoan_thanh_toan) ? row.tai_khoan_thanh_toan : "";; checkID.dao_tao_quan_ly = !string.IsNullOrEmpty(row.dao_tao_quan_ly) ? row.dao_tao_quan_ly : ""; checkID.mo_ta = !string.IsNullOrEmpty(row.mo_ta) ? row.mo_ta : ""; checkID.nguoi_tao = !string.IsNullOrEmpty(row.nguoi_tao) ? row.nguoi_tao : ""; checkID.ngay_tao = !string.IsNullOrEmpty(row.ngay_tao.ToString()) ? row.ngay_tao : DateTime.Parse("1900-01-01"); 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 UpSert(List <Product_Price> lstProductPrice, string UserName, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (Product_Price row in lstProductPrice) { var checkId = db.SingleOrDefault <Product_Price>("id={0}", row.id); if (checkId != null) { row.ngay_tao = checkId.ngay_tao; row.ngay_duyet = checkId.ngay_duyet; row.ngay_xuat_ban = checkId.ngay_xuat_ban; 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; } if (checkId.trang_thai_xuat_ban != row.trang_thai_xuat_ban && (row.trang_thai_xuat_ban == BIBIAM.Core.AllConstant.trang_thai_xuat_ban.DA_XUAT_BAN)) { row.ngay_xuat_ban = DateTime.Now; row.nguoi_xuat_ban = UserName; } db.Update(EmptyIfNull(row)); } else { string ProductPriceID = String.Empty; var lastId = db.FirstOrDefault <Product_Price>("SELECT TOP 1 * FROM Product_Price ORDER BY id DESC"); if (lastId != null) { if (lastId.ma_gia_san_pham.Contains("GIA")) { var nextNo = Int32.Parse(lastId.ma_gia_san_pham.Substring(3, 10)) + 1; ProductPriceID = "GIA" + String.Format("{0:0000000000}", nextNo); } } else { ProductPriceID = "GIA0000000001"; } row.ma_gia_san_pham = ProductPriceID; //row.ngay_duyet = row.ngay_xuat_ban = DateTime.Now;//chua biet row.ngay_tao = DateTime.Now; row.nguoi_tao = UserName; db.Insert(EmptyIfNull(row)); } } dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }
public string Cancel(string ma_don_hang, string ly_do_huy, string Username, string connectstring) { using (var dbConn = new OrmliteConnection().openConn(connectstring)) { { try { var exist = dbConn.FirstOrDefault <Merchant_OrderHeader>("ma_don_hang={0}".Params(ma_don_hang)); if (exist != null) { if (exist.trang_thai_don_hang == "New" || exist.trang_thai_don_hang == "Confirm" || exist.trang_thai_don_hang == "Shipping") { exist.trang_thai_don_hang = "Cancel"; exist.ly_do_huy = ly_do_huy; } else { return("false@@" + "Không thể hủy"); } exist.ngay_cap_nhat = DateTime.Now; exist.nguoi_cap_nhat = Username; dbConn.UpdateOnly(exist, onlyFields: p => new { p.trang_thai_don_hang, p.ly_do_huy, p.nguoi_cap_nhat, p.ngay_cap_nhat }, where : p => p.ma_don_hang == exist.ma_don_hang); using (MySqlConnection con = new MySqlConnection(AppConfigs.FEConnectionString)) { con.Open(); string sqlOrder = @"update order_merchant set trang_thai_don_hang={0} ngay_cap_nhat={1} nguoi_cap_nhat={2} where ma_don_hang={3} and ma_gian_hang={4}".Params(exist.trang_thai_don_hang, exist.ngay_cap_nhat, exist.nguoi_cap_nhat, exist.ma_don_hang_cha, exist.ma_gian_hang); using (MySql.Data.MySqlClient.MySqlTransaction trans = con.BeginTransaction()) { try { using (MySqlCommand cmd = new MySqlCommand(sqlOrder, con, trans)) { cmd.ExecuteNonQuery(); } trans.Commit(); } catch (Exception e) { trans.Rollback(); return(e.Message.ToString()); } } } } } catch (Exception e) { return("false@@" + e.Message); } } } return("true@@" + ly_do_huy); }
public string ChangeStatus(string ma_don_hang, string trang_thai_don_hang, string Username, string connectstring) { using (var dbConn = new OrmliteConnection().openConn(connectstring)) { { try { var exist = dbConn.FirstOrDefault <Merchant_OrderHeader>("ma_don_hang={0}".Params(ma_don_hang)); if (exist != null) { if (exist.trang_thai_don_hang == "New" && trang_thai_don_hang == "Confirm") { exist.trang_thai_don_hang = "Confirm"; } if (exist.trang_thai_don_hang == "Confirm" && trang_thai_don_hang == "Shipping") { exist.trang_thai_don_hang = "Shipping"; } if (exist.trang_thai_don_hang == "Shipping" && trang_thai_don_hang == "POD") { exist.trang_thai_don_hang = "POD"; } if (exist.trang_thai_don_hang == "POD" && trang_thai_don_hang == "Completed") { exist.trang_thai_don_hang = "Completed"; } exist.ngay_cap_nhat = DateTime.Now; exist.nguoi_cap_nhat = Username; dbConn.UpdateOnly(exist, onlyFields: p => new { p.trang_thai_don_hang, p.nguoi_cap_nhat, p.ngay_cap_nhat }, where : p => p.ma_don_hang == exist.ma_don_hang); if (exist.trang_thai_don_hang == "Confirm") { List <SqlParameter> param = new List <SqlParameter>(); //Update Merchant_Product_Warehouse param.Add(new SqlParameter("@ma_don_hang", exist.ma_don_hang)); new SqlHelper(connectstring).ExecuteQuery("p_Update_Merchant_Product_Warehouse_Order", param); } using (MySqlConnection con = new MySqlConnection(AppConfigs.FEConnectionString)) { con.Open(); string sqlOrder = @"update order_merchant set trang_thai_don_hang={0}, ngay_cap_nhat={1}, nguoi_cap_nhat={2} where ma_don_hang={3} and ma_gian_hang={4}".Params(exist.trang_thai_don_hang, exist.ngay_cap_nhat, exist.nguoi_cap_nhat, exist.ma_don_hang_cha, exist.ma_gian_hang); using (MySql.Data.MySqlClient.MySqlTransaction trans = con.BeginTransaction()) { try { using (MySqlCommand cmd = new MySqlCommand(sqlOrder, con, trans)) { cmd.ExecuteNonQuery(); } trans.Commit(); } catch (Exception e) { trans.Rollback(); return(e.Message.ToString()); } } } } } catch (Exception e) { return("false@@" + e.Message); } } } return("true@@" + trang_thai_don_hang); }
public string UpSert(List <Hierarchy> lstHierarchy, string UserName, string Type, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { try { foreach (Hierarchy row in lstHierarchy) { if (string.IsNullOrEmpty(row.ten_phan_cap)) { continue; } var checkID = db.SingleOrDefault <Hierarchy>("ma_phan_cap={0}", row.ma_phan_cap); if (checkID != null) { checkID.cap = !string.IsNullOrEmpty(row.cap.ToString()) ? row.cap : 1; checkID.ten_phan_cap = !string.IsNullOrEmpty(row.ten_phan_cap) ? row.ten_phan_cap : ""; checkID.aliasname = !string.IsNullOrEmpty(row.aliasname) ? row.aliasname : ""; checkID.loai_phan_cap = !string.IsNullOrEmpty(row.loai_phan_cap) ? row.loai_phan_cap : ""; checkID.ma_phan_cap_cha = !string.IsNullOrEmpty(row.ma_phan_cap_cha) ? row.ma_phan_cap_cha : ""; if (checkID.cap == 1) { checkID.ma_phan_cap_cha = ""; } if (!string.IsNullOrEmpty(checkID.ten_phan_cap)) { checkID.slug = StringHelper.convertToUnSign3(row.ten_phan_cap); } else { checkID.slug = ""; } checkID.trang_thai = !string.IsNullOrEmpty(row.trang_thai) ? row.trang_thai : AllConstant.trang_thai.DANG_SU_DUNG; checkID.order = !string.IsNullOrEmpty(row.order.ToString()) ? row.order : 1; checkID.nguoi_cap_nhat = UserName; checkID.ngay_cap_nhat = DateTime.Now; db.Update(checkID); } else { 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_phan_cap = ma_tu_tang; row.cap = !string.IsNullOrEmpty(row.cap.ToString()) ? row.cap : 1; row.ten_phan_cap = !string.IsNullOrEmpty(row.ten_phan_cap) ? row.ten_phan_cap : ""; row.aliasname = !string.IsNullOrEmpty(row.aliasname) ? row.aliasname : ""; row.loai_phan_cap = !string.IsNullOrEmpty(row.loai_phan_cap) ? row.loai_phan_cap : "HRC06"; row.ma_phan_cap_cha = !string.IsNullOrEmpty(row.ma_phan_cap_cha) ? row.ma_phan_cap_cha : ""; if (row.cap == 1) { row.ma_phan_cap_cha = ""; } row.trang_thai = !string.IsNullOrEmpty(row.trang_thai) ? row.trang_thai : AllConstant.trang_thai.DANG_SU_DUNG; if (!string.IsNullOrEmpty(row.ten_phan_cap)) { row.slug = StringHelper.convertToUnSign3(row.ten_phan_cap); } else { row.slug = ""; } row.order = !string.IsNullOrEmpty(row.order.ToString()) ? row.order : 1; row.nguoi_tao = UserName; row.ngay_tao = DateTime.Now; row.nguoi_cap_nhat = UserName; row.ngay_cap_nhat = DateTime.Now; db.Insert(row); } List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@ma_phan_cap", row.ma_phan_cap)); new SqlHelper(connectionString).ExecuteQuery("p_Hierarchy_SyncToMySQL", param); } return("true"); } catch (Exception e) { return(e.Message.ToString()); } } }
public string UpsertFull(Merchant_Product_Promotion promotion, List <string> products, string UserName, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { Merchant_Product_Promotion checkID; checkID = db.SingleOrDefault <Merchant_Product_Promotion>("id={0} and ma_gian_hang = {1}", promotion.id, promotion.ma_gian_hang); //Transaction for Promotion using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { if (checkID != null) { promotion.ma_chuong_trinh_km = checkID.ma_chuong_trinh_km; checkID.nguoi_cap_nhat = UserName; checkID.ngay_cap_nhat = DateTime.Now; checkID.ten_chuong_trinh_km = promotion.ten_chuong_trinh_km; checkID.loai = promotion.loai; checkID.gia_tri = promotion.gia_tri; checkID.trang_thai = promotion.trang_thai; checkID.ngay_bat_dau = promotion.ngay_bat_dau; checkID.ngay_ket_thuc = promotion.ngay_ket_thuc; db.Update(checkID); } else { 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; promotion.ma_chuong_trinh_km = "KM" + String.Format("{0:0000000}", nextNo); } } else { promotion.ma_chuong_trinh_km = "KM" + "0000001"; } promotion.trang_thai = AllConstant.trang_thai.DANG_SU_DUNG; promotion.ngay_tao = DateTime.Now; promotion.nguoi_tao = UserName; promotion.ngay_cap_nhat = DateTime.Parse("1900-1-1"); db.Insert(promotion); } dbTrans.Commit(); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } //Transaction for Promotion Details using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { if (products != null) { var checkData = db.Select <Merchant_Product_Promotion_Detail>("ma_chuong_trinh_km = {0} and ma_gian_hang = {1}", promotion.ma_chuong_trinh_km, promotion.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 = promotion.ma_gian_hang; item.ma_chuong_trinh_km = promotion.ma_chuong_trinh_km; 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 = promotion.ma_gian_hang; item.ma_chuong_trinh_km = promotion.ma_chuong_trinh_km; 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_chuong_trinh_km = {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_chuong_trinh_km = {0} and ma_gian_hang = {1}", promotion.ma_chuong_trinh_km, promotion.ma_gian_hang); } dbTrans.Commit(); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } return("true" + promotion.ma_chuong_trinh_km); }