public String AddModifyCouponCode(ClsCouponDetails ObjCouponDetails)
{
using (ClsMasterManagement_DAL obj = new ClsMasterManagement_DAL())
{
return(obj.AddModifyCouponCode(ObjCouponDetails));
}
}
public string AddModifyCouponCode(ClsCouponDetails ObjCouponDetails)
{
try
{
DBParameterCollection ObJParameterCOl = new DBParameterCollection();
DBParameter objDBParameter = new DBParameter("@Ref_Coupon_ID", ObjCouponDetails.Ref_Coupon_ID, DbType.Int64);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@CouponCode", ObjCouponDetails.CouponCode, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@CouponUseBy", ObjCouponDetails.CouponUseBy, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@Description", ObjCouponDetails.Description, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@DiscountInPercentage", ObjCouponDetails.DiscountInPercentage, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@DiscountInMax", ObjCouponDetails.DiscountInMax, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@StartDate", ObjCouponDetails.StartDate, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@EndDate", ObjCouponDetails.EndDate, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@OneTimeUse", ObjCouponDetails.OneTimeUse, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@AudienceCount", ObjCouponDetails.AudienceCount, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@OnlyForNewUsers", ObjCouponDetails.OnlyForNewUsers, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@CreatedBy", ObjCouponDetails.CreatedBy, DbType.String);
ObJParameterCOl.Add(objDBParameter);
objDBParameter = new DBParameter("@IsActive", ObjCouponDetails.IsActive, DbType.Boolean);
ObJParameterCOl.Add(objDBParameter);
Int64 Ref_CouponCode_ID = 0;
DBHelper objDbHelper = new DBHelper();
Ref_CouponCode_ID = Convert.ToInt64(objDbHelper.ExecuteScalar(Constant.AddModifyCouponCode, ObJParameterCOl, CommandType.StoredProcedure));
if (Ref_CouponCode_ID > 0)
{
ObjCouponDetails.CouponObject.ForEach(Object =>
{
DBParameterCollection ObJParameterCOl1 = new DBParameterCollection();
DBParameter objDBParameter1 = new DBParameter("@Ref_CouponCode_ID", Ref_CouponCode_ID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@ObjectType", Object.ObjectType, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@Ref_Object_ID", Object.Ref_Object_ID, DbType.Int64);
ObJParameterCOl1.Add(objDBParameter1);
objDBParameter1 = new DBParameter("@CreatedBy", ObjCouponDetails.CreatedBy, DbType.String);
ObJParameterCOl1.Add(objDBParameter1);
objDbHelper.ExecuteScalar("[dbo].[AddModifyCouponObjectMapping]", ObJParameterCOl1, CommandType.StoredProcedure);
});
}
if (Ref_CouponCode_ID > 0 && ObjCouponDetails.Ref_Coupon_ID == 0)
{
return("COUPONCODEADDED");
}
else if (Ref_CouponCode_ID > 0 && ObjCouponDetails.Ref_Coupon_ID > 0)
{
return("COUPONCODEUPDATED");
}
else
{
return("COUPONCODEEXISTS");
}
}
catch (Exception ex)
{
throw ex;
}
}
