public IList <KisanCreditCardModel> GetKisanCreditCardList(int UserId)
{
IList <KisanCreditCardModel> listitems = new List <KisanCreditCardModel>();
try
{
using (SqlConnection conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetKisanCreditCardRequested";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", UserId);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
KisanCreditCardModel model = new KisanCreditCardModel();
model.CreditLimit = Convert.ToString(reader["CreditLimit"]);
model.Tenure = Convert.ToString(reader["Tenure"]);
model.RateOfInterest = Convert.ToString(reader["RateOfInterest"]);
model.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]);
listitems.Add(model);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(listitems);
}
public int AddKisanCreditCardDetails(KisanCreditCardModel model)
{
int Id = 0;
try
{
using (SqlConnection conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_AddKisanCreditCardDetails";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CreditLimit", model.CreditLimit);
cmd.Parameters.AddWithValue("@Tenure", model.Tenure);
cmd.Parameters.AddWithValue("@RateOfInterest", model.RateOfInterest);
cmd.Parameters.AddWithValue("@CreatedBy", model.CreatedBy);
cmd.Parameters.Add("@Result", SqlDbType.Int).Direction = ParameterDirection.Output;
int i = cmd.ExecuteNonQuery();
Id = Convert.ToInt32(cmd.Parameters["@Result"].Value);
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(Id);
}
