public List <discountDetailsClass> SelectDiscount(string bizID)
{
SqlConnection con = new SqlConnection(connectionstr);
SqlCommand cmd = new SqlCommand("DiscountSelect", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@bizID", SqlDbType.VarChar, 50));
cmd.Parameters["@bizID"].Value = bizID;
List <discountDetailsClass> disCountsAvailable = new List <discountDetailsClass>();
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
discountDetailsClass disCntDtls = new discountDetailsClass(
(Int64)reader["bizDisCountID"], (string)reader["bizID"], (string)reader["bizDiscountHeader"], (string)reader["bizDiscountDesc"],
(string)reader["bizDiscountException1"], (DateTime)reader["bizDiscountStartdate"],
(DateTime)reader["bizDiscountExpirydate"], (int)reader["bizDiscountMaxprint"],
(int)reader["bizDiscountCpnsGen"], (Decimal)reader["bizDiscountOrgPrice"], (Decimal)reader["bizDiscountCpnPrice"]);
disCountsAvailable.Add(disCntDtls);
DataSet dtTab = new DataSet();
DataTable datTab = new DataTable();
dtTab.ReadXml(reader.GetSqlXml(reader.GetOrdinal("bizDiscountBuyers")).CreateReader());
datTab = dtTab.Tables["buyer"];
if (datTab != null)
{
string discountCache = "Cachediscountbuyerslist" + reader["bizDisCountID"].ToString();
HttpRuntime.Cache.Insert(discountCache,
datTab,
null,
System.DateTime.MaxValue,
TimeSpan.Zero,
System.Web.Caching.CacheItemPriority.Default,
null);
}
}
reader.Close();
return(disCountsAvailable);
}
catch (SqlException err)
{
throw new ApplicationException("Select Error Discount : " + err.Message);
}
finally
{
con.Close();
}
}
public int InsertDiscount(discountDetailsClass DisCnt)
{
SqlConnection con = new SqlConnection(connectionstr);
SqlCommand cmd = new SqlCommand("DiscountInsert", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@bizID", SqlDbType.VarChar, 50));
cmd.Parameters.Add(new SqlParameter("@header", SqlDbType.VarChar, 100));
cmd.Parameters.Add(new SqlParameter("@descrition", SqlDbType.VarChar));
cmd.Parameters.Add(new SqlParameter("@exceptions", SqlDbType.VarChar));
cmd.Parameters.Add(new SqlParameter("@startDate", SqlDbType.Date));
cmd.Parameters.Add(new SqlParameter("@expirydate", SqlDbType.Date));
cmd.Parameters.Add(new SqlParameter("@maxnumberofCoupons", SqlDbType.Int, 5));
cmd.Parameters.Add(new SqlParameter("@currentCuponsGen", SqlDbType.Int, 5));
cmd.Parameters.Add(new SqlParameter("@orgPrice", SqlDbType.Int, 5));
cmd.Parameters.Add(new SqlParameter("@cpnPrice", SqlDbType.Int, 5));
cmd.Parameters["@bizID"].Value = DisCnt.BizID;
cmd.Parameters["@header"].Value = DisCnt.Header;
cmd.Parameters["@descrition"].Value = DisCnt.Description;
cmd.Parameters["@exceptions"].Value = DisCnt.Exceptions;
cmd.Parameters["@startDate"].Value = DisCnt.StartDate;
cmd.Parameters["@expirydate"].Value = DisCnt.ExpiryDate;
cmd.Parameters["@maxnumberofCoupons"].Value = DisCnt.MaxNumberofPrints;
cmd.Parameters["@orgPrice"].Value = DisCnt.OrgPrice;
cmd.Parameters["@cpnPrice"].Value = DisCnt.CpnPrice;
// cmd.Parameters["@currentCuponsGen"].Value = DisCnt.CurrentPrints;
cmd.Parameters.Add(new SqlParameter("@discountID", SqlDbType.BigInt));
cmd.Parameters["@discountID"].Direction = ParameterDirection.Output;
try
{
con.Open();
cmd.ExecuteNonQuery();
return(1);
}
catch (SqlException Err)
{
throw new ApplicationException(Err.ErrorCode + " - Error in Insert Discount");
}
finally
{
con.Close();
}
}
