public List <SubscriptionActivated> GetUserSubscription(int useId)
{
List <SubscriptionActivated> lstsubActivated = new List <SubscriptionActivated>();
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(strConString))
{
SqlCommand cmd = new SqlCommand("ProcGetInsertProductDetails", con);
cmd.Parameters.Add(new SqlParameter("@Action", "GetUserSubscription"));
cmd.Parameters.Add(new SqlParameter("@UserId", useId));
cmd.CommandType = CommandType.StoredProcedure;
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
if (dt.Rows.Count > 0)
{
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
SubscriptionActivated SubActivated = new SubscriptionActivated();
SubActivated.UserId = Convert.ToInt16(dt.Rows[i]["UserId"].ToString());
SubActivated.ProductId = Convert.ToInt16(dt.Rows[i]["ProductId"].ToString());
SubActivated.ProductName = dt.Rows[i]["ProductName"].ToString();
SubActivated.CategoryId = Convert.ToInt16(dt.Rows[i]["CategoryId"].ToString());
SubActivated.CategoryName = dt.Rows[i]["CategoryName"].ToString();
SubActivated.TotalSubscriptionPrice = float.Parse(dt.Rows[i]["TotalSubscriptionPrice"].ToString());
SubActivated.Quantity = Convert.ToInt16(dt.Rows[i]["Quantity"].ToString());
SubActivated.Month = Convert.ToInt16(dt.Rows[i]["Month"].ToString());
SubActivated.PaymentType = dt.Rows[i]["PaymentType"].ToString();
lstsubActivated.Add(SubActivated);
}
}
return(lstsubActivated);
}
public int SaveSubsActivated(SubscriptionActivated subActivated)
{
int RowAffected = 0;
using (SqlConnection con = new SqlConnection(strConString))
{
SqlCommand cmd = new SqlCommand("ProcGetInsertProductDetails", con);
cmd.Parameters.Add(new SqlParameter("@Action", "SubscriptionActivated"));
cmd.Parameters.Add(new SqlParameter("@UserId", subActivated.UserId));
cmd.Parameters.Add(new SqlParameter("@ProductId", subActivated.ProductId));
cmd.Parameters.Add(new SqlParameter("@CategoryId ", subActivated.CategoryId));
cmd.Parameters.Add(new SqlParameter("@Quantity", subActivated.Quantity));
cmd.Parameters.Add(new SqlParameter("@Month", subActivated.Month));
cmd.Parameters.Add(new SqlParameter("@TotalSubscriptionPrice", subActivated.TotalSubscriptionPrice));
cmd.Parameters.Add(new SqlParameter("@PaymentType", subActivated.PaymentType));
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
RowAffected = cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
return(RowAffected);
}
