//public string SyncToMySQL(string id, string UserName)
//{
// Merchant_Product SyncProduct;
// Merchant_Product_Hierarchy SyncHierarchy;
// List<Merchant_Product_Image> SyncListImage;
// List<Merchant_Product_Property> SyncListProperty;
// string ProductID, MerchantID;
// using (var db = new OrmliteConnection().openConn(AppConfigs.MCCConnectionString))
// {
// try
// {
// SyncProduct = db.FirstOrDefault<Merchant_Product>("id = {0}", id);
// if (SyncProduct == null)
// return "Không tìm thấy sản phẩm";
// ProductID = SyncProduct.ma_san_pham;
// MerchantID = SyncProduct.ma_gian_hang;
// SyncHierarchy = db.FirstOrDefault<Merchant_Product_Hierarchy>("ma_san_pham = {0} and ma_gian_hang = {1}", ProductID, MerchantID);
// SyncListImage = db.Select<Merchant_Product_Image>("ma_san_pham = {0} and ma_gian_hang = {1}", ProductID, MerchantID);
// SyncListProperty = db.Select<Merchant_Product_Property>("ma_san_pham = {0} and ma_gian_hang = {1}", ProductID, MerchantID);
// }
// catch (Exception e)
// {
// return e.Message.ToString();
// }
// }
// string sqlProduct, sqlHierarchy, whereImage = "";
// List<string> sqlListImage = new List<string>();
// //List<string> sqlListProperty = new List<string>();
// using (MySqlConnection con = new MySqlConnection(AppConfigs.FEConnectionString))
// {
// con.Open();
// string sql = @"select * from Merchant_Product where ma_san_pham = {0} and ma_gian_hang = {1}".Params(ProductID, MerchantID);
// using (MySqlCommand cmd = new MySqlCommand(sql, con))
// {
// var rs = cmd.ExecuteReader();
// if (!rs.Read())
// sqlProduct = @"insert into Merchant_Product(ma_loai_san_pham,ten_san_pham,part_no,mo_ta,noi_dung,trong_so,khoi_luong,don_gia,gia_si,tu_khoa,tag,slug,url,catalog,xuat_xu,thuong_hieu,model,minimum_order,trang_thai_xuat_ban,trang_thai_duyet,trang_thai,ma_san_pham,ma_gian_hang)
// values({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21},{22})".Params(SyncProduct.ma_loai_san_pham, SyncProduct.ten_san_pham, SyncProduct.part_no, SyncProduct.mo_ta, SyncProduct.noi_dung,
// SyncProduct.trong_so, SyncProduct.khoi_luong, SyncProduct.don_gia, SyncProduct.gia_si, SyncProduct.tu_khoa, SyncProduct.tag, SyncProduct.slug, SyncProduct.url, SyncProduct.catalog,
// SyncProduct.xuat_xu, SyncProduct.thuong_hieu, SyncProduct.model, SyncProduct.minimum_order, SyncProduct.trang_thai_xuat_ban,
// SyncProduct.trang_thai_duyet, SyncProduct.trang_thai, SyncProduct.ma_san_pham, SyncProduct.ma_gian_hang);
// else
// sqlProduct = @"update Merchant_Product
// set ma_loai_san_pham = {0}, ten_san_pham = {1}, part_no = {2}, mo_ta = {3},
// noi_dung = {4},trong_so = {5},don_gia = {6},gia_si = {7},tu_khoa = {8},tag = {9},
// slug = {10},url = {11},xuat_xu = {12},thuong_hieu = {13},model = {14},minimum_order = {15},
// trang_thai_xuat_ban = {16},trang_thai_duyet = {17},trang_thai = {18}, khoi_luong = {21}, catalog = {22}
// where ma_san_pham = {19} and ma_gian_hang = {20}".Params(SyncProduct.ma_loai_san_pham, Utility.ConvertUTF(SyncProduct.ten_san_pham), SyncProduct.part_no, SyncProduct.mo_ta, SyncProduct.noi_dung,
// SyncProduct.trong_so, SyncProduct.don_gia, SyncProduct.gia_si, SyncProduct.tu_khoa, SyncProduct.tag, SyncProduct.slug, SyncProduct.url,
// SyncProduct.xuat_xu, SyncProduct.thuong_hieu, SyncProduct.model, SyncProduct.minimum_order, SyncProduct.trang_thai_xuat_ban,
// SyncProduct.trang_thai_duyet, SyncProduct.trang_thai, SyncProduct.ma_san_pham, SyncProduct.ma_gian_hang, SyncProduct.khoi_luong, SyncProduct.catalog);
// rs.Close();
// }
// sql = @"select * from Merchant_Product_Hierarchy where ma_san_pham = {0} and ma_gian_hang = {1}".Params(ProductID, MerchantID);
// using (MySqlCommand cmd = new MySqlCommand(sql, con))
// {
// var rs = cmd.ExecuteReader();
// if (!rs.Read())
// sqlHierarchy = @"insert into Merchant_Product_Hierarchy(ma_cay_phan_cap_1,ma_cay_phan_cap_2,ma_cay_phan_cap_3, trang_thai, ma_san_pham, ma_gian_hang)
// values({0},{1},{2},{3},{4},{5})".Params(SyncHierarchy.ma_cay_phan_cap_1, SyncHierarchy.ma_cay_phan_cap_2,
// SyncHierarchy.ma_cay_phan_cap_3, SyncHierarchy.trang_thai, SyncHierarchy.ma_san_pham, SyncHierarchy.ma_gian_hang);
// else
// sqlHierarchy = @"update Merchant_Product_Hierarchy
// set ma_cay_phan_cap_1 = {0}, ma_cay_phan_cap_2 = {1}, ma_cay_phan_cap_3 = {2}, trang_thai = {3}
// where ma_san_pham = {4} and ma_gian_hang = {5}".Params(SyncHierarchy.ma_cay_phan_cap_1, SyncHierarchy.ma_cay_phan_cap_2,
// SyncHierarchy.ma_cay_phan_cap_3, SyncHierarchy.trang_thai, SyncHierarchy.ma_san_pham, SyncHierarchy.ma_gian_hang);
// rs.Close();
// }
// if (SyncListImage.Count > 0)
// foreach (var Index in SyncListImage)
// {
// sql = @"select * from Merchant_Product_Image where ma_san_pham = {0} and ma_gian_hang = {1} and ma_anh_goc = {2}".Params(ProductID, MerchantID, Index.ma_anh_goc);
// using (MySqlCommand cmd = new MySqlCommand(sql, con))
// {
// var rs = cmd.ExecuteReader();
// if (!rs.Read())
// sqlListImage.Add(@"insert into Merchant_Product_Image(url,ma_anh_goc,ma_san_pham,ma_gian_hang)
// values({0},{1},{2},{3});".Params(Utility.ConvertUTF(Index.url), Index.ma_anh_goc, Index.ma_san_pham, Index.ma_gian_hang));
// else
// sqlListImage.Add(@"update Merchant_Product_Image
// set url = {0}
// where ma_anh_goc = {1} and ma_san_pham = {2} and ma_gian_hang = {3};".Params(Utility.ConvertUTF(Index.url), Index.ma_anh_goc, Index.ma_san_pham, Index.ma_gian_hang));
// rs.Close();
// }
// whereImage += "{0},".Params(Index.ma_anh_goc);
// }
// /*if (SyncListProperty.Count > 0)
// foreach (var Index in SyncListProperty)
// {
// sql = @"select * from Merchant_Product_Property where ma_san_pham = {0} and ma_gian_hang = {1} and ma_anh_goc = {2}".Params(ProductID, MerchantID, Index.ma_thong_so);
// using (MySqlCommand cmd = new MySqlCommand(sql, con))
// {
// var rs = cmd.ExecuteReader();
// if (!rs.Read())
// sqlListProperty.Add(@"insert into Merchant_Product_Image(ma_thong_so,ma_thuoc_tinh,gia_tri,ma_san_pham,ma_gian_hang)
// values({0},{1},{2},{3},{4});".Params(Index.ma_thong_so, Index.ma_thuoc_tinh, Index.gia_tri, Index.ma_san_pham, Index.ma_gian_hang));
// else
// sqlListProperty.Add(@"update Merchant_Product_Image
// set ma_thong_so = {0}, ma_thuoc_tinh = {1}, gia_tri = {2}
// where ma_san_pham = {3} and ma_gian_hang = {4};".Params(Index.ma_thong_so, Index.ma_thuoc_tinh, Index.gia_tri, Index.ma_san_pham, Index.ma_gian_hang));
// rs.Close();
// }
// }*/
// using (MySql.Data.MySqlClient.MySqlTransaction trans = con.BeginTransaction())
// {
// try
// {
// using (MySqlCommand cmd = new MySqlCommand(Utility.ConvertUTF(sqlProduct), con, trans))
// {
// cmd.ExecuteNonQuery();
// cmd.CommandText = sqlHierarchy;
// cmd.ExecuteNonQuery();
// if (sqlListImage.Count > 0)
// {
// foreach (string sqlString in sqlListImage)
// {
// cmd.CommandText = sqlString;
// cmd.ExecuteNonQuery();
// }
// cmd.CommandText = "delete from Merchant_Product_Image where ma_san_pham = {0} and ma_gian_hang = {1}".Params(ProductID, MerchantID) +
// "and ma_anh_goc not in (" + whereImage.Substring(0, whereImage.Length - 1) + ")";
// cmd.ExecuteNonQuery();
// }
// }
// //using (MySqlCommand cmd = new MySqlCommand("", con, trans))
// //{
// // if (sqlListProperty.Count > 0)
// // foreach (string sqlString in sqlListProperty)
// // {
// // cmd.CommandText = sqlString;
// // cmd.ExecuteNonQuery();
// // }
// //}
// trans.Commit();
// }
// catch (Exception e)
// {
// trans.Rollback();
// return e.Message.ToString();
// }
// }
// }
// return "true";
//}
private Merchant_Product EmptyIfNull(Merchant_Product p1)
{
p1.ma_san_pham = (p1.ma_san_pham == null) ? "" : p1.ma_san_pham;
p1.ma_loai_san_pham = (p1.ma_loai_san_pham == null) ? "" : p1.ma_loai_san_pham;
p1.ten_san_pham = (p1.ten_san_pham == null) ? "" : p1.ten_san_pham;
p1.ma_gian_hang = (p1.ma_gian_hang == null) ? "" : p1.ma_gian_hang;
p1.mo_ta = (p1.mo_ta == null) ? "" : p1.mo_ta;
p1.nguoi_duyet = (p1.nguoi_duyet == null) ? "" : p1.nguoi_duyet;
p1.nguoi_duyet = (p1.nguoi_duyet == null) ? "" : p1.nguoi_duyet;
p1.trang_thai_duyet = (p1.trang_thai_duyet == null) ? "" : p1.trang_thai_duyet;
p1.trang_thai = (p1.trang_thai == null) ? "" : p1.trang_thai;
return(p1);
}
public ActionResult GetProductInfo(string ma_san_pham)
{
using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn())
{
var data = new Merchant_Product();
if (isAdmin)
{
data = dbConn.FirstOrDefault <Merchant_Product>("ma_san_pham = {0}", ma_san_pham);
}
else
{
data = dbConn.FirstOrDefault <Merchant_Product>("ma_gian_hang ={0} and ma_san_pham = {1}", currentUser.ma_gian_hang, ma_san_pham);
}
if (data != null)
{
return(Json(new { success = true, data = data, JsonRequestBehavior.AllowGet }));
}
return(Json(new { success = false, error = "Sản phẩm không tồn tại!", JsonRequestBehavior.AllowGet }));
}
}
public ActionResult CreateUpdate(Merchant_OrderHeader data, List <Merchant_OrderDetail> details)
{
using (var dbConn = MCC.Helpers.OrmliteConnection.openConn())
{
try
{
if (accessDetail != null && (accessDetail.access["all"] || (accessDetail.access["create"] && accessDetail.access["update"])))
{
if (details == null)
{
return(Json(new { success = false, error = "Vui lòng chọn sản phẩm!" }));
}
Customer custom = dbConn.FirstOrDefault <Customer>("ma_khach_hang={0}".Params(data.ma_khach_hang));
if (data.id > 0 || !String.IsNullOrEmpty(data.ma_don_hang))
{
Merchant_OrderHeader exist = dbConn.FirstOrDefault <Merchant_OrderHeader>("ma_don_hang={0}".Params(data.ma_don_hang));
if (exist != null)
{
if (exist.trang_thai_don_hang != AllConstant.trang_thai_don_hang.NEW)
{
return(Json(new { success = false, error = "Đơn hàng này đã được xác nhận, không được phép chình sửa!" }));
}
exist.hinh_thuc_thanh_toan = data.hinh_thuc_thanh_toan;
exist.ngay_cap_nhat = DateTime.Now;
exist.nguoi_cap_nhat = currentUser.name;
exist.quan_huyen_giao = data.quan_huyen_giao;
exist.tinh_thanh_giao = data.tinh_thanh_giao;
exist.so_dien_thoai_giao = data.so_dien_thoai_giao;
exist.dia_chi_giao_hang = data.dia_chi_giao_hang;
dbConn.UpdateOnly(exist,
onlyFields: p =>
new
{
p.hinh_thuc_thanh_toan,
p.ngay_cap_nhat,
p.nguoi_cap_nhat,
p.quan_huyen_giao,
p.tinh_thanh_giao,
p.so_dien_thoai_giao,
p.dia_chi_giao_hang,
},
where : p => p.ma_don_hang == exist.ma_don_hang);
}
data = exist;
}
else
{
//Tạo OrderHeader
var chars = "ABCDEFGHIJKLMNOPQRSTUVWXYZ";
var beginString = new char[3];
var lastString = new char[3];
var random = new Random();
for (int i = 0; i < beginString.Length; i++)
{
beginString[i] = chars[random.Next(chars.Length)];
}
for (int i = 0; i < lastString.Length; i++)
{
lastString[i] = chars[random.Next(chars.Length)];
}
data.ma_don_hang = string.Join("", beginString) + DateTime.Now.ToString("yyyyMMddHHmm") + string.Join("", lastString);
data.quan_huyen_giao = data.quan_huyen_giao;
data.tinh_thanh_giao = data.tinh_thanh_giao;
data.ma_gian_hang = currentUser.ma_gian_hang;
data.hoten = custom.hoten;
data.trang_thai_don_hang = AllConstant.trang_thai_don_hang.NEW;
data.ngay_tao = DateTime.Now;
data.ngay_cap_nhat = DateTime.Now;
data.ngay_lay_hang = DateTime.Now;
data.ngay_giao_hang = DateTime.Now;
data.ngay_xac_nhan = DateTime.Now;
data.ngay_hen_giao_hang = DateTime.Now;
data.nguoi_tao = User.Identity.Name;
dbConn.Insert(data);
int Id = (int)dbConn.GetLastInsertId();
data.id = Id;
}
//Xóa tất các các OrderDetail đã có của đơn hàng này
dbConn.Delete <Merchant_OrderDetail>("ma_don_hang={0}".Params(data.ma_don_hang));
//Tạo OrderDetail mới
Merchant_Product productinfo = new Merchant_Product();
Merchant_OrderDetail existdetail = new Merchant_OrderDetail();
foreach (Merchant_OrderDetail item in details)
{
if (item.ma_san_pham != null)
{
productinfo = dbConn.FirstOrDefault <Merchant_Product>("ma_san_pham={0} and ma_gian_hang={1}", item.ma_san_pham, data.ma_gian_hang);
existdetail = dbConn.FirstOrDefault <Merchant_OrderDetail>("ma_don_hang={0} and ma_san_pham={1}".Params(data.ma_don_hang, item.ma_san_pham));
if (existdetail != null)
{
existdetail.so_luong = existdetail.so_luong + item.so_luong;
dbConn.UpdateOnly(existdetail,
onlyFields: p =>
new
{
p.so_luong,
},
where : p => p.ma_don_hang == existdetail.ma_don_hang && p.ma_san_pham == existdetail.ma_san_pham);
}
else
{
item.ma_don_hang = data.ma_don_hang;
item.ma_gian_hang = data.ma_gian_hang;
item.ten_san_pham = productinfo.ten_san_pham;
item.don_gia = productinfo.don_gia;
item.thanh_tien = item.so_luong * productinfo.don_gia;
item.ngay_tao = DateTime.Now;
item.ngay_cap_nhat = DateTime.Now;
item.nguoi_tao = User.Identity.Name;
dbConn.Insert(item);
}
}
}
return(Json(new { success = true, data = data }));
}
else
{
return(Json(new { success = false, error = "Không có quyền tạo" }));
}
}
catch (Exception e)
{
return(Json(new { success = false, error = "Lỗi" }));
}
}
}
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");
}
}
}
public string CreateProduct(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))
{
//using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
if (!string.IsNullOrEmpty(product.ma_san_pham))
{
var Checkproduct = db.FirstOrDefault <Merchant_Product>(s => s.ma_san_pham == product.ma_san_pham);
if (Checkproduct != null)
{
return(UpdateProduct(product, hierarchy, listimage, listproperty, connectstring));
}
}
if (product.id == 0 && !String.IsNullOrEmpty(product.nguoi_tao) && !String.IsNullOrEmpty(product.ma_gian_hang))
{
var lastId = db.FirstOrDefault <Merchant_Product>("SELECT TOP 1 * FROM Merchant_Product ORDER BY ma_san_pham DESC");
if (lastId != null && lastId.ma_san_pham.Contains("SP"))
{
var nextNo = Int32.Parse(lastId.ma_san_pham.Substring(2, 7)) + 1;
product.ma_san_pham = "SP" + String.Format("{0:0000000}", nextNo);
}
else
{
product.ma_san_pham = "SP" + "0000001";
}
product.ma_loai_san_pham = !string.IsNullOrEmpty(product.ma_loai_san_pham) ? product.ma_loai_san_pham : "";
product.part_no = !string.IsNullOrEmpty(product.part_no) ? product.part_no : "";
product.mo_ta = !string.IsNullOrEmpty(product.mo_ta) ? product.mo_ta : "";
product.noi_dung = !string.IsNullOrEmpty(product.noi_dung) ? product.noi_dung : "";
product.tu_khoa = !string.IsNullOrEmpty(product.tu_khoa) ? product.tu_khoa : "";
product.tag = !string.IsNullOrEmpty(product.tag) ? product.tag : "";
product.slug = !string.IsNullOrEmpty(product.slug) ? product.slug : "";
product.xuat_xu = !string.IsNullOrEmpty(product.xuat_xu) ? product.xuat_xu : "";
product.model = !string.IsNullOrEmpty(product.model) ? product.model : "";
product.trang_thai = AllConstant.trang_thai.DANG_SU_DUNG; //giá trị đang hoạt động
product.trang_thai_duyet = AllConstant.trang_thai_duyet.CHUA_DUYET; //giá trị chờ duyệt
product.trang_thai_xuat_ban = AllConstant.trang_thai_xuat_ban.CHUA_XUAT_BAN; //giá trị chờ xuất bản
product.nguoi_xuat_ban = product.nguoi_duyet = "";
product.ngay_xuat_ban = product.ngay_duyet = product.ngay_cap_nhat = DateTime.Parse("1900-01-01");
product.ngay_tao = DateTime.Now;
db.Insert(product);
Int64 productId = (Int64)db.GetLastInsertId();
//List<SqlParameter> param = new List<SqlParameter>();
//param.Add(new SqlParameter("@id", productId));
//new SqlHelper().ExecuteNoneQuery("p_UpdateSlugForMerchantProduct", param);
if (hierarchy.id == 0)
{
hierarchy.ma_san_pham = product.ma_san_pham;
hierarchy.ma_gian_hang = product.ma_gian_hang;
hierarchy.ngay_tao = DateTime.Now;
hierarchy.nguoi_tao = product.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);
if (listimage != null)
{
foreach (Merchant_Product_Image item in listimage)
{
if (item.id == 0)
{
item.ma_san_pham = product.ma_san_pham;
item.ma_gian_hang = product.ma_gian_hang;
item.ngay_tao = DateTime.Now;
item.nguoi_tao = product.nguoi_tao;
db.Insert(item);
}
else
{
//dbTrans.Rollback();
return("Lỗi khi tạo thumbnail hình ảnh");
}
}
}
if (listproperty != null)
{
foreach (Merchant_Product_Property item in listproperty)
{
if (item.id == 0)
{
item.ma_gian_hang = product.ma_gian_hang;
item.ma_san_pham = product.ma_san_pham;
item.ngay_tao = DateTime.Now;
item.nguoi_tao = product.nguoi_tao;
item.ngay_cap_nhat = DateTime.Parse("1900-01-01");
db.Insert(item);
}
else
{
//dbTrans.Rollback();
return("Lỗi khi tạo thuộc tính");
}
}
}
//dbTrans.Commit();
new Merchant_Product_Warehouse_DAO().CreateUpdate(product.ma_san_pham, product.ma_gian_hang, product.nguoi_tao, connectstring);
return("true@@" + product.ma_san_pham);
}
else
{
// dbTrans.Rollback();
return("Lỗi khi tạo ngành hàng");
}
}
else
{
// dbTrans.Rollback();
return("Lỗi khi tạo sản phẩm");
}
}
catch (Exception ex)
{
//dbTrans.Rollback();
return("Lỗi thao tác dữ liệu");
}
}
}
}
