public ActionResult SavePermission(int RoleID, string Action, string MenuIDs)
{
IDbConnection db = new OrmliteConnection().openConn();
try
{
if (RoleID == 0 || string.IsNullOrEmpty(Action))
{
return(Json(new { success = false, message = "Có dữ liệu rỗng" }));
}
if (string.IsNullOrEmpty(MenuIDs))
{
db.UpdateOnly(new Auth_Action()
{
IsAllowed = false, RowUpdatedAt = DateTime.Now, RowUpdatedBy = currentUser.UserID
},
onlyFields: p => new { p.IsAllowed, p.RowUpdatedAt, p.RowUpdatedBy },
where : p => p.RoleID == RoleID && p.Action == Action);
}
else
{
db.ExecuteNonQuery("p_Auth_Action_Save_By_RoleID @RoleID, @UserID, @Action, @MenuIDs", new
{
RoleID = RoleID,
UserID = currentUser.UserID,
Action = Action,
MenuIDs = MenuIDs
});
}
return(Json(new { success = true }));
}
catch (Exception e) { return(Json(new { success = false, message = e.Message })); }
finally { db.Close(); }
}
public ActionResult SaveCustomerHirerachy(string CustomerID, string CustomerHirerachyIDs)
{
IDbConnection db = new OrmliteConnection().openConn();
try
{
if (string.IsNullOrEmpty(CustomerHirerachyIDs))
{
db.UpdateOnly(new CustomerHirerachyDetail()
{
Status = false, UpdatedAt = DateTime.Now, UpdatedBy = currentUser.UserID
},
onlyFields: p => new { p.Status, p.UpdatedAt, p.UpdatedBy },
where : p => p.CustomerID == CustomerID);
}
else
{
db.ExecuteNonQuery("p_CustomerHirerachyDetail_Save_By_CustomerID @CustomerID, @UserID, @CustomerHirerachyIDs", new
{
CustomerID = CustomerID,
UserID = currentUser.UserID,
CustomerHirerachyIDs = CustomerHirerachyIDs
});
}
return(Json(new { success = true }));
}
catch (Exception e) { return(Json(new { success = false, message = e.Message })); }
finally { db.Close(); }
}
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 UpdateProduct(Merchant_Product product, Merchant_Product_Hierarchy hierarchy, List <Merchant_Product_Image> listimage, List <Merchant_Product_Property> listproperty, string connectstring)
{
using (var db = new OrmliteConnection().openConn(connectstring))
{
try
{
Merchant_Product checkProduct;
if (product.ma_gian_hang == "All")
{
checkProduct = db.FirstOrDefault <Merchant_Product>("ma_san_pham = {0}", product.ma_san_pham);
}
else
{
checkProduct = db.FirstOrDefault <Merchant_Product>("ma_san_pham = {0} and ma_gian_hang = {1}", product.ma_san_pham, product.ma_gian_hang);
}
if (checkProduct == null)
{
return("Thông tin không hợp lệ");
}
checkProduct.url = (!string.IsNullOrEmpty(product.url) && checkProduct.url != product.url) ? product.url : checkProduct.url;
checkProduct.catalog = (!string.IsNullOrEmpty(product.catalog) && checkProduct.catalog != product.catalog) ? product.catalog : checkProduct.catalog;
checkProduct.ma_loai_san_pham = !string.IsNullOrEmpty(product.ma_loai_san_pham) ? product.ma_loai_san_pham : checkProduct.ma_loai_san_pham;
checkProduct.part_no = !string.IsNullOrEmpty(product.part_no) ? product.part_no : checkProduct.part_no;
checkProduct.ten_san_pham = !string.IsNullOrEmpty(product.ten_san_pham) ? product.ten_san_pham : checkProduct.ten_san_pham;
checkProduct.mo_ta = !string.IsNullOrEmpty(product.mo_ta) ? product.mo_ta : "";
checkProduct.noi_dung = !string.IsNullOrEmpty(product.noi_dung) ? product.noi_dung : "";
checkProduct.tu_khoa = !string.IsNullOrEmpty(product.tu_khoa) ? product.tu_khoa : "";
checkProduct.tag = !string.IsNullOrEmpty(product.tag) ? product.tag : "";
checkProduct.slug = !string.IsNullOrEmpty(product.slug) ? product.slug : "";
checkProduct.xuat_xu = !string.IsNullOrEmpty(product.xuat_xu) ? product.xuat_xu : "";
checkProduct.thuong_hieu = !string.IsNullOrEmpty(product.thuong_hieu) ? product.thuong_hieu : "";
checkProduct.model = !string.IsNullOrEmpty(product.model) ? product.model : "";
checkProduct.khoi_luong = product.khoi_luong;
checkProduct.gia_si = product.gia_si;
checkProduct.don_gia = product.don_gia;
checkProduct.trang_thai = product.trang_thai;
checkProduct.trang_thai_xuat_ban = AllConstant.trang_thai_xuat_ban.CHUA_XUAT_BAN;
checkProduct.trang_thai_duyet = AllConstant.trang_thai_duyet.CHUA_DUYET;
checkProduct.nguoi_cap_nhat = product.nguoi_cap_nhat;
checkProduct.ngay_cap_nhat = DateTime.Now;
db.Update(checkProduct);
//List<SqlParameter> param = new List<SqlParameter>();
//param.Add(new SqlParameter("@id", checkProduct.id));
//new SqlHelper().ExecuteQuery("p_UpdateSlugForMerchantProduct", param);
// Update Hierarchy
var checkHierarchy = db.FirstOrDefault <Merchant_Product_Hierarchy>(@"ma_san_pham = {0} and ma_gian_hang = {1} and
ma_cay_phan_cap_1 = {2} and ma_cay_phan_cap_2 = {3}
and ma_cay_phan_cap_3 = {4} ",
checkProduct.ma_san_pham,
checkProduct.ma_gian_hang,
hierarchy.ma_cay_phan_cap_1,
hierarchy.ma_cay_phan_cap_2,
hierarchy.ma_cay_phan_cap_3);
if (checkHierarchy != null)
{
db.ExecuteNonQuery(@"update Merchant_Product_Hierarchy set
ma_cay_phan_cap_1 = {0},
ma_cay_phan_cap_2 = {1},
ma_cay_phan_cap_3 = {2},
nguoi_cap_nhat = {3},
ngay_cap_nhat = {4}
where ma_san_pham = {5} and ma_gian_hang = {6}".Params(hierarchy.ma_cay_phan_cap_1,
hierarchy.ma_cay_phan_cap_2,
hierarchy.ma_cay_phan_cap_3,
product.nguoi_cap_nhat,
DateTime.Now,
checkProduct.ma_san_pham,
checkProduct.ma_gian_hang));
}
else
{
hierarchy.ma_san_pham = checkProduct.ma_san_pham;
hierarchy.ma_gian_hang = checkProduct.ma_gian_hang;
hierarchy.ngay_tao = DateTime.Now;
hierarchy.nguoi_tao = checkProduct.nguoi_tao;
hierarchy.ngay_cap_nhat = DateTime.Parse("1900-01-01");
hierarchy.trang_thai = AllConstant.trang_thai.DANG_SU_DUNG; // Giá trị đang hoạt động
db.Insert(hierarchy);
}
// Update Thumbnail
if (listimage != null)
{
db.Delete <Merchant_Product_Image>("ma_san_pham = {0} and ma_gian_hang = {1}", checkProduct.ma_san_pham, checkProduct.ma_gian_hang);
foreach (Merchant_Product_Image item in listimage)
{
if (item.id == 0)
{
item.ma_san_pham = checkProduct.ma_san_pham;
item.ma_gian_hang = checkProduct.ma_gian_hang;
item.ngay_tao = DateTime.Now;
item.nguoi_tao = product.nguoi_tao;
item.ngay_cap_nhat = DateTime.Now;
item.nguoi_cap_nhat = product.nguoi_cap_nhat;
db.Insert(item);
}
else
{
return("Lỗi khi tạo thumbnail hình ảnh");
}
}
}
// Update Property
if (listproperty != null)
{
db.Delete <Merchant_Product_Property>("ma_san_pham = {0} and ma_gian_hang = {1}", checkProduct.ma_san_pham, checkProduct.ma_gian_hang);
foreach (Merchant_Product_Property item in listproperty)
{
if (item.id == 0)
{
item.ma_gian_hang = checkProduct.ma_gian_hang;
item.ma_san_pham = checkProduct.ma_san_pham;
item.ngay_tao = DateTime.Now;
item.ngay_cap_nhat = DateTime.Parse("1900-01-01");
item.nguoi_cap_nhat = product.nguoi_cap_nhat;
item.ngay_cap_nhat = DateTime.Now;
db.Insert(item);
}
else
{
return("Lỗi khi cập nhật thuộc tính");
}
}
}
//SyncToMySQL(checkProduct.id.ToString(), product.nguoi_cap_nhat);
SyncToMySQL(checkProduct.id.ToString(), connectstring);
return("true");
}
catch (Exception ex)
{
return("Lỗi thao tác dữ liệu");
}
}
}