private static int CreateUpdateDeleteRank( Rank rank, DataProviderAction action )
{
CSCache.Remove("RanksKey");
CommonDataProvider dp = CommonDataProvider.Instance();
return dp.CreateUpdateDeleteRank( rank, action );
}
public WorkflowQueueSender ReceiveResponseFromDataProvider(string connectionTpe,
string connection, DataProviderAction action, DataProviderResponseState state, object payload, decimal cost,
decimal rsp)
{
_workflow.DataProviderResponse(
new DataProviderIdentifier((int)_dataProvider, _dataProvider.ToString(), cost, rsp, action, state, _billNoRecords),
new ConnectionTypeIdentifier(connection, connectionTpe), payload, _stopWatch);
return this;
}
public DataProviderIdentifier(DataProviderCommandSource dataProvider,
DataProviderAction action, DataProviderResponseState state, DataProviderNoRecordState billNoRecords)
{
Id = (int) dataProvider;
Name = dataProvider.ToString();
Action = action;
State = state;
BillNoRecords = billNoRecords;
}
public DataProviderIdentifier(int id, string name, decimal costPrice, decimal recommendedPrice,
DataProviderAction action, DataProviderResponseState state, DataProviderNoRecordState billNoRecords)
{
Id = id;
Name = name;
CostPrice = costPrice;
RecommendedPrice = recommendedPrice;
Action = action;
State = state;
BillNoRecords = billNoRecords;
}
public bool AttributeValueManage(Maticsoft.Model.Shop.Products.AttributeValue model, DataProviderAction Action)
{
int rowsAffected = 0;
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Action", SqlDbType.Int), new SqlParameter("@ValueId", SqlDbType.BigInt), new SqlParameter("@AttributeId", SqlDbType.BigInt), new SqlParameter("@ValueStr", SqlDbType.NVarChar), new SqlParameter("@ImageUrl", SqlDbType.NVarChar) };
parameters[0].Value = (int) Action;
parameters[1].Value = model.ValueId;
parameters[2].Value = model.AttributeId;
parameters[3].Value = model.ValueStr;
parameters[4].Value = model.ImageUrl;
DbHelperSQL.RunProcedure("sp_Shop_AttributesValuesCreateEditDelete", parameters, out rowsAffected);
return (rowsAffected > 0);
}
public static void SaveSysDept(SysDept item, DataProviderAction action)
{
if (item == null)
{
return;
}
SqlConnection conn = DBUtils.GetConnection();
SqlCommand cmd = DBUtils.GetCommand();
try
{
cmd.Transaction = conn.BeginTransaction();
ArrayList paras = new ArrayList();
paras.Add(DBUtils.MakeInParam("@Dept_ID", SqlDbType.NVarChar, 8, item.DeptID));
paras.Add(DBUtils.MakeInParam("@Dept_Name", SqlDbType.NVarChar, 30, item.DeptName));
paras.Add(DBUtils.MakeInParam("@Dept_Short", SqlDbType.NVarChar, 4, item.DeptShort));
paras.Add(DBUtils.MakeInParam("@Co_ID", SqlDbType.NVarChar, 4, item.CoID));
paras.Add(DBUtils.MakeInParam("@Dept_PID", SqlDbType.NVarChar, 8, item.DeptPID));
paras.Add(DBUtils.MakeInParam("@Crt_Date", SqlDbType.DateTime, item.CrtDate));
paras.Add(DBUtils.MakeInParam("@Dept_Address", SqlDbType.NVarChar, 100, item.DeptAddress));
paras.Add(DBUtils.MakeInParam("@Dept_Post", SqlDbType.NVarChar, 10, item.DeptPost));
paras.Add(DBUtils.MakeInParam("@Dept_Tele", SqlDbType.NVarChar, 30, item.DeptTele));
paras.Add(DBUtils.MakeInParam("@Dept_Fax", SqlDbType.NVarChar, 30, item.DeptFax));
paras.Add(DBUtils.MakeInParam("@Dept_EMail", SqlDbType.NVarChar, 32, item.DeptEMail));
paras.Add(DBUtils.MakeInParam("@Dept_Man", SqlDbType.NVarChar, 6, item.DeptMan));
paras.Add(DBUtils.MakeInParam("@Dept_Level", SqlDbType.SmallInt, item.DeptLevel));
paras.Add(DBUtils.MakeInParam("@Dept_Type", SqlDbType.SmallInt, item.DeptType));
paras.Add(DBUtils.MakeInParam("@Dept_Depth", SqlDbType.SmallInt, item.DeptDepth));
paras.Add(DBUtils.MakeInParam("@Sort_Order", SqlDbType.SmallInt, item.SortOrder));
paras.Add(DBUtils.MakeInParam("@Dept_Status", SqlDbType.SmallInt, item.DeptStatus));
paras.Add(DBUtils.MakeInParam("@Auth_Dept", SqlDbType.NVarChar, 8, item.AuthDept));
paras.Add(DBUtils.MakeInParam("@Remark", SqlDbType.NVarChar, 20, item.Remark));
paras.Add(DBUtils.MakeInParam("@Action", SqlDbType.Int, action));
DBUtils.ExecuteNonQuery(conn, cmd, CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Save_SysDept", paras);
cmd.Transaction.Commit();
}
catch
{
cmd.Transaction.Rollback();
throw;
}
finally
{
DBUtils.SetDispose(conn, cmd);
}
}
public static void SaveSysRegister(SysRegister item, DataProviderAction action)
{
if (item == null)
{
return;
}
SqlConnection conn = DBUtils.GetConnection();
SqlCommand cmd = DBUtils.GetCommand();
try
{
cmd.Transaction = conn.BeginTransaction();
ArrayList paras = new ArrayList();
if (action == DataProviderAction.Create)
{
paras.Add(DBUtils.MakeOutParam("@Reg_ID", SqlDbType.SmallInt));
}
else
{
paras.Add(DBUtils.MakeInParam("@Reg_ID", SqlDbType.SmallInt, item.RegID));
}
paras.Add(DBUtils.MakeInParam("@Cpu_Code", SqlDbType.NVarChar, 40, item.CpuCode));
paras.Add(DBUtils.MakeInParam("@Reg_Number", SqlDbType.NVarChar, 40, item.RegNumber));
paras.Add(DBUtils.MakeInParam("@Reg_Code", SqlDbType.NVarChar, 40, item.RegCode));
paras.Add(DBUtils.MakeInParam("@Dept_ID", SqlDbType.NVarChar, 8, item.DeptID));
paras.Add(DBUtils.MakeInParam("@Crt_Date", SqlDbType.DateTime, item.CrtDate));
paras.Add(DBUtils.MakeInParam("@Action", SqlDbType.Int, action));
DBUtils.ExecuteNonQuery(conn, cmd, CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Save_SysRegister", paras);
if (action == DataProviderAction.Create)
{
item.RegID = ((((SqlParameter)paras[0]).Value != null) ? (Convert.ToInt16(((SqlParameter)paras[0]).Value)) : (short)0);
}
cmd.Transaction.Commit();
}
catch
{
cmd.Transaction.Rollback();
throw;
}
finally
{
DBUtils.SetDispose(conn, cmd);
}
}
public static void CreateUpdateDeleteSetSqlDetail(SetSqlDetail item, DataProviderAction action)
{
if (item == null)
{
return;
}
SqlConnection conn = DBUtils.GetConnection();
SqlCommand cmd = DBUtils.GetCommand();
try
{
cmd.Transaction = conn.BeginTransaction();
ArrayList paras = new ArrayList();
paras.Add(DBUtils.MakeInParam("@Sql_ID", SqlDbType.NVarChar, 30, item.SqlID));
paras.Add(DBUtils.MakeInParam("@Col_ID", SqlDbType.SmallInt, item.ColID));
paras.Add(DBUtils.MakeInParam("@Col_Name", SqlDbType.NVarChar, 20, item.ColName));
paras.Add(DBUtils.MakeInParam("@Col_Code", SqlDbType.NVarChar, 20, item.ColCode));
paras.Add(DBUtils.MakeInParam("@Col_Base_Code", SqlDbType.NVarChar, 20, item.ColBaseCode));
paras.Add(DBUtils.MakeInParam("@Col_Type", SqlDbType.SmallInt, item.ColType));
paras.Add(DBUtils.MakeInParam("@Disp_Size", SqlDbType.SmallInt, item.DispSize));
paras.Add(DBUtils.MakeInParam("@Disp_Order", SqlDbType.SmallInt, item.DispOrder));
paras.Add(DBUtils.MakeInParam("@Disp_Auth", SqlDbType.SmallInt, item.DispAuth));
paras.Add(DBUtils.MakeInParam("@Is_Visible", SqlDbType.Bit, item.IsVisible));
paras.Add(DBUtils.MakeInParam("@Is_Print", SqlDbType.Bit, item.IsPrint));
paras.Add(DBUtils.MakeInParam("@Is_Order", SqlDbType.Bit, item.IsOrder));
paras.Add(DBUtils.MakeInParam("@Is_Lock", SqlDbType.Bit, item.IsLock));
paras.Add(DBUtils.MakeInParam("@Is_Alias", SqlDbType.Bit, item.IsAlias));
paras.Add(DBUtils.MakeInParam("@Col_Foot", SqlDbType.SmallInt, item.ColFoot));
paras.Add(DBUtils.MakeInParam("@Col_Foot_Value", SqlDbType.NVarChar, 30, item.ColFootValue));
paras.Add(DBUtils.MakeInParam("@Rela_Sql", SqlDbType.NVarChar, 20, item.RelaSql));
paras.Add(DBUtils.MakeInParam("@Col_Format", SqlDbType.NVarChar, 30, item.ColFormat));
paras.Add(DBUtils.MakeInParam("@Action", SqlDbType.Int, action));
DBUtils.ExecuteNonQuery(conn, cmd, CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_CreateUpdateDelete_SetSqlDetail", paras);
cmd.Transaction.Commit();
}
catch
{
cmd.Transaction.Rollback();
throw;
}
finally
{
DBUtils.SetDispose(conn, cmd);
}
}
public static void CreateUpdateDeleteSysLog(SysLog item, DataProviderAction action)
{
if (item == null)
{
return;
}
SqlConnection conn = DBUtils.GetConnection();
SqlCommand cmd = DBUtils.GetCommand();
try
{
cmd.Transaction = conn.BeginTransaction();
ArrayList paras = new ArrayList();
if (action == DataProviderAction.Create)
{
paras.Add(DBUtils.MakeOutParam("@Log_ID", SqlDbType.Int));
}
else
{
paras.Add(DBUtils.MakeInParam("@Log_ID", SqlDbType.Int, item.LogID));
}
paras.Add(DBUtils.MakeInParam("@Log_Date", SqlDbType.DateTime, item.LogDate));
paras.Add(DBUtils.MakeInParam("@Man_ID", SqlDbType.NVarChar, 6, item.ManID));
paras.Add(DBUtils.MakeInParam("@Menu_Code", SqlDbType.NVarChar, 4, item.MenuCode));
paras.Add(DBUtils.MakeInParam("@Log_Action", SqlDbType.SmallInt, item.LogAction));
paras.Add(DBUtils.MakeInParam("@Log_Content", SqlDbType.NVarChar, 100, item.LogContent));
paras.Add(DBUtils.MakeInParam("@Action", SqlDbType.Int, action));
DBUtils.ExecuteNonQuery(conn, cmd, CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_CreateUpdateDelete_SysLog", paras);
if (action == DataProviderAction.Create)
{
item.LogID = ((((SqlParameter)paras[0]).Value != null) ? (Convert.ToInt32(((SqlParameter)paras[0]).Value)) : (int)0);
}
cmd.Transaction.Commit();
}
catch
{
cmd.Transaction.Rollback();
throw;
}
finally
{
DBUtils.SetDispose(conn, cmd);
}
}
public GiftActionStatus CreateUpdateDeleteGift(GiftInfo gift, DataProviderAction action)
{
if (null == gift)
{
return(GiftActionStatus.UnknowError);
}
DbCommand storedProcCommand = this.database.GetStoredProcCommand("cp_Gift_CreateUpdateDelete");
this.database.AddInParameter(storedProcCommand, "Action", DbType.Int32, (int)action);
this.database.AddOutParameter(storedProcCommand, "Status", DbType.Int32, 4);
if (DataProviderAction.Create != action)
{
this.database.AddInParameter(storedProcCommand, "GiftId", DbType.Int32, gift.GiftId);
}
else
{
this.database.AddOutParameter(storedProcCommand, "GiftId", DbType.Int32, 4);
}
if (DataProviderAction.Delete != action)
{
this.database.AddInParameter(storedProcCommand, "Name", DbType.String, gift.Name);
this.database.AddInParameter(storedProcCommand, "ShortDescription", DbType.String, gift.ShortDescription);
this.database.AddInParameter(storedProcCommand, "Stock", DbType.Int32, gift.Stock);
this.database.AddInParameter(storedProcCommand, "Unit", DbType.String, gift.Unit);
this.database.AddInParameter(storedProcCommand, "LongDescription", DbType.String, gift.LongDescription);
this.database.AddInParameter(storedProcCommand, "Title", DbType.String, gift.Title);
this.database.AddInParameter(storedProcCommand, "Meta_Description", DbType.String, gift.Meta_Description);
this.database.AddInParameter(storedProcCommand, "Meta_Keywords", DbType.String, gift.Meta_Keywords);
this.database.AddInParameter(storedProcCommand, "CostPrice", DbType.Currency, gift.CostPrice);
this.database.AddInParameter(storedProcCommand, "ImageUrl", DbType.String, gift.ImageUrl);
this.database.AddInParameter(storedProcCommand, "ThumbnailUrl40", DbType.String, gift.ThumbnailUrl40);
this.database.AddInParameter(storedProcCommand, "ThumbnailUrl60", DbType.String, gift.ThumbnailUrl60);
this.database.AddInParameter(storedProcCommand, "ThumbnailUrl100", DbType.String, gift.ThumbnailUrl100);
this.database.AddInParameter(storedProcCommand, "ThumbnailUrl160", DbType.String, gift.ThumbnailUrl160);
this.database.AddInParameter(storedProcCommand, "ThumbnailUrl180", DbType.String, gift.ThumbnailUrl180);
this.database.AddInParameter(storedProcCommand, "ThumbnailUrl220", DbType.String, gift.ThumbnailUrl220);
this.database.AddInParameter(storedProcCommand, "ThumbnailUrl310", DbType.String, gift.ThumbnailUrl310);
this.database.AddInParameter(storedProcCommand, "ThumbnailUrl410", DbType.String, gift.ThumbnailUrl410);
this.database.AddInParameter(storedProcCommand, "MarketPrice", DbType.Currency, gift.MarketPrice);
this.database.AddInParameter(storedProcCommand, "NeedPoint", DbType.Int32, gift.NeedPoint);
this.database.AddInParameter(storedProcCommand, "IsPromotion", DbType.Boolean, gift.IsPromotion);
}
else
{
this.database.AddInParameter(storedProcCommand, "IsPromotion", DbType.Boolean, false);
}
this.database.ExecuteNonQuery(storedProcCommand);
return((GiftActionStatus)((int)this.database.GetParameterValue(storedProcCommand, "Status")));
}
private static int InsertUpdateDelete(LoaiInfo loaiInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_Loai,
"@" + TableLoai.MaLoai,
loaiInfo.MaLoai, loaiInfo.TenLoai,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(BaoHanhInfo baoHanhInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_BaoHanh,
"@" + TableBaoHanh.SoPhieu,
baoHanhInfo.SoPhieu, baoHanhInfo.MaHH, baoHanhInfo.SoEmei, baoHanhInfo.MaKH, baoHanhInfo.NgayMua, baoHanhInfo.ThoiGianBaoHanh,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(RoleAccountInfo roleAccountInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_RoleAccount,
"",
roleAccountInfo.RoleID, roleAccountInfo.AccountID, roleAccountInfo.Active,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(ChiTietHoaDonInfo chiTietHoaDonInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_ChiTietHoaDon,
"",
chiTietHoaDonInfo.MaKH, chiTietHoaDonInfo.MaHH, chiTietHoaDonInfo.SoLuong, chiTietHoaDonInfo.GiaBan,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(PalletInfo palletInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_Pallet,
"",
palletInfo.ID, palletInfo.Pallet, palletInfo.Tray_Number, palletInfo.ReposityID, palletInfo.ContID, palletInfo.Empty_Pallet,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(InformationInfo informationInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_Information,
"@" + TableInformation.ID,
informationInfo.ID, informationInfo.NameInfor, informationInfo.DateCreated, informationInfo.CreatedBy, informationInfo.DateModified, informationInfo.ModifiedBy,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(RoleInfo roleInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_Role,
"@" + TableRole.ID,
roleInfo.ID, roleInfo.RoleName, roleInfo.Functions, roleInfo.InformationID, roleInfo.OrderID,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(SupplierInfo supplierInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_Supplier,
"@" + TableSupplier.ID,
supplierInfo.ID, supplierInfo.SupplierCode, supplierInfo.SupplierName, supplierInfo.Nation, supplierInfo.InformationID, supplierInfo.OrderID,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(TaiKhoanInfo taiKhoanInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_TaiKhoan,
"@" + TableTaiKhoan.TenTaiKhoan,
taiKhoanInfo.TenTaiKhoan, taiKhoanInfo.MatKhau, taiKhoanInfo.ChucNang, taiKhoanInfo.Quyen,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(AccountInfo accountInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_Account,
"@" + TableAccount.ID,
accountInfo.ID, accountInfo.AccountName, accountInfo.Password, accountInfo.FirstName, accountInfo.LastName, accountInfo.IdentifyID, accountInfo.Email, accountInfo.Phone, accountInfo.Mobile, accountInfo.InformationID, accountInfo.OrderID,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(HangHoaInfo hangHoaInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_HangHoa,
"@" + TableHangHoa.MaHH,
hangHoaInfo.MaHH, hangHoaInfo.TenHH, hangHoaInfo.SoLuong, hangHoaInfo.NhaCC, hangHoaInfo.MaLoai, hangHoaInfo.DonViTinh, hangHoaInfo.Hinh, hangHoaInfo.TinhNang,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(HoaDonInfo hoaDonInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_HoaDon,
"@" + TableHoaDon.SoHoaDon,
hoaDonInfo.SoHoaDon, hoaDonInfo.MaNV, hoaDonInfo.MaKH, hoaDonInfo.NgayLap, hoaDonInfo.TongTien,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(Sales_ReportInfo sales_ReportInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_Sales_Report,
"@" + TableSales_Report.ID,
sales_ReportInfo.ID, sales_ReportInfo.Year, sales_ReportInfo.Month, sales_ReportInfo.Export_Date, sales_ReportInfo.Date_Arrived, sales_ReportInfo.Check_Date, sales_ReportInfo.Export_Number, sales_ReportInfo.Bill_Number, sales_ReportInfo.CustomerID, sales_ReportInfo.ItemID, sales_ReportInfo.SupplierID, sales_ReportInfo.Certificate, sales_ReportInfo.Tuber_Number, sales_ReportInfo.Tray_Number, sales_ReportInfo.Price_VND, sales_ReportInfo.Status, sales_ReportInfo.Note, sales_ReportInfo.InformationID, sales_ReportInfo.OrderID,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(RepositoryInfo repositoryInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_Repository,
"@" + TableRepository.ID,
repositoryInfo.ID, repositoryInfo.Repo_Name, repositoryInfo.Location, repositoryInfo.PalletID, repositoryInfo.ItemID, repositoryInfo.ContID, repositoryInfo.CustomerID, repositoryInfo.InformationID, repositoryInfo.OrderID,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(TraHangInfo traHangInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_TraHang,
"@" + TableTraHang.MaPhieuTra,
traHangInfo.MaPhieuTra, traHangInfo.MaNV, traHangInfo.TongSoLuong, traHangInfo.NgayTra, traHangInfo.NhaCC, traHangInfo.DienThoaiNCC, traHangInfo.DiaChiNhaCC,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(BangGiaInfo bangGiaInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_BangGia,
"@" + TableBangGia.SoBangGia,
bangGiaInfo.SoBangGia, bangGiaInfo.MaHH, bangGiaInfo.GiaBan, bangGiaInfo.NgayApDung, bangGiaInfo.NgayKetThuc, bangGiaInfo.GiamGia,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(KhachHangInfo khachHangInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_KhachHang,
"@" + TableKhachHang.MaKH,
khachHangInfo.MaKH, khachHangInfo.TenKH, khachHangInfo.DiaChi, khachHangInfo.SDT, khachHangInfo.Mail,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(ItemInfo itemInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_Item,
"@" + TableItem.ID,
itemInfo.ID, itemInfo.ItemID, itemInfo.ItemName, itemInfo.Type, itemInfo.Size, itemInfo.ItemsPerPack, itemInfo.Crop, itemInfo.Note, itemInfo.Information, itemInfo.OrderID,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(NhanVienInfo nhanVienInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_NhanVien,
"@" + TableNhanVien.MaNV,
nhanVienInfo.MaNV, nhanVienInfo.TenNV, nhanVienInfo.GioiTinh, nhanVienInfo.NgaySinh, nhanVienInfo.SDT, nhanVienInfo.DiaChi, nhanVienInfo.Mail, nhanVienInfo.CMND, nhanVienInfo.Hinh, nhanVienInfo.TinhTrang, nhanVienInfo.TenTaiKhoan,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
public override int InsertUpdateDelete(DataProviderAction action, string spName, string outputName, params object[] parameterValues)
{
using (SqlConnection cnn = GetSqlConnection())
{
SqlCommand cmd = SqlHelper.CreateCommand(cnn, spName, parameterValues);
cnn.Open();
int rs = cmd.ExecuteNonQuery();
cnn.Close();
if (rs > 0 && action == DataProviderAction.Insert && !string.IsNullOrEmpty(outputName))
{
return((int)cmd.Parameters[outputName].Value);
}
return(rs);
}
}
private static int InsertUpdateDelete(ShipmentInfo shipmentInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_Shipment,
"@" + TableShipment.ID,
shipmentInfo.ID, shipmentInfo.Year, shipmentInfo.Month, shipmentInfo.ContID, shipmentInfo.ItemID, shipmentInfo.Purchase_Quantity_Bulbs, shipmentInfo.Price_EUR, shipmentInfo.Lot, shipmentInfo.Certificate, shipmentInfo.Quality_Control_Assessment, shipmentInfo.Note, shipmentInfo.InformationID, shipmentInfo.OrderID,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
private static int InsertUpdateDelete(CustomerInfo customerInfo, DataProviderAction action)
{
int rs = DataProvider.Instance().InsertUpdateDelete(
action,
StoredProcedureName.InsertUpdateDelete_Customer,
"@" + TableCustomer.ID,
customerInfo.ID, customerInfo.CustomerCode, customerInfo.CustomerName, customerInfo.Email, customerInfo.Phone, customerInfo.Mobile, customerInfo.InformationID, customerInfo.OrderID,
(int)action);
if (rs > 0 && Cache)
{
DataCache.RemoveCache(Key);
}
return(rs);
}
public static void CreateUpdateDeleteRibPanel(RibPanel item, DataProviderAction action)
{
if (item == null)
{
return;
}
SqlConnection conn = DBUtils.GetConnection();
SqlCommand cmd = DBUtils.GetCommand();
try
{
cmd.Transaction = conn.BeginTransaction();
ArrayList paras = new ArrayList();
if (action == DataProviderAction.Create)
{
paras.Add(DBUtils.MakeOutParam("@Rib_Panel", SqlDbType.SmallInt));
}
else
{
paras.Add(DBUtils.MakeInParam("@Rib_Panel", SqlDbType.SmallInt, item.ID));
}
paras.Add(DBUtils.MakeInParam("@Rib_Panel_Name", SqlDbType.NVarChar, 12, item.RibPanelName));
paras.Add(DBUtils.MakeInParam("@Rib_Order", SqlDbType.SmallInt, item.RibOrder));
paras.Add(DBUtils.MakeInParam("@Rib_Tab", SqlDbType.SmallInt, item.RibTab));
paras.Add(DBUtils.MakeInParam("@Action", SqlDbType.Int, action));
DBUtils.ExecuteNonQuery(conn, cmd, CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_CreateUpdateDelete_RibPanel", paras);
if (action == DataProviderAction.Create)
{
item.ID = ((((SqlParameter)paras[0]).Value != null) ? (Convert.ToInt16(((SqlParameter)paras[0]).Value)) : (short)0);
}
cmd.Transaction.Commit();
}
catch
{
cmd.Transaction.Rollback();
throw;
}
finally
{
DBUtils.SetDispose(conn, cmd);
}
}
public static void SaveSysCompany(SysCompany item, DataProviderAction action)
{
if (item == null)
{
return;
}
SqlConnection conn = DBUtils.GetConnection();
SqlCommand cmd = DBUtils.GetCommand();
try
{
cmd.Transaction = conn.BeginTransaction();
ArrayList paras = new ArrayList();
paras.Add(DBUtils.MakeInParam("@Co_ID", SqlDbType.NVarChar, 4, item.CoID));
paras.Add(DBUtils.MakeInParam("@Co_Name", SqlDbType.NVarChar, 40, item.CoName));
paras.Add(DBUtils.MakeInParam("@Crt_Date", SqlDbType.DateTime, item.CrtDate));
paras.Add(DBUtils.MakeInParam("@Co_Address", SqlDbType.NVarChar, 100, item.CoAddress));
paras.Add(DBUtils.MakeInParam("@Co_Post", SqlDbType.NVarChar, 10, item.CoPost));
paras.Add(DBUtils.MakeInParam("@Co_Tele", SqlDbType.NVarChar, 30, item.CoTele));
paras.Add(DBUtils.MakeInParam("@Co_Fax", SqlDbType.NVarChar, 30, item.CoFax));
paras.Add(DBUtils.MakeInParam("@Co_EMail", SqlDbType.NVarChar, 32, item.CoEMail));
paras.Add(DBUtils.MakeInParam("@Co_Man", SqlDbType.NVarChar, 6, item.CoMan));
paras.Add(DBUtils.MakeInParam("@Sort_Order", SqlDbType.SmallInt, item.SortOrder));
paras.Add(DBUtils.MakeInParam("@Co_Status", SqlDbType.SmallInt, item.CoStatus));
paras.Add(DBUtils.MakeInParam("@Remark", SqlDbType.NVarChar, 20, item.Remark));
paras.Add(DBUtils.MakeInParam("@Action", SqlDbType.Int, action));
DBUtils.ExecuteNonQuery(conn, cmd, CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Save_SysCompany", paras);
cmd.Transaction.Commit();
}
catch
{
cmd.Transaction.Rollback();
throw;
}
finally
{
DBUtils.SetDispose(conn, cmd);
}
}
public static void SaveBusProject(BusProject item, DataProviderAction action)
{
if (item == null)
{
return;
}
SqlConnection conn = DBUtils.GetConnection();
SqlCommand cmd = DBUtils.GetCommand();
try
{
cmd.Transaction = conn.BeginTransaction();
ArrayList paras = new ArrayList();
paras.Add(DBUtils.MakeInParam("@ProjectID", SqlDbType.VarChar, 20, item.ProjectID));
paras.Add(DBUtils.MakeInParam("@ProjectCode", SqlDbType.NVarChar, 20, item.ProjectCode));
paras.Add(DBUtils.MakeInParam("@ProjectName", SqlDbType.NVarChar, 50, item.ProjectName));
paras.Add(DBUtils.MakeInParam("@ProjectType", SqlDbType.VarChar, 2, item.ProjectType));
paras.Add(DBUtils.MakeInParam("@ProjectStatus", SqlDbType.VarChar, 2, item.ProjectStatus));
paras.Add(DBUtils.MakeInParam("@ProjectManager", SqlDbType.VarChar, 14, item.ProjectManager));
paras.Add(DBUtils.MakeInParam("@WorkDate", SqlDbType.Decimal, item.WorkDate));
paras.Add(DBUtils.MakeInParam("@WorkUnit", SqlDbType.VarChar, 2, item.WorkUnit));
paras.Add(DBUtils.MakeInParam("@ProjectDesc", SqlDbType.Text, item.ProjectDesc));
paras.Add(DBUtils.MakeInParam("@TranDate", SqlDbType.DateTime, item.TranDate));
paras.Add(DBUtils.MakeInParam("@TranUser", SqlDbType.VarChar, 14, item.TranUser));
paras.Add(DBUtils.MakeInParam("@Action", SqlDbType.Int, action));
DBUtils.ExecuteNonQuery(conn, cmd, CommandType.StoredProcedure, PublicConsts.DatabaseOwner + ".P_Save_BusProject", paras);
item.ProjectID = ((SqlParameter)paras[0]).Value != DBNull.Value ? ((SqlParameter)paras[0]).Value.ToString() : "";
cmd.Transaction.Commit();
}
catch (Exception)
{
cmd.Transaction.Rollback();
throw;
}
finally
{
DBUtils.SetDispose(conn, cmd);
}
}
public override bool CreateUpdateDeleteArticleCategory(ArticleCategoryInfo articleCategory, DataProviderAction action)
{
if (null == articleCategory)
{
return false;
}
DbCommand storedProcCommand = database.GetStoredProcCommand("cp_ArticleCategory_CreateUpdateDelete");
database.AddInParameter(storedProcCommand, "Action", DbType.Int32, (int)action);
database.AddOutParameter(storedProcCommand, "Status", DbType.Int32, 4);
if (action != DataProviderAction.Create)
{
database.AddInParameter(storedProcCommand, "CategoryId", DbType.Int32, articleCategory.CategoryId);
}
if (action != DataProviderAction.Delete)
{
database.AddInParameter(storedProcCommand, "Name", DbType.String, articleCategory.Name);
database.AddInParameter(storedProcCommand, "IconUrl", DbType.String, articleCategory.IconUrl);
database.AddInParameter(storedProcCommand, "Description", DbType.String, articleCategory.Description);
}
database.ExecuteNonQuery(storedProcCommand);
return (((int)database.GetParameterValue(storedProcCommand, "Status")) == 0);
}
public override bool CreateUpdateDeleteFriendlyLink(FriendlyLinksInfo friendlyLink, DataProviderAction action)
{
if (null == friendlyLink)
{
return false;
}
DbCommand storedProcCommand = database.GetStoredProcCommand("cp_FriendlyLink_CreateUpdateDelete");
database.AddInParameter(storedProcCommand, "Action", DbType.Int32, (int)action);
database.AddOutParameter(storedProcCommand, "Status", DbType.Int32, 4);
if (action != DataProviderAction.Create)
{
database.AddInParameter(storedProcCommand, "LinkId", DbType.Int32, friendlyLink.LinkId);
}
if (action != DataProviderAction.Delete)
{
database.AddInParameter(storedProcCommand, "ImageUrl", DbType.String, friendlyLink.ImageUrl);
database.AddInParameter(storedProcCommand, "LinkUrl", DbType.String, friendlyLink.LinkUrl);
database.AddInParameter(storedProcCommand, "Title", DbType.String, friendlyLink.Title);
database.AddInParameter(storedProcCommand, "Visible", DbType.Boolean, friendlyLink.Visible);
}
database.ExecuteNonQuery(storedProcCommand);
return (((int)database.GetParameterValue(storedProcCommand, "Status")) == 0);
}
public bool AttributeManage(Maticsoft.Model.Shop.Products.AttributeInfo model, DataProviderAction Action)
{
int rowsAffected = 0;
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@Action", SqlDbType.Int), new SqlParameter("@AttributeId", SqlDbType.BigInt), new SqlParameter("@AttributeName", SqlDbType.NVarChar), new SqlParameter("@TypeId", SqlDbType.Int), new SqlParameter("@UsageMode", SqlDbType.Int), new SqlParameter("@UseAttributeImage", SqlDbType.Bit), new SqlParameter("@UserDefinedPic", SqlDbType.Bit), new SqlParameter("@AttributeIdOutPut", SqlDbType.BigInt) };
parameters[0].Value = (int) Action;
parameters[1].Value = model.AttributeId;
parameters[2].Value = model.AttributeName;
parameters[3].Value = model.TypeId;
parameters[4].Value = model.UsageMode;
parameters[5].Value = model.UseAttributeImage;
parameters[6].Value = model.UserDefinedPic;
parameters[7].Direction = ParameterDirection.Output;
DbHelperSQL.RunProcedure("sp_Shop_AttributesCreateEditDelete", parameters, out rowsAffected);
long attributeId = 0L;
if (Action == DataProviderAction.Create)
{
attributeId = Convert.ToInt64(parameters[7].Value);
}
else
{
attributeId = model.AttributeId;
}
if (rowsAffected <= 0)
{
return false;
}
Maticsoft.SQLServerDAL.Shop.Products.AttributeValue value2 = new Maticsoft.SQLServerDAL.Shop.Products.AttributeValue();
foreach (string str in model.ValueStr)
{
Maticsoft.Model.Shop.Products.AttributeValue value3 = new Maticsoft.Model.Shop.Products.AttributeValue {
AttributeId = attributeId,
ValueStr = str
};
value2.AttributeValueManage(value3, DataProviderAction.Create);
}
return true;
}
public abstract int CreateUpdateDeleteStyle( Style style, DataProviderAction action );
public abstract int CreateUpdateDeleteSmiley( Smiley smiley, DataProviderAction action );
public abstract int CreateUpdateDeleteService( Service service, DataProviderAction action );
public abstract int CreateUpdateDeleteSection(Section section, DataProviderAction action);
public abstract Guid CreateUpdateDeleteRole(Role role, string applicationName, DataProviderAction action);
public abstract void CreateDeleteSearchIgnoreWords(ArrayList words, DataProviderAction action);
private static int CreateUpdateDeleteName(string name, string replacement, DataProviderAction action )
{
CSCache.Remove( cacheKey );
CommonDataProvider dp = CommonDataProvider.Instance();
return dp.CreateUpdateDeleteDisallowedName(name, replacement, action);
}
public abstract void CreateUpdateDeletePermission(PermissionBase p, DataProviderAction action);
public override bool CreateUpdateDeleteHelpCategory(HelpCategoryInfo helpCategory, DataProviderAction action)
{
if (null == helpCategory)
{
return false;
}
DbCommand storedProcCommand = database.GetStoredProcCommand("sub_HelpCategory_CreateUpdateDelete");
database.AddInParameter(storedProcCommand, "Action", DbType.Int32, (int)action);
database.AddOutParameter(storedProcCommand, "Status", DbType.Int32, 4);
if (action != DataProviderAction.Create)
{
database.AddInParameter(storedProcCommand, "CategoryId", DbType.Int32, helpCategory.CategoryId);
}
database.AddInParameter(storedProcCommand, "DistributorUserId", DbType.Int32, HiContext.Current.User.UserId);
if (action != DataProviderAction.Delete)
{
database.AddInParameter(storedProcCommand, "Name", DbType.String, helpCategory.Name);
database.AddInParameter(storedProcCommand, "IconUrl", DbType.String, helpCategory.IconUrl);
database.AddInParameter(storedProcCommand, "IndexChar", DbType.String, helpCategory.IndexChar);
database.AddInParameter(storedProcCommand, "Description", DbType.String, helpCategory.Description);
database.AddInParameter(storedProcCommand, "IsShowFooter", DbType.Boolean, helpCategory.IsShowFooter);
}
database.ExecuteNonQuery(storedProcCommand);
return (((int)database.GetParameterValue(storedProcCommand, "Status")) == 0);
}
public PaymentModeActionStatus CreateUpdateDeletePaymentMode(PaymentModeInfo paymentMode, DataProviderAction action)
{
if (paymentMode == null)
{
return PaymentModeActionStatus.UnknowError;
}
DbCommand storedProcCommand = this.database.GetStoredProcCommand("sp_Pay_PaymentMode_CreateUpdateDelete");
this.database.AddInParameter(storedProcCommand, "Action", DbType.Int32, (int) action);
this.database.AddOutParameter(storedProcCommand, "Status", DbType.Int32, 4);
if (action == DataProviderAction.Create)
{
this.database.AddOutParameter(storedProcCommand, "ModeId", DbType.Int32, 4);
}
else
{
this.database.AddInParameter(storedProcCommand, "ModeId", DbType.Int32, paymentMode.ModeId);
}
if (action != DataProviderAction.Delete)
{
this.database.AddInParameter(storedProcCommand, "MerchantCode", DbType.String, paymentMode.MerchantCode);
this.database.AddInParameter(storedProcCommand, "EmailAddress", DbType.String, paymentMode.EmailAddress);
this.database.AddInParameter(storedProcCommand, "SecretKey", DbType.String, paymentMode.SecretKey);
this.database.AddInParameter(storedProcCommand, "SecondKey", DbType.String, paymentMode.SecondKey);
this.database.AddInParameter(storedProcCommand, "Password", DbType.String, paymentMode.Password);
this.database.AddInParameter(storedProcCommand, "Partner", DbType.String, paymentMode.Partner);
this.database.AddInParameter(storedProcCommand, "Name", DbType.String, paymentMode.Name);
this.database.AddInParameter(storedProcCommand, "Description", DbType.String, paymentMode.Description);
this.database.AddInParameter(storedProcCommand, "AllowRecharge", DbType.Boolean, paymentMode.AllowRecharge);
this.database.AddInParameter(storedProcCommand, "Gateway", DbType.String, paymentMode.Gateway);
if (paymentMode.DisplaySequence > 0)
{
this.database.AddInParameter(storedProcCommand, "DisplaySequence", DbType.Int32, paymentMode.DisplaySequence);
}
this.database.AddInParameter(storedProcCommand, "Charge", DbType.Currency, paymentMode.Charge);
this.database.AddInParameter(storedProcCommand, "IsPercent", DbType.Boolean, paymentMode.IsPercent);
}
PaymentModeActionStatus unknowError = PaymentModeActionStatus.UnknowError;
if ((action != DataProviderAction.Delete) && (paymentMode.SupportedCurrencys.Count > 0))
{
using (DbConnection connection = this.database.CreateConnection())
{
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
this.database.ExecuteNonQuery(storedProcCommand, transaction);
unknowError = (PaymentModeActionStatus) ((int) this.database.GetParameterValue(storedProcCommand, "Status"));
int num = (action == DataProviderAction.Create) ? ((int) this.database.GetParameterValue(storedProcCommand, "ModeId")) : paymentMode.ModeId;
if (unknowError == PaymentModeActionStatus.Success)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand(" ");
this.database.AddInParameter(sqlStringCommand, "ModeId", DbType.Int32, num);
StringBuilder builder = new StringBuilder();
if (action == DataProviderAction.Update)
{
builder.Append("DELETE From Pay_PaymentCurrencys Where ModeId=@ModeId");
}
builder.Append(" DECLARE @intErrorCode INT;SET @intErrorCode = 0;");
int num2 = 0;
foreach (string str in paymentMode.SupportedCurrencys)
{
builder.Append("INSERT INTO Pay_PaymentCurrencys(ModeId,Code) Values(").Append("@ModeId").Append(",@Code").Append(num2).Append(");SET @intErrorCode = @intErrorCode + @@ERROR;");
this.database.AddInParameter(sqlStringCommand, "Code" + num2, DbType.String, str);
num2++;
}
sqlStringCommand.CommandText = builder.Append("SELECT @intErrorCode;").ToString();
if (((int) this.database.ExecuteScalar(sqlStringCommand, transaction)) == 0)
{
transaction.Commit();
}
else
{
transaction.Rollback();
unknowError = PaymentModeActionStatus.UnknowError;
}
}
else
{
transaction.Rollback();
}
}
catch
{
transaction.Rollback();
unknowError = PaymentModeActionStatus.UnknowError;
}
connection.Close();
return unknowError;
}
}
this.database.ExecuteNonQuery(storedProcCommand);
return (PaymentModeActionStatus) ((int) this.database.GetParameterValue(storedProcCommand, "Status"));
}
public abstract int CreateUpdateDeleteDisallowedName(string name, string replacement, DataProviderAction action);
public abstract int CreateUpdateDeleteCensor( Censor censor, DataProviderAction action );
public abstract User CreateUpdateDeleteUser(User user, DataProviderAction action, out CreateUserStatus status);
public abstract int CreateUpdateDeleteRank( Rank rank, DataProviderAction action );
public abstract GiftActionStatus CreateUpdateDeleteGift(GiftInfo gift, DataProviderAction action);
public abstract int CreateUpdateDeleteReport( Report report, DataProviderAction action );
public abstract int CreateUpdateDeleteGroup(Group group, DataProviderAction action);
public abstract bool CreateUpdateDeleteFriendlyLink(FriendlyLinksInfo friendlyLink, DataProviderAction action);
public abstract void CreateUpdateDeleteImage(int userID, Avatar avatar, DataProviderAction action);
public abstract void CreateUpdateDeleteMessage(Message message, DataProviderAction action);
public bool CreateBrandsAndTypes(Maticsoft.Model.Shop.Products.BrandInfo model, DataProviderAction action)
{
return this.dal.CreateBrandsAndTypes(model, action);
}
public override PaymentModeActionStatus CreateUpdateDeletePaymentMode(PaymentModeInfo paymentMode, DataProviderAction action)
{
if (null == paymentMode)
{
return PaymentModeActionStatus.UnknowError;
}
DbCommand storedProcCommand = database.GetStoredProcCommand("cp_PaymentType_CreateUpdateDelete");
database.AddInParameter(storedProcCommand, "Action", DbType.Int32, (int)action);
database.AddOutParameter(storedProcCommand, "Status", DbType.Int32, 4);
if (action == DataProviderAction.Create)
{
database.AddOutParameter(storedProcCommand, "ModeId", DbType.Int32, 4);
}
else
{
database.AddInParameter(storedProcCommand, "ModeId", DbType.Int32, paymentMode.ModeId);
}
if (action != DataProviderAction.Delete)
{
database.AddInParameter(storedProcCommand, "Name", DbType.String, paymentMode.Name);
database.AddInParameter(storedProcCommand, "Description", DbType.String, paymentMode.Description);
database.AddInParameter(storedProcCommand, "Gateway", DbType.String, paymentMode.Gateway);
database.AddInParameter(storedProcCommand, "IsUseInpour", DbType.Boolean, paymentMode.IsUseInpour);
database.AddInParameter(storedProcCommand, "Charge", DbType.Currency, paymentMode.Charge);
database.AddInParameter(storedProcCommand, "IsPercent", DbType.Boolean, paymentMode.IsPercent);
database.AddInParameter(storedProcCommand, "Settings", DbType.String, paymentMode.Settings);
}
database.ExecuteNonQuery(storedProcCommand);
return (PaymentModeActionStatus)((int)database.GetParameterValue(storedProcCommand, "Status"));
}
