public int 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) { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@id", id)); new SqlHelper().ExecuteNoneQuery("delete Product_Evaluation where id = @id", param, CommandType.Text); } dbTrans.Commit(); return(1); } catch { dbTrans.Rollback(); return(0); } } } }
public string Create(List <Merchant_Product_Image> list, string UserName, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { if (list == null) { dbTrans.Rollback(); return("No Data"); } db.Delete <Merchant_Product_Image>("ma_san_pham = {0} and ma_gian_hang = {1}", list.ElementAt(0).ma_san_pham, list.ElementAt(0).ma_gian_hang); foreach (Merchant_Product_Image item in list) { item.ngay_tao = DateTime.Now; item.nguoi_tao = UserName; } 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 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 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_Voucher>("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 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) { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@id", id)); new SqlHelper().ExecuteNoneQuery("delete Merchant_Voucher where id = @id", param, CommandType.Text); } dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }
public void UpSert(List <Product_Evaluation> lstProductEvaluation, string UserName, string Type, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (Product_Evaluation row in lstProductEvaluation) { if (Type == "Insert") { row.ngay_tao = row.ngay_cap_nhat = DateTime.Now; row.nguoi_tao = row.nguoi_cap_nhat = UserName; db.Save(row); } else { row.ngay_cap_nhat = DateTime.Now; row.nguoi_cap_nhat = UserName; db.Update(row); } } dbTrans.Commit(); } catch { dbTrans.Rollback(); } } } }
public string UpSert(List <Product_Hierarchy_Property> lstProductHierarchyProperty, string UserName, string Type, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (Product_Hierarchy_Property row in lstProductHierarchyProperty) { if (Type == "Insert") { 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 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 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 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 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 static int SaveBill(int UserId) { var fe_bill = GetBillSection(); var bill = Mapper.Map <Bill>(fe_bill); var billdetail = Mapper.Map <List <BillDetail> >(fe_bill.BillDetails); var dbConn = new OrmliteConnection().openConn(); using (var trans = dbConn.OpenTransaction()) { try { //add delivery var delivery = Delivery.GetByUserId(fe_bill.UserId, dbConn, true); if (delivery == null || UserId == 0) { delivery = new Delivery(); } delivery.entrycode = ""; delivery.entryname = ""; delivery.userid = fe_bill.UserId; delivery.fullname = fe_bill.FullName; delivery.address = fe_bill.Address; delivery.phone = fe_bill.Phone; delivery.email = fe_bill.Email; delivery.comments = fe_bill.Comments; delivery.AddOrUpdate(fe_bill.UserId, dbConn, true); //add bill bill.deliveryid = delivery.entryid; bill.entrycode = ""; bill.entryname = ""; var billid = bill.AddOrUpdate(UserId, dbConn, true); billdetail.ForEach(x => x.billid = billid); foreach (var item in billdetail) { item.entrycode = ""; item.entryname = ""; item.AddOrUpdate(UserId, dbConn, true); } trans.Commit(); UpdateBillItem(new List <FE_BillDetail>()); return(billid); } catch (Exception ex) { trans.Rollback(); return(0); } } }
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 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 DeleteForCode(string ma_gian_hang, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { db.Delete <Merchant_Image>(s => s.ma_gian_hang == ma_gian_hang); dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); 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 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 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) { db.DeleteById <Property>(id); } dbTrans.Commit(); return("true"); } catch { dbTrans.Rollback(); return("false"); } } } }
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) { db.Delete <Merchant_Image>(s => s.id == int.Parse(id)); } dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }
public string Delete(string ma_san_pham, string ma_san_pham_de_nghi, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { List <SqlParameter> param = new List <SqlParameter>(); param.Add(new SqlParameter("@ma_san_pham", ma_san_pham)); param.Add(new SqlParameter("@ma_san_pham_de_nghi", ma_san_pham_de_nghi)); new SqlHelper().ExecuteNoneQuery("delete Merchant_Product_Related where ma_san_pham=@ma_san_pham and ma_san_pham_de_nghi=@ma_san_pham_de_nghi", param, CommandType.Text); dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); return(e.Message.ToString()); } } } }
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()); } } } }
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 Insert(string ma_gian_hang, string ma_thong_tin_anh, string UserName, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { List <SqlParameter> lstParameter = new List <SqlParameter>(); lstParameter.Add(new SqlParameter("@ma_gian_hang", ma_gian_hang)); lstParameter.Add(new SqlParameter("@ma_thong_tin_anh", ma_thong_tin_anh)); lstParameter.Add(new SqlParameter("@UserName", UserName)); new SqlHelper().ExecuteQuery("p_Insert_Merchant_Image", lstParameter); dbTrans.Commit(); return("true"); } catch (Exception e) { dbTrans.Rollback(); 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 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 ActionResult ImportData() { try { if (Request.Files["FileUpload"] != null && Request.Files["FileUpload"].ContentLength > 0) { string fileExtension = System.IO.Path.GetExtension(Request.Files["FileUpload"].FileName); if (fileExtension == ".xlsx" || fileExtension == ".xls") { IDbConnection dbConn = new OrmliteConnection().openConn(); using (var dbTrans = dbConn.OpenTransaction(IsolationLevel.ReadCommitted)) { string datetime = DateTime.Now.ToString("yyyyMMddHHmmss"); string fileLocation = string.Format("{0}/{1}", Server.MapPath("~/ExcelImport"), "[" + currentUser.UserID + "-" + datetime + Request.Files["FileUpload"].FileName); string errorFileLocation = string.Format("{0}/{1}", Server.MapPath("~/ExcelImport"), "[" + currentUser.UserID + "-" + datetime + "-Error]" + Request.Files["FileUpload"].FileName); string linkerror = "[" + currentUser.UserID + "-" + datetime + "-Error]" + Request.Files["FileUpload"].FileName; if (System.IO.File.Exists(fileLocation)) { System.IO.File.Delete(fileLocation); } Request.Files["FileUpload"].SaveAs(fileLocation); var rownumber = 2; var total = 0; FileInfo fileInfo = new FileInfo(fileLocation); var excelPkg = new ExcelPackage(fileInfo); //FileInfo template = new FileInfo(Server.MapPath(errorFileLocation)); //template.CopyTo(errorFileLocation); //FileInfo _fileInfo = new FileInfo(errorFileLocation); //var _excelPkg = new ExcelPackage(_fileInfo); ExcelWorksheet oSheet = excelPkg.Workbook.Worksheets["Data"]; //ExcelWorksheet eSheet = _excelPkg.Workbook.Worksheets["Data"]; ExcelPackage pck = new ExcelPackage(new FileInfo(errorFileLocation)); ExcelWorksheet ws = pck.Workbook.Worksheets["Data"]; int totalRows = oSheet.Dimension.End.Row; for (int i = 2; i <= totalRows; i++) { string ID = oSheet.Cells[i, 1].Value != null ? oSheet.Cells[i, 1].Value.ToString() : ""; string Name = oSheet.Cells[i, 2].Value != null ? oSheet.Cells[i, 2].Value.ToString() : ""; string Size = oSheet.Cells[i, 3].Value != null ? oSheet.Cells[i, 3].Value.ToString() : ""; string Priece = oSheet.Cells[i, 4].Value != null ? oSheet.Cells[i, 4].Value.ToString() : "0"; string Type = oSheet.Cells[i, 5].Value != null ? oSheet.Cells[i, 5].Value.ToString() : ""; string Unit = oSheet.Cells[i, 6].Value != null ? oSheet.Cells[i, 6].Value.ToString() : ""; string[] UnitID = Unit.Split('/'); string WH = oSheet.Cells[i, 7].Value != null ? oSheet.Cells[i, 7].Value.ToString() : ""; string[] WHID = WH.Split('/'); string WHL = oSheet.Cells[i, 8].Value != null ? oSheet.Cells[i, 8].Value.ToString() : ""; string[] WHLID = WHL.Split('/'); string Templete = oSheet.Cells[i, 9].Value != null ? oSheet.Cells[i, 9].Value.ToString() : ""; //string Status = oSheet.Cells[i, 9].Value != null ? oSheet.Cells[i, 9].Value.ToString() : "Ngưng hoạt động"; string Status = "false"; if (oSheet.Cells[i, 10].Value != null) { if (oSheet.Cells[i, 10].Value.ToString() == "Đang hoạt động") { Status = "true"; } } try { if (string.IsNullOrEmpty(Name) || string.IsNullOrEmpty(Size) || string.IsNullOrEmpty(Priece)) { ws.Cells["A" + 2].Value = Name; ws.Cells[rownumber, 14].Value = "Vui lòng nhập (*)."; rownumber++; } else { var checkexists = dbConn.SingleOrDefault <Products>("SELECT * FROM Products WHERE Code = '" + ID + "'"); if (checkexists != null) { checkexists.Code = ID; checkexists.Name = Name; checkexists.Size = Name; checkexists.Price = int.Parse(Priece) / 1.1; checkexists.VATPrice = int.Parse(Priece); checkexists.Type = Type; checkexists.Unit = Unit != null ? UnitID[UnitID.Count() - 1] : ""; checkexists.WHID = WH != null ? WHID[WHID.Count() - 1] : ""; checkexists.WHLID = WHL != null ? WHLID[WHLID.Count() - 1] : ""; checkexists.ShapeTemplate = Templete; checkexists.Status = Boolean.Parse(Status); checkexists.UpdatedAt = DateTime.Now; checkexists.UpdatedBy = currentUser.UserID; dbConn.Update <Products>(checkexists); } else { string id = ""; var checkID = dbConn.SingleOrDefault <Products>("SELECT Code, Id FROM dbo.Products ORDER BY Id DESC"); if (checkID != null) { var nextNo = int.Parse(checkID.Code.Substring(2, checkID.Code.Length - 2)) + 1; id = "PR" + String.Format("{0:00000000}", nextNo); } else { id = "PR00000001"; } var item = new Products(); item.Code = ID; item.Name = Name; item.Size = Name; item.Price = int.Parse(Priece) / 1.1; item.VATPrice = int.Parse(Priece); item.Type = Type; item.Unit = Unit != null ? UnitID[UnitID.Count() - 1] : ""; item.WHID = WH != null ? WHID[WHID.Count() - 1] : ""; item.WHLID = WHL != null ? WHLID[WHLID.Count() - 1] : ""; item.ShapeTemplate = Templete; item.Status = Boolean.Parse(Status); item.CreatedAt = DateTime.Now; item.CreatedBy = currentUser.UserID; item.UpdatedAt = DateTime.Parse("1900-01-01"); item.UpdatedBy = ""; item.Status = Boolean.Parse(Status); dbConn.Insert <Products>(item); } total++; } } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } } return(Json(new { success = true, total = total, totalError = rownumber - 2, link = linkerror })); } } else { return(Json(new { success = false, message = "Không phải là file Excel. *.xlsx" })); } } else { return(Json(new { success = false, message = "Không có file hoặc file không phải là Excel" })); } } catch (Exception ex) { return(Json(new { success = false, message = ex.Message })); } }
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); }
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()); } } } }