public string Delete(string[] ids, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
var checkID = db.SingleOrDefault <Merchant_Product>("id={0}", ids[0]);
foreach (var id in ids)
{
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@id", id));
new SqlHelper().ExecuteNoneQuery("delete Merchant_Product_Promotion_Detail where id = @id", param, CommandType.Text);
}
dbTrans.Commit();
return("true");
}
catch (Exception e)
{
dbTrans.Rollback();
return(e.Message.ToString());
}
}
}
}
public ActionResult CreateSONew()
{
var dbConn = new OrmliteConnection().openConn();
try
{
string SONumber = String.Empty;
string datetimeSO = DateTime.Now.ToString("yyMMdd");
var existSO = dbConn.SingleOrDefault <SOHeader>("SELECT id, SONumber FROM SOHeader ORDER BY Id DESC");
if (existSO != null)
{
var nextNo = Int32.Parse(existSO.SONumber.Substring(8, 5)) + 1;
SONumber = "SO" + datetimeSO + String.Format("{0:00000}", nextNo);
}
else
{
SONumber = "SO" + datetimeSO + "00001";
}
return(Json(new { success = true, SONumber = SONumber }));
}
catch (Exception e)
{
return(Json(new { success = false, message = e.Message }));
}
}
public string ChangeStatus(string[] ids, string connectionString, string Username, string status)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
try
{
foreach (var id in ids)
{
var checkID = db.SingleOrDefault <Merchant_Warehouse>("id={0}", id);
if (checkID != null)
{
checkID.trang_thai = (status == AllConstant.trang_thai.DANG_SU_DUNG) ? AllConstant.trang_thai.DANG_SU_DUNG : AllConstant.trang_thai.KHONG_SU_DUNG;
checkID.nguoi_cap_nhat = Username;
checkID.ngay_cap_nhat = DateTime.Now;
db.UpdateOnly(checkID,
onlyFields: p =>
new
{
p.trang_thai,
p.nguoi_cap_nhat,
p.ngay_cap_nhat
},
where : p => p.id == checkID.id);
}
}
return("true");
}
catch (Exception e)
{
return(e.Message.ToString());
}
}
}
public string CreateUpdate(Footer footer, string UserName, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
try
{
var checkID = db.SingleOrDefault <Footer>("ma_footer={0}", footer.ma_footer);
if (checkID != null)
{
footer.id = checkID.id;
footer.nguoi_tao = checkID.nguoi_tao;
footer.ngay_tao = checkID.ngay_tao;
footer.nguoi_cap_nhat = UserName;
footer.ngay_cap_nhat = DateTime.Now;
db.Update(footer);
}
else
{
var lastId = db.FirstOrDefault <Footer>("SELECT TOP 1 * FROM Footer ORDER BY id DESC");
if (lastId != null)
{
if (lastId.ma_footer.Contains("FOO"))
{
var nextNo = Int32.Parse(lastId.ma_footer.Substring(3, 10)) + 1;
footer.ma_footer = "FOO" + String.Format("{0:0000000000}", nextNo);
}
}
else
{
footer.ma_footer = "FOO" + "0000000001";
}
footer.ten_footer = !string.IsNullOrEmpty(footer.ten_footer) ? footer.ten_footer : "";
footer.url_link = !string.IsNullOrEmpty(footer.url_link) ? footer.url_link : "";
footer.image_link = !string.IsNullOrEmpty(footer.image_link) ? footer.image_link : "";
footer.noi_dung = !string.IsNullOrEmpty(footer.noi_dung) ? footer.noi_dung : "";
footer.levels = footer.levels != 0 ? footer.levels : 0;
footer.orders = footer.orders != 0 ? footer.orders : 0;
footer.hinh_anh = footer.hinh_anh;
footer.loai = !string.IsNullOrEmpty(footer.loai) ? footer.loai : "";
footer.nguoi_tao = UserName;
footer.ngay_tao = DateTime.Now;
footer.nguoi_cap_nhat = UserName;
footer.ngay_cap_nhat = DateTime.Parse("01/01/1900");
db.Insert(footer);
}
//SyncToMySQL
List <SqlParameter> lstParameter = new List <SqlParameter>();
lstParameter.Clear();
lstParameter.Add(new SqlParameter("@ma_footer", footer.ma_footer));
new SqlHelper(connectionString).ExecuteNoneQuery("p_Footer_SyncToMySQL", lstParameter);
return("true@@" + footer.ma_footer);
}
catch (Exception e)
{
return("false@@" + e.Message);
}
}
}
public ActionResult Create(DC_LG_Discountion item)
{
IDbConnection db = new OrmliteConnection().openConn();
try
{
if (!string.IsNullOrEmpty(item.DiscountionID) &&
!string.IsNullOrEmpty(item.DiscountionName)
)
{
var isExist = db.SingleOrDefault <DC_LG_Discountion>("DiscountionID={0}", item.DiscountionID);
item.FromDate = item.FromDate != null ? item.FromDate : DateTime.Now;
item.EndDate = item.EndDate != null ? item.EndDate : DateTime.Now;
item.EndDate = item.EndDate != null ? item.EndDate : DateTime.Now;
if (item.FromDate > item.EndDate)
{
return(Json(new { success = false, message = "Ngày kết thúc không thể lớn hơn " + item.FromDate }));
}
item.Note = !string.IsNullOrEmpty(item.Note) ? item.Note : "";
item.DiscountionType = !string.IsNullOrEmpty(item.DiscountionType) ? item.DiscountionType : "";
if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.CreatedAt == null && item.CreatedBy == null)
{
if (isExist != null)
{
return(Json(new { success = false, message = "Mã chương trình chiết khấu đã tồn tại" }));
}
item.DiscountionName = !string.IsNullOrEmpty(item.DiscountionName) ? item.DiscountionName : "";
item.CreatedAt = DateTime.Now;
item.UpdatedAt = DateTime.Now;
item.CreatedBy = currentUser.UserID;
db.Insert(item);
return(Json(new { success = true, DiscountionID = item.DiscountionID, CreatedBy = item.CreatedBy, CreatedAt = item.CreatedAt }));
}
else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null)
{
item.DiscountionName = !string.IsNullOrEmpty(item.DiscountionName) ? item.DiscountionName : "";
item.CreatedAt = item.CreatedAt;
item.UpdatedAt = DateTime.Now;
item.CreatedBy = currentUser.UserID;
db.Update(item);
return(Json(new { success = true }));
}
else
{
return(Json(new { success = false, message = "Bạn không có quyền" }));
}
}
else
{
return(Json(new { success = false, message = "Chưa nhập đủ giá trị" }));
}
}
catch (Exception e)
{
log.Error("DeliveryDiscountion - Create - " + e.Message);
return(Json(new { success = false, message = e.Message }));
}
finally { db.Close(); }
}
public ActionResult UpdateDetail([DataSourceRequest] DataSourceRequest request, [Bind(Prefix = "models")] IEnumerable <SODetail> list)
{
var dbConn = new OrmliteConnection().openConn();
if (userAsset.ContainsKey("Update") && userAsset["Update"])
{
if (list != null)//&& ModelState.IsValid)
{
foreach (var item in list)
{
if (dbConn.Select <SOHeader>(s => s.SONumber == item.SONumber && s.Status != "Mới").Count() > 0)
{
return(Json(new { success = false, message = "Đơn hàng đã xác nhận nên không được xóa." }));
}
else if (item.Qty > 0)
{
var isExist = dbConn.SingleOrDefault <SODetail>("SONumber = {0} AND ItemCode = {1}", item.SONumber, item.ItemCode);
if (isExist != null)
{
try
{
isExist.Qty = item.Qty;
isExist.TotalAmt = item.Qty * item.Price;
isExist.UpdatedAt = DateTime.Now;
isExist.UpdatedBy = currentUser.UserID;
dbConn.Update <SODetail>(isExist);
//dbConn.Update<SODetail>(set: "Qty = '" + item.Qty + "', TotalAmt = '" + item.Qty * item.Price + "',UpdatedAt = '" + DateTime.Now + "', UpdatedBy ='" + currentUser.UserID + "'", where: "SONumber = '" + item.SONumber + "' AND ItemCode ='" + item.ItemCode + "'");
dbConn.Update <SOHeader>(set: "UpdatedBy='" + currentUser.UserID + "',TotalQty ='" + dbConn.Select <SODetail>(s => s.SONumber == item.SONumber).Sum(s => s.Qty) + "', TotalAmt = '" + dbConn.Select <SODetail>(s => s.SONumber == item.SONumber).Sum(s => s.TotalAmt) + "'", where : "SONumber ='" + item.SONumber + "'");
var success = dbConn.Execute(@"UPDATE SOHeader Set UpdatedAt = @UpdatedAt WHERE SONumber = '" + item.SONumber + "'",
new
{
UpdatedAt = DateTime.Now,
}) == 1;
}
catch (Exception ex)
{
ModelState.AddModelError("error", ex.Message);
return(Json(list.ToDataSourceResult(request, ModelState)));
}
}
}
else
{
ModelState.AddModelError("error", "Đơn hàng được tạo khi số lượng > 0");
return(Json(list.ToDataSourceResult(request, ModelState)));
}
}
}
dbConn.Close();
return(Json(new { sussess = true }));
}
else
{
dbConn.Close();
ModelState.AddModelError("error", "Bạn không có quyền cập nhật.");
return(Json(list.ToDataSourceResult(request, ModelState)));
}
}
public string UpdateStatus(string id, string UserName, string type, string status, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
var checkID = db.SingleOrDefault <Product_Info>("id={0}", id);
if (checkID != null)
{
if (type == "duyet")
{
if (checkID.trang_thai == AllConstant.trang_thai.DANG_SU_DUNG)
{
checkID.trang_thai_duyet = status;
}
else
{
return("Không được duyệt do sản phẩm chưa hoạt động");
}
//db.Update(set: "trang_thai_duyet={0}".Params(status), where: "id='" + id +"'");
}
if (type == "xuatban")
{
if (checkID.trang_thai == AllConstant.trang_thai.DANG_SU_DUNG)
{
if (checkID.trang_thai_duyet != AllConstant.trang_thai_duyet.TU_CHOI)
{
checkID.trang_thai_duyet = AllConstant.trang_thai_duyet.DA_DUYET;
checkID.trang_thai_xuat_ban = status;
//db.Update(set: "trang_thai_xuat_ban={0},ngay_cap_nhat={1},nguoi_cap_nhat={2}".Params(status, DateTime.Now, UserName), where: "id='" + id + "'");
}
else
{
return("Không được phép xuất bản do sản phẩm đã bị từ chối duyệt");
}
}
else
{
return("Chưa được xuất bản do sản phẩm chưa hoạt động");
}
}
checkID.ngay_cap_nhat = DateTime.Now;
checkID.nguoi_cap_nhat = UserName;
db.Update(checkID);
}
dbTrans.Commit();
return("true");
}
catch (Exception e)
{
dbTrans.Rollback();
return(e.Message.ToString());
}
}
}
}
public string CreateUpdate(BrandManagement brand, string UserName, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
try
{
var checkID = db.SingleOrDefault <BrandManagement>("ma_thuong_hieu={0}", brand.ma_thuong_hieu);
if (checkID != null)
{
checkID.logo = (!string.IsNullOrEmpty(brand.logo) && checkID.logo != brand.logo) ? brand.logo : checkID.logo;
checkID.ten_thuong_hieu = !string.IsNullOrEmpty(brand.ten_thuong_hieu) ? brand.ten_thuong_hieu : checkID.ten_thuong_hieu;
checkID.trang_thai = !string.IsNullOrEmpty(brand.trang_thai) ? brand.trang_thai : checkID.trang_thai;
checkID.mo_ta = !string.IsNullOrEmpty(brand.mo_ta) ? brand.mo_ta : checkID.mo_ta;
checkID.slug = StringHelper.convertToUnSign3(brand.ten_thuong_hieu);
checkID.nguoi_cap_nhat = UserName;
checkID.ngay_cap_nhat = DateTime.Now;
db.Update(checkID);
}
else
{
var lastId = db.FirstOrDefault <BrandManagement>("SELECT TOP 1 * FROM BrandManagement ORDER BY id DESC");
if (lastId != null)
{
if (lastId.ma_thuong_hieu.Contains("BRA"))
{
var nextNo = Int32.Parse(lastId.ma_thuong_hieu.Substring(3, 10)) + 1;
brand.ma_thuong_hieu = "BRA" + String.Format("{0:0000000000}", nextNo);
}
}
else
{
brand.ma_thuong_hieu = "BRA" + "0000000001";
}
brand.logo = !string.IsNullOrEmpty(brand.logo) ? brand.logo : "";
brand.ten_thuong_hieu = !string.IsNullOrEmpty(brand.ten_thuong_hieu) ? brand.ten_thuong_hieu : "";
brand.trang_thai = !string.IsNullOrEmpty(brand.trang_thai) ? brand.trang_thai : AllConstant.trang_thai.DANG_SU_DUNG;
brand.mo_ta = !string.IsNullOrEmpty(brand.mo_ta) ? brand.mo_ta : "";
brand.slug = StringHelper.convertToUnSign3(brand.ten_thuong_hieu);
brand.nguoi_tao = UserName;
brand.ngay_tao = DateTime.Now;
brand.nguoi_cap_nhat = UserName;
brand.ngay_cap_nhat = DateTime.Now;
db.Insert(brand);
}
//SyncToMySQL
List <SqlParameter> lstParameter = new List <SqlParameter>();
lstParameter.Clear();
lstParameter.Add(new SqlParameter("@ma_thuong_hieu", brand.ma_thuong_hieu));
new SqlHelper(connectionString).ExecuteNoneQuery("p_Brand_SyncToMySQL", lstParameter);
return("true@@" + brand.ma_thuong_hieu);
}
catch (Exception e)
{
return("false@@" + e.Message);
}
}
}
public string Upsert(List <Merchant_Product_Promotion> list, string UserName, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
foreach (Merchant_Product_Promotion item in list)
{
var checkID = db.SingleOrDefault <Merchant_Product_Promotion>("id={0}", item.id);
if (checkID != null)
{
checkID.nguoi_cap_nhat = UserName;
checkID.ngay_cap_nhat = DateTime.Now;
checkID.ten_chuong_trinh_km = item.ten_chuong_trinh_km;
checkID.loai = item.loai;
checkID.gia_tri = item.gia_tri;
db.Update(checkID);
}
else
{
string PromotionID = String.Empty;
var lastId = db.FirstOrDefault <Merchant_Product_Promotion>("SELECT TOP 1 * FROM Merchant_Product_Promotion ORDER BY id DESC");
if (lastId != null)
{
if (lastId.ma_chuong_trinh_km.Contains("KM"))
{
var nextNo = Int32.Parse(lastId.ma_chuong_trinh_km.Substring(2, 7)) + 1;
PromotionID = "KM" + String.Format("{0:0000000}", nextNo);
}
}
else
{
PromotionID = "KM" + "0000001";
}
item.trang_thai = AllConstant.trang_thai.DANG_SU_DUNG;
item.ma_chuong_trinh_km = PromotionID;
item.ngay_tao = DateTime.Now;
item.nguoi_tao = UserName;
item.ngay_cap_nhat = DateTime.Parse("1900-1-1");
db.Insert(item);
}
}
dbTrans.Commit();
return("true");
}
catch (Exception e)
{
dbTrans.Rollback();
return(e.Message.ToString());
}
}
}
}
public string CreateMerchant(Merchant_Info row, string UserName, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
//using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
var checkID = db.SingleOrDefault <Merchant_Info>("id={0}", row.id);
if (checkID == null)
{
string ma_gian_hang = String.Empty;
var lastId = db.FirstOrDefault <Merchant_Info>("SELECT TOP 1 * FROM Merchant_Info ORDER BY id DESC");
if (lastId != null)
{
if (lastId.ma_gian_hang.Contains("GH"))
{
var nextNo = Int32.Parse(lastId.ma_gian_hang.Substring(7, 2)) + 1;
ma_gian_hang = "GH" + String.Format("{0:0000000}", nextNo);
}
}
else
{
ma_gian_hang = "GH0000001";
}
row.ma_gian_hang = ma_gian_hang;
row.slug = StringHelper.convertToUnSign3(row.ten_gian_hang);
row.ngay_tao = DateTime.Now;
row.nguoi_tao = UserName;
row.ngay_tiep_xuc = !string.IsNullOrEmpty(row.ngay_tiep_xuc.ToString()) ? row.ngay_tiep_xuc : DateTime.Parse("1900-01-01");
row.ngay_ky_hop_dong = !string.IsNullOrEmpty(row.ngay_tiep_xuc.ToString()) ? row.ngay_tiep_xuc : DateTime.Parse("1900-01-01");
row.ngay_duyet = !string.IsNullOrEmpty(row.ngay_duyet.ToString()) ? row.ngay_duyet : DateTime.Parse("1900-01-01");
row.ngay_hoat_dong = !string.IsNullOrEmpty(row.ngay_hoat_dong.ToString()) ? row.ngay_hoat_dong : DateTime.Parse("1900-01-01");
row.trang_thai_duyet = AllConstant.trang_thai_duyet.CHUA_DUYET;
row.trang_thai_xuat_ban = AllConstant.trang_thai_xuat_ban.CHUA_XUAT_BAN;
row.trang_thai_xac_thuc = AllConstant.trang_thai_xac_thuc.CHUA_XAC_THUC;
row.ngay_tao = DateTime.Now;
row.nguoi_tao = "System";
row.ngay_cap_nhat = DateTime.Now;
row.nguoi_cap_nhat = "System";
db.Insert(row);
new SqlHelper().ExecuteNoneQuery("update tw_User set ma_gian_hang='" + ma_gian_hang + "' where name='" + UserName + "'", new List <SqlParameter>(), CommandType.Text);
}
//dbTrans.Commit();
return("true");
}
catch (Exception e)
{
//dbTrans.Rollback();
return(e.Message.ToString());
}
}
}
}
//
// GET: /DeliveryManage/Create
public ActionResult Create(DC_LG_Transporter item)
{
IDbConnection db = new OrmliteConnection().openConn();
try
{
if (//!string.IsNullOrEmpty(item.TransporterID) &&
!string.IsNullOrEmpty(item.TransporterName)
)
{
int n;
var isExist = db.SingleOrDefault <DC_LG_Transporter>("TransporterID={0}", item.TransporterID);
item.Weight = int.TryParse(item.Weight.ToString(), out n) ? item.Weight : 0;
item.Note = !string.IsNullOrEmpty(item.Note) ? item.Note : "";
if (userAsset.ContainsKey("Insert") && userAsset["Insert"] && item.CreatedAt == null && item.CreatedBy == null)
{
if (isExist != null)
{
return(Json(new { success = false, message = "Mã đơn vị vận chuyển đã tồn tại!" }));
}
item.TransporterName = !string.IsNullOrEmpty(item.TransporterName) ? item.TransporterName : "";
item.CreatedAt = DateTime.Now;
item.UpdatedAt = DateTime.Now;
item.CreatedBy = currentUser.UserID;
item.UpdatedBy = currentUser.UserID;
db.Insert(item);
return(Json(new { success = true, TransporterID = item.TransporterID, CreatedBy = item.CreatedBy, CreatedAt = item.CreatedAt }));
}
else if (userAsset.ContainsKey("Update") && userAsset["Update"] && isExist != null)
{
item.TransporterName = !string.IsNullOrEmpty(item.TransporterName) ? item.TransporterName : "";
item.CreatedAt = item.CreatedAt;
item.UpdatedAt = DateTime.Now;
item.CreatedBy = currentUser.UserID;
item.UpdatedBy = currentUser.UserID;
db.Update(item);
return(Json(new { success = true }));
}
else
{
return(Json(new { success = false, message = "Bạn không có quyền" }));
}
}
else
{
return(Json(new { success = false, message = "Chưa nhập giá trị" }));
}
}
catch (Exception e)
{
log.Error("Transporter - Create - " + e.Message);
return(Json(new { success = false, message = e.Message }));
}
finally { db.Close(); }
}
public string UpSert(List <Image_Info> list, string UserName, string Type, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
foreach (Image_Info row in list)
{
var checkID = db.SingleOrDefault <Image_Info>("id={0}", row.id);
if (checkID != null)
{
row.ngay_cap_nhat = DateTime.Now;
row.nguoi_cap_nhat = UserName;
row.nguoi_tao = checkID.nguoi_tao;
row.ngay_tao = checkID.ngay_tao;
db.Update(row);
}
else
{
string ma_tu_tang = String.Empty;
var lastId = db.FirstOrDefault <Image_Info>("SELECT TOP 1 * FROM Image_Info ORDER BY id DESC");
if (lastId != null)
{
if (lastId.ma_thong_tin_anh.Contains("IM"))
{
var nextNo = Int32.Parse(lastId.ma_thong_tin_anh.Substring(2, 13)) + 1;
ma_tu_tang = "IM" + String.Format("{0:0000000000000}", nextNo);
}
}
else
{
ma_tu_tang = "IM0000000000001";
}
row.ma_thong_tin_anh = ma_tu_tang;
row.ngay_tao = DateTime.Now;
row.ngay_duyet = row.ngay_cap_nhat = DateTime.Parse("1900-01-01");
row.nguoi_tao = UserName;
row.nguoi_cap_nhat = row.nguoi_duyet = "";
db.Insert(row);
}
}
dbTrans.Commit();
return("true");
}
catch (Exception e)
{
dbTrans.Rollback();
return(e.Message.ToString());
}
}
}
}
public Merchant_Info ReadByMerchantID(string ma_gian_hang, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
Merchant_Info data = db.SingleOrDefault <Merchant_Info>("ma_gian_hang = {0}", ma_gian_hang);
if (data == null)
{
return(new Merchant_Info());
}
return(data);
}
}
public string UpSert(List <Merchant_Image> lstProdInfo, string UserName, string Type, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
foreach (Merchant_Image row in lstProdInfo)
{
var checkID = db.SingleOrDefault <Merchant_Image>("id={0}", row.id);
if (checkID != null)
{
if (String.IsNullOrEmpty(row.ten_anh))
{
row.ten_anh = checkID.ten_anh;
}
else
{
if (!String.IsNullOrEmpty(checkID.ten_anh))
{
var path = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Images/Merchant_Info/"), checkID.ten_anh);
if (!String.IsNullOrEmpty(path))
{
System.IO.File.Delete(path);
}
}
}
row.ngay_cap_nhat = DateTime.Now;
row.nguoi_cap_nhat = UserName;
db.Update(EmptyIfNull(row));
}
else
{
//row.ngay_duyet = row.ngay_xuat_ban = DateTime.Now;//chua biet
row.ngay_tao = row.ngay_cap_nhat = DateTime.Now;
//row.nguoi_duyet = row.nguoi_tao = UserName;
row.nguoi_tao = UserName;
db.Insert(EmptyIfNull(row));
}
}
dbTrans.Commit();
return("true");
}
catch (Exception e)
{
dbTrans.Rollback();
return(e.Message.ToString());
}
}
}
}
public string UpSert(List <Merchant_Image_Info> list, string UserName, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
// using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
foreach (Merchant_Image_Info row in list)
{
var checkID = db.SingleOrDefault <Merchant_Image_Info>("id={0}", row.id);
if (checkID != null)
{
row.ngay_cap_nhat = DateTime.Now;
row.nguoi_cap_nhat = UserName;
row.nguoi_tao = checkID.nguoi_tao;
row.ngay_tao = checkID.ngay_tao;
db.Update(row);
}
else
{
row.nguoi_tao = UserName;
row.nguoi_cap_nhat = UserName;
List <SqlParameter> lstParameter = new List <SqlParameter>();
lstParameter.Add(new SqlParameter("@ma_gian_hang", row.ma_gian_hang));
lstParameter.Add(new SqlParameter("@ten_anh", row.ten_anh));
lstParameter.Add(new SqlParameter("@loai", row.loai));
lstParameter.Add(new SqlParameter("@ma_anh_goc", row.ma_anh_goc));
lstParameter.Add(new SqlParameter("@mo_ta", row.mo_ta));
lstParameter.Add(new SqlParameter("@mo_ta_khong_dau", row.mo_ta_khong_dau));
lstParameter.Add(new SqlParameter("@thu_muc", row.thu_muc));
lstParameter.Add(new SqlParameter("@url", row.url));
lstParameter.Add(new SqlParameter("@duong_dan_day_du", row.duong_dan_day_du));
lstParameter.Add(new SqlParameter("@dung_luong", row.dung_luong));
lstParameter.Add(new SqlParameter("@chieu_rong", row.chieu_rong));
lstParameter.Add(new SqlParameter("@chieu_cao", row.chieu_cao));
lstParameter.Add(new SqlParameter("@nguoi_tao", row.nguoi_tao));
lstParameter.Add(new SqlParameter("@nguoi_cap_nhat", row.nguoi_cap_nhat));
new SqlHelper(connectionString).ExecuteNoneQuery("p_Merchant_Image_Info_Create", lstParameter);
}
}
// dbTrans.Commit();
return("true");
}
catch (Exception e)
{
// dbTrans.Rollback();
return(e.Message.ToString());
}
}
}
}
public ActionResult UpdateAction([DataSourceRequest] DataSourceRequest request, int roleid, string menuid, [Bind(Prefix = "models")] IEnumerable <Auth_Action> lst)
{
if (userAsset.ContainsKey("Update") && userAsset["Update"])
{
IDbConnection db = new OrmliteConnection().openConn();
foreach (var item in lst)
{
if (item != null)
{
if (string.IsNullOrEmpty(item.Action))
{
ModelState.AddModelError("er", "Xin nhập quyền");
return(Json(lst.ToDataSourceResult(request, ModelState)));
}
var isExist = db.SingleOrDefault <Auth_Action>("RoleID = {0} AND MenuID = {1} AND Action = {2}", roleid, menuid, item.Action);
if (isExist != null)
{
try
{
item.RoleID = roleid;
item.MenuID = menuid;
item.Note = "";
item.RowCreatedAt = isExist.RowCreatedAt;
item.RowCreatedBy = isExist.RowCreatedBy;
item.RowUpdatedAt = DateTime.Now;
item.RowUpdatedBy = currentUser.UserID;
db.Update <Auth_Action>(item, p => p.RoleID == roleid && p.MenuID == menuid && p.Action == item.Action);
}
catch (Exception ex)
{
ModelState.AddModelError("er", ex.Message);
return(Json(lst.ToDataSourceResult(request, ModelState)));
}
}
else
{
ModelState.AddModelError("er", "Quyền không tồn tại");
return(Json(lst.ToDataSourceResult(request, ModelState)));
}
}
}
db.Close();
return(Json(lst.ToDataSourceResult(request)));
}
else
{
ModelState.AddModelError("er", "Bạn không có quyền cập nhật");
return(Json(lst.ToDataSourceResult(request, ModelState)));
}
}
public ActionResult GetPrinterbycode(string PrinterID)
{
IDbConnection dbConn = new OrmliteConnection().openConn();
try
{
var data = dbConn.SingleOrDefault <DC_AD_Printer>("PrinterID={0}", PrinterID);
return(Json(new { success = true, data = data }));
}
catch (Exception e)
{
return(Json(new { success = false, message = e.Message }));
}
finally { dbConn.Close(); }
}
public ActionResult GetFormulaByID(string FormulaID)
{
IDbConnection dbConn = new OrmliteConnection().openConn();
try
{
var data = dbConn.SingleOrDefault <DC_Formula>("FormulaID={0}", FormulaID);
return(Json(new { success = true, data = data }));
}
catch (Exception e)
{
return(Json(new { success = false, message = e.Message }));
}
finally { dbConn.Close(); }
}
public ActionResult GetDiscountionCode(string DiscountionID)
{
IDbConnection dbConn = new OrmliteConnection().openConn();
try
{
var data = dbConn.SingleOrDefault <DC_LG_Discountion>("DiscountionID={0}", DiscountionID);
return(Json(new { success = true, data = data }));
}
catch (Exception e)
{
return(Json(new { success = false, message = e.Message }));
}
finally { dbConn.Close(); }
}
public ActionResult GetDeliveryByCode(string TransporterID)
{
IDbConnection dbConn = new OrmliteConnection().openConn();
try
{
var data = dbConn.SingleOrDefault <DC_LG_Transporter>("TransporterID={0}", TransporterID);
return(Json(new { success = true, data = data }));
}
catch (Exception e)
{
return(Json(new { success = false, message = e.Message }));
}
finally { dbConn.Close(); }
}
public static FE_ContactRequest GetDefaultContactRequest(int UserId)
{
try
{
IDbConnection dbConn = new OrmliteConnection().openConn();
var item = dbConn.SingleOrDefault <ContactRequest>("isactive={0} and userid = {1} and userid <> 0", 1, UserId);
if (item == null)
{
return(new FE_ContactRequest());
}
return(Mapper.Map <FE_ContactRequest>(item));
}
catch (Exception ex)
{
return(new FE_ContactRequest());
}
}
public string UpSert(List <Banner> lstBanners, string UserName, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
try
{
foreach (Banner row in lstBanners)
{
var checkID = db.SingleOrDefault <Banner>("id={0}", row.id);
if (checkID != null)
{
checkID.url_link = !string.IsNullOrEmpty(row.url_link.ToString()) ? row.url_link : "";
checkID.image = !string.IsNullOrEmpty(row.image) ? row.image : "";
checkID.ma_chuyen_muc = !string.IsNullOrEmpty(row.ma_chuyen_muc) ? row.ma_chuyen_muc : "";
checkID.vi_tri = !string.IsNullOrEmpty(row.vi_tri) ? row.vi_tri : "";
checkID.alt = !string.IsNullOrEmpty(row.alt) ? row.alt : "";
checkID.trang_thai = !string.IsNullOrEmpty(row.trang_thai) ? row.trang_thai : AllConstant.trang_thai.DANG_SU_DUNG;
checkID.nguoi_cap_nhat = UserName;
checkID.ngay_cap_nhat = DateTime.Now;
db.Update(checkID);
}
else
{
row.url_link = !string.IsNullOrEmpty(row.url_link.ToString()) ? row.url_link : "";
row.image = !string.IsNullOrEmpty(row.image) ? row.image : "";
row.ma_chuyen_muc = !string.IsNullOrEmpty(row.ma_chuyen_muc) ? row.ma_chuyen_muc : "";
row.vi_tri = !string.IsNullOrEmpty(row.vi_tri) ? row.vi_tri : "";
row.trang_thai = !string.IsNullOrEmpty(row.trang_thai) ? row.trang_thai : AllConstant.trang_thai.DANG_SU_DUNG;
row.alt = !string.IsNullOrEmpty(row.alt) ? row.alt : "";
row.nguoi_tao = UserName;
row.ngay_tao = DateTime.Now;
row.nguoi_cap_nhat = UserName;
row.ngay_cap_nhat = DateTime.Now;
db.Insert(row);
}
}
return("true");
}
catch (Exception e)
{
return(e.Message.ToString());
}
}
}
public string UpSert(Merchant_Catalog catalog, string UserName, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
try
{
var checkID = db.SingleOrDefault <Merchant_Catalog>("id={0}", catalog.id);
if (checkID != null)
{
catalog.ngay_cap_nhat = DateTime.Now;
catalog.nguoi_cap_nhat = UserName;
catalog.nguoi_tao = checkID.nguoi_tao;
catalog.ngay_tao = checkID.ngay_tao;
db.Update(catalog);
}
else
{
catalog.nguoi_tao = UserName;
catalog.nguoi_cap_nhat = UserName;
catalog.ngay_tao = DateTime.Now;
catalog.ngay_cap_nhat = DateTime.Now;
var lastId = db.FirstOrDefault <Merchant_Catalog>("SELECT TOP 1 * FROM Merchant_Catalog ORDER BY id DESC");
if (lastId != null)
{
if (lastId.ma_catalog.Contains("CAT"))
{
var nextNo = Int32.Parse(lastId.ma_catalog.Substring(3, 10)) + 1;
catalog.ma_catalog = "CAT" + String.Format("{0:0000000000}", nextNo);
}
}
else
{
catalog.ma_catalog = "CAT" + "0000000001";
}
db.Insert(catalog);
}
return("true");
}
catch (Exception e)
{
return(e.Message.ToString());
}
}
}
//Chuyển trạng thái sản phẩm sang trạng thái ngưng sử dụng
public string ChangeStatus(string[] ids, string connectionString, string Username, string status)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
try
{
foreach (var id in ids)
{
var checkID = db.SingleOrDefault <Merchant_Product>("id={0}", id);
if (checkID != null)
{
checkID.trang_thai = (status == AllConstant.trang_thai.DANG_SU_DUNG) ? AllConstant.trang_thai.DANG_SU_DUNG : AllConstant.trang_thai.KHONG_SU_DUNG;
checkID.trang_thai_duyet = AllConstant.trang_thai_duyet.CHUA_DUYET;
checkID.trang_thai_xuat_ban = AllConstant.trang_thai_xuat_ban.CHUA_XUAT_BAN;
checkID.nguoi_cap_nhat = Username;
checkID.ngay_cap_nhat = DateTime.Now;
db.UpdateOnly(checkID,
onlyFields: p =>
new
{
p.trang_thai,
p.trang_thai_xuat_ban,
p.trang_thai_duyet,
p.nguoi_cap_nhat,
p.ngay_cap_nhat
},
where : p => p.id == checkID.id);
string rs = SyncToMySQL(id, connectionString);
if (rs != "true")
{
return("Lỗi đồng bộ!");
}
}
}
return("true");
}
catch (Exception e)
{
return(e.Message.ToString());
}
}
}
public string UpSert(List <Entities.Merchant_Product_Related> list, string ma_san_pham_de_nghi, string UserName, string Type, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
foreach (Entities.Merchant_Product_Related row in list)
{
var checkID = db.SingleOrDefault <Entities.Merchant_Product_Related>("ma_san_pham={0}", row.ma_san_pham_de_nghi);
if (checkID == null)
{
string ma_tu_tang = String.Empty;
var lastId = db.FirstOrDefault <Hierarchy>("SELECT TOP 1 * FROM Hierarchy ORDER BY id DESC");
if (lastId != null)
{
if (lastId.ma_phan_cap.Contains("CAP"))
{
var nextNo = Int32.Parse(lastId.ma_phan_cap.Substring(3, 3)) + 1;
ma_tu_tang = "CAP" + String.Format("{0:000}", nextNo);
}
}
else
{
ma_tu_tang = "CAP001";
}
row.ma_san_pham_de_nghi = ma_tu_tang;
db.Insert(row);
}
}
dbTrans.Commit();
return("true");
}
catch (Exception e)
{
dbTrans.Rollback();
return(e.Message.ToString());
}
}
}
}
public string ChangeStatusApproval(string[] ids, string connectionString, string Username)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
try
{
foreach (var id in ids)
{
var checkID = db.SingleOrDefault <Merchant_Info>("id={0}", id);
if (checkID != null)
{
checkID.trang_thai_duyet = (checkID.trang_thai_duyet == AllConstant.trang_thai_duyet.DA_DUYET) ? AllConstant.trang_thai_duyet.TU_CHOI : AllConstant.trang_thai_duyet.DA_DUYET;
checkID.nguoi_duyet = checkID.nguoi_cap_nhat = Username;
checkID.ngay_duyet = checkID.ngay_cap_nhat = DateTime.Now;
db.UpdateOnly(checkID,
onlyFields: p =>
new
{
p.trang_thai_duyet,
p.nguoi_duyet,
p.ngay_duyet,
p.nguoi_cap_nhat,
p.ngay_cap_nhat
},
where : p => p.id == checkID.id);
string rs = SyncToMySQL(id, connectionString);
if (rs != "true")
{
return("Lỗi đồng bộ!");
}
}
}
return("true");
}
catch (Exception e)
{
return(e.Message.ToString());
}
}
}
public string Delete(string ma_thuong_hieu, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
try
{
var checkID = db.SingleOrDefault <BrandManagement>("ma_thuong_hieu={0}", ma_thuong_hieu);
if (checkID == null)
{
return("Không có thương hiệu này!");
}
List <SqlParameter> param = new List <SqlParameter>();
param.Add(new SqlParameter("@ma_thuong_hieu", ma_thuong_hieu));
new SqlHelper().ExecuteNoneQuery("delete BrandManagement where ma_thuong_hieu = @ma_thuong_hieu", param, CommandType.Text);
return("true");
}
catch (Exception e)
{
return(e.Message.ToString());
}
}
}
public void UpSert(List <Product_Merchant> lstProduct_Merchant, string UserName, string Type, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
foreach (Product_Merchant row in lstProduct_Merchant)
{
var checkID = db.SingleOrDefault <Product_Merchant>("id={0}", row.id);
if (checkID != null)
{
row.ngay_cap_nhat = DateTime.Now;
row.nguoi_cap_nhat = UserName;
if (checkID.trang_thai_duyet != row.trang_thai_duyet && (row.trang_thai_duyet == BIBIAM.Core.AllConstant.trang_thai_duyet.DA_DUYET || row.trang_thai_duyet == BIBIAM.Core.AllConstant.trang_thai_duyet.TU_CHOI))
{
row.ngay_duyet = DateTime.Now;
row.nguoi_duyet = UserName;
}
db.Update(row);
}
else
{
row.ngay_tao = row.ngay_cap_nhat = DateTime.Now;
row.nguoi_tao = row.nguoi_cap_nhat = UserName;
db.Save(row);
}
}
dbTrans.Commit();
}
catch
{
dbTrans.Rollback();
}
}
}
}
public string UpSert(List <Merchant_Contact> list, string UserName, string Type, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
foreach (Merchant_Contact row in list)
{
var checkID = db.SingleOrDefault <Merchant_Contact>("id={0}", row.id);
if (checkID != null)
{
row.ngay_cap_nhat = DateTime.Now;
row.nguoi_cap_nhat = UserName;
row.ngay_tao = checkID.ngay_tao;
row.nguoi_cap_nhat = checkID.nguoi_tao;
db.Update(EmptyIfNull(row));
}
else
{
row.ngay_tao = row.ngay_cap_nhat = DateTime.Now;
row.nguoi_tao = row.nguoi_cap_nhat = UserName;
db.Insert(EmptyIfNull(row));
}
}
dbTrans.Commit();
return("true");
}
catch (Exception e)
{
dbTrans.Rollback();
return(e.Message.ToString());
}
}
}
}
public string Delete(string[] ids, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
var checkID = db.SingleOrDefault <Image_Info>("id={0}", ids[0]);
foreach (var id in ids)
{
db.Delete <Image_Info>(s => s.id == int.Parse(id));
}
dbTrans.Commit();
return("true");
}
catch (Exception e)
{
dbTrans.Rollback();
return(e.Message.ToString());
}
}
}
}