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); }