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