public int Update(int VendorOrderPromotionId, int Order_PromotionId, string OrderValue, string PromotionValue, int IsPercent, string Description, string StartDate, string EndDate, string Discontinued)
{
OrderValue = StringHandleClass.RemoveExtraTextWithoutPointOrComma(OrderValue);
PromotionValue = StringHandleClass.RemoveExtraTextWithoutPointOrComma(PromotionValue);
SqlCommand cmd = new SqlCommand("[Purchasing].[Vendor_OrderPromotions_Update]", con)
{
CommandType = CommandType.StoredProcedure, CommandTimeout = Settings.CommandTimeout
};
cmd.Parameters.AddWithValue("@VendorOrderPromotionId", VendorOrderPromotionId);
cmd.Parameters.AddWithValue("@Order_PromotionId", Order_PromotionId);
cmd.Parameters.AddWithValue("@OrderValue", OrderValue);
cmd.Parameters.AddWithValue("@PromotionValue", PromotionValue);
cmd.Parameters.AddWithValue("@IsPercent", IsPercent);
cmd.Parameters.AddWithValue("@Description", Description);
cmd.Parameters.AddWithValue("@StartDate", StartDate);
cmd.Parameters.AddWithValue("@EndDate", EndDate);
cmd.Parameters.AddWithValue("@Discontinued", Discontinued);
cmd.Parameters.Add(new SqlParameter("@o_return", SqlDbType.Int)
{
Direction = ParameterDirection.Output
});
con.Open();
int i = cmd.ExecuteNonQuery();
int retunvalue = (int)cmd.Parameters["@o_return"].Value;
con.Close();
return(retunvalue);
}
public int Insert(int VendorId, int DiscountQty, string DiscountRate, int IsPercent, string Description, string StartDate, string EndDate)
{
DiscountRate = StringHandleClass.RemoveExtraTextWithoutPointOrComma(DiscountRate);
SqlCommand cmd = new SqlCommand("[Purchasing].[Vendor_ProductDiscounts_Insert]", con)
{
CommandType = CommandType.StoredProcedure, CommandTimeout = Settings.CommandTimeout
};
cmd.Parameters.AddWithValue("@VendorId", VendorId);
cmd.Parameters.AddWithValue("@DiscountQty", DiscountQty);
cmd.Parameters.AddWithValue("@DiscountRate", DiscountRate);
cmd.Parameters.AddWithValue("@IsPercent", IsPercent);
cmd.Parameters.AddWithValue("@Description", Description);
cmd.Parameters.AddWithValue("@StartDate", StartDate);
cmd.Parameters.AddWithValue("@EndDate", EndDate);
cmd.Parameters.Add(new SqlParameter("@o_return", SqlDbType.Int)
{
Direction = ParameterDirection.Output
});
con.Open();
int i = cmd.ExecuteNonQuery();
int retunvalue = (int)cmd.Parameters["@o_return"].Value;
con.Close();
return(retunvalue);
}
public int Update(int Product_Id, string CultureCode, string Product_Code, string Category_Code, int Manufacturer_Id, int VendorId,
int Product_TypeId, string Product_Name, string CurrencyCode, string NetPrice, string GrossPrice, int TaxRateId,
int DiscountId, int UnitsInStock, int UnitsInAPackage, int UnitsInBox, string Unit,
decimal Weight, string UnitOfWeightMeasure, decimal Length, decimal Width, decimal Height,
string UnitOfDimensionMeasure, int MinPurchaseQty, int MaxPurchaseQty, string Availability,
string StartDate, string EndDate, string PhotoFileName, string ThumbnailPhotoFileName, string Url,
string ShortDescription, string Specification, int OnlineTransactionFlag, int Discontinued)
{
string Alias = ModuleClass.convertTitle2Link(Product_Name);
NetPrice = StringHandleClass.RemoveExtraTextWithoutPointOrComma(NetPrice);
GrossPrice = StringHandleClass.RemoveExtraTextWithoutPointOrComma(GrossPrice);
SqlCommand cmd = new SqlCommand("[Production].[Products_Update]", con)
{
CommandType = CommandType.StoredProcedure, CommandTimeout = Settings.CommandTimeout
};
cmd.Parameters.AddWithValue("@Product_Id", Product_Id);
cmd.Parameters.AddWithValue("@CultureCode", CultureCode);
cmd.Parameters.AddWithValue("@Product_Code", Product_Code);
cmd.Parameters.AddWithValue("@Category_Code", Category_Code);
cmd.Parameters.AddWithValue("@Manufacturer_Id", Manufacturer_Id);
cmd.Parameters.AddWithValue("@Vendor_Id", VendorId);
cmd.Parameters.AddWithValue("@Product_TypeId", Product_TypeId);
cmd.Parameters.AddWithValue("@Product_Name", Product_Name);
cmd.Parameters.AddWithValue("@Alias", Alias);
cmd.Parameters.AddWithValue("@CurrencyCode", CurrencyCode);
cmd.Parameters.AddWithValue("@NetPrice", NetPrice);
cmd.Parameters.AddWithValue("@GrossPrice", GrossPrice);
cmd.Parameters.AddWithValue("@TaxRateId", TaxRateId);
cmd.Parameters.AddWithValue("@Discount_Id", DiscountId);
cmd.Parameters.AddWithValue("@UnitsInStock", UnitsInStock);
cmd.Parameters.AddWithValue("@UnitsInAPackage", UnitsInAPackage);
cmd.Parameters.AddWithValue("@UnitsInBox", UnitsInBox);
cmd.Parameters.AddWithValue("@Unit", Unit);
cmd.Parameters.AddWithValue("@Weight", Weight);
cmd.Parameters.AddWithValue("@UnitOfWeightMeasure", UnitOfWeightMeasure);
cmd.Parameters.AddWithValue("@Length", Length);
cmd.Parameters.AddWithValue("@Width", Width);
cmd.Parameters.AddWithValue("@Height", Height);
cmd.Parameters.AddWithValue("@UnitOfDimensionMeasure", UnitOfDimensionMeasure);
cmd.Parameters.AddWithValue("@MinPurchaseQty", MinPurchaseQty);
cmd.Parameters.AddWithValue("@MaxPurchaseQty", MaxPurchaseQty);
cmd.Parameters.AddWithValue("@Availability", Availability);
cmd.Parameters.AddWithValue("@StartDate", StartDate);
cmd.Parameters.AddWithValue("@EndDate", EndDate);
cmd.Parameters.AddWithValue("@PhotoFileName", PhotoFileName);
cmd.Parameters.AddWithValue("@ThumbnailPhotoFileName", ThumbnailPhotoFileName);
cmd.Parameters.AddWithValue("@Url", Url);
cmd.Parameters.AddWithValue("@ShortDescription", ShortDescription);
cmd.Parameters.AddWithValue("@Specification", Specification);
cmd.Parameters.AddWithValue("@OnlineTransactionFlag", OnlineTransactionFlag);
cmd.Parameters.AddWithValue("@Discontinued", Discontinued);
cmd.Parameters.Add("@o_return", SqlDbType.Int, 2).Direction = ParameterDirection.Output;
con.Open();
int i = cmd.ExecuteNonQuery();
int retunvalue = (int)cmd.Parameters["@o_return"].Value;
con.Close();
return(retunvalue);
}
