public List <clsInstallmentPlanDetails> GetInstallmentPlanDetailsByPlanCode(string id)
{
List <clsInstallmentPlanDetails> lst = new List <clsInstallmentPlanDetails>();
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand("TMR_USP_GetInstallmentPlanDetailsByPlanCode"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@InstallmentPlanCode", id);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var info = new clsInstallmentPlanDetails();
info.intId = Convert.ToInt32(reader["id"]);
info.strInstallmentPlanCode = reader["InstallmentPlanCode"].ToString();
info.intInstallmentPlanID = Convert.ToInt32(reader["InstallmentPlanID"]);
info.intInstallmentType = Convert.ToInt32(reader["InstallmentType"]);
info.strInstallmentTypeName = reader["InstallmentTypeName"].ToString();
info.intInstallmentDueAfterMonths = Convert.ToInt32(reader["InstallmentDueAfterMonths"]);
info.decInstallmentPercentage = Convert.ToDecimal(reader["InstallmentPercentage"]);
info.intInstallmentNumber = Convert.ToInt32(reader["InstallmentNumber"]);
lst.Add(info);
}
conn.Close();
}
}
return(lst);
}
public bool AddInstallmentPlanDetail(clsInstallmentPlanDetails info)
{
int st = 0;
try
{
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
{
using (SqlCommand cmd = new SqlCommand("TMR_USP_AddInstallmentPlanDetails"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@IntallmentPlanCode", info.strInstallmentPlanCode);
cmd.Parameters.AddWithValue("@IntallmentPlanID", info.intInstallmentPlanID);
cmd.Parameters.AddWithValue("@InstallmentType", info.intInstallmentType);
cmd.Parameters.AddWithValue("@InstallmentDueAfterMonths", info.intInstallmentDueAfterMonths);
cmd.Parameters.AddWithValue("@InstallmentPercentage", info.decInstallmentPercentage);
cmd.Parameters.AddWithValue("@InstallmentNumber", info.intInstallmentNumber);
st = cmd.ExecuteNonQuery();
}
}
conn.Close();
}
}
catch (Exception ex) { }
if (st > 0)
{
return(true);
}
else
{
return(false);
}
}