public List <clsRecoveryType> GetRecoveryTypes()
{
List <clsRecoveryType> lst = new List <clsRecoveryType>();
using (SqlConnection conn = new SqlConnection(strConn))
{
using (SqlCommand cmd = new SqlCommand("TMR_USP_GetRecoveryTypes"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
clsRecoveryType info = new clsRecoveryType();
info.strCode = reader["code"].ToString();
info.strDescription = reader["description"].ToString();
info.bDueMonthly = Convert.ToBoolean(reader["DueMonthly"]);
info.bIncludeTotal = Convert.ToBoolean(reader["IncludeinTotal"]);
info.intId = int.Parse(reader["id"].ToString());
lst.Add(info);
}
conn.Close();
}
}
return(lst);
}
public bool AddRecoveryType(clsRecoveryType info)
{
int st = 0;
try
{
using (SqlConnection conn = new SqlConnection(strConn))
{
conn.Open();
{
using (SqlCommand cmd = new SqlCommand("TMR_USP_AddRecoveryType"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@Code", info.strCode);
cmd.Parameters.AddWithValue("@Description", info.strDescription);
cmd.Parameters.AddWithValue("@DueMonthly", info.bDueMonthly);
cmd.Parameters.AddWithValue("@IncludeinTotal", info.bIncludeTotal);
cmd.Parameters.AddWithValue("@ID", info.intId);
st = cmd.ExecuteNonQuery();
}
}
conn.Close();
}
}
catch (Exception ex) { }
if (st > 0)
{
return(true);
}
else
{
return(false);
}
}
