public string InsertPromoCode(PropPromoCode objPromocode)
{
SqlCommand cmd = new SqlCommand("proc_PromoCode", objCon.Con);
cmd.CommandType = CommandType.StoredProcedure;
objCon.Con.Open();
try
{
cmd.Parameters.AddWithValue("@categoryID", objPromocode.CategoryID);
cmd.Parameters.AddWithValue("@SubCategoryID", objPromocode.SubCategoryID);
cmd.Parameters.AddWithValue("@fromDate", objPromocode.FromDate);
cmd.Parameters.AddWithValue("@toDate", objPromocode.ToDate);
cmd.Parameters.AddWithValue("@discount", objPromocode.Discount);
cmd.Parameters.AddWithValue("@promoCode", objPromocode.PromoCode);
cmd.Parameters.AddWithValue("@associateID", objPromocode.AssociateID);
cmd.Parameters.AddWithValue("@action", "Add");
return(cmd.ExecuteNonQuery().ToString());
}
catch (Exception showError)
{
throw showError;
}
finally
{
cmd.Dispose();
objCon.Con.Close();
objCon.Con.Dispose();
}
}
public int RecordUpdate(PropPromoCode objProperty)
{
DllPromoCode objDal = new DllPromoCode();
try
{
return(objDal.UpdatePromoCode(objProperty));
}
catch (Exception info)
{
throw info;
}
finally
{
objDal = null;
}
}
public string RecordInsert(PropPromoCode objProperty)
{
DllPromoCode objDal = new DllPromoCode();
try
{
return(objDal.InsertPromoCode(objProperty));
}
catch (Exception info)
{
throw info;
}
finally
{
objDal = null;
}
}
public string InsertPromo(int categoryID, int SubcategoryID, DateTime _fromDate, DateTime _toDate, float Discount, string PromoCode)
{
string str = string.Empty;
if (Session["associate"].ToString() != "" || Session["associate"].ToString() != null)
{
PropPromoCode propPromo = new PropPromoCode();
propPromo.CategoryID = categoryID;
propPromo.SubCategoryID = SubcategoryID;
propPromo.FromDate = _fromDate;
propPromo.ToDate = _toDate;
propPromo.Discount = Discount;
propPromo.PromoCode = PromoCode;
propPromo.AssociateID = Convert.ToInt16(Session["associate"]);
BllPromoCode objPromoCode = new BllPromoCode();
str = objPromoCode.RecordInsert(propPromo);
return(str);
}
else
{
return("Error in Authentication");
}
}
public int DeletePromoCode(PropPromoCode objPromocode)
{
SqlCommand cmd = new SqlCommand("proc_UDS_PromoCodeRegistration", objCon.Con);
return(cmd.ExecuteNonQuery());
}
