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