/// <summary>
/// Description : Get Company Type Details from database.
/// Created By : Sudheer
/// Created Date : 30 July 2014
/// Modified By : Pavan
/// Modified Date: added IsIncorp Parameter For IncorpCompanyType
/// </summary>
/// <returns></returns>
public static List<CompanyType> GetCompanyTypeDetails(int IsIncorp)
{
var data = new List<CompanyType>();
System.Diagnostics.StackFrame stackFrame = new System.Diagnostics.StackFrame();
System.Reflection.MethodBase methodBase = stackFrame.GetMethod();
log.Debug("Start: " + methodBase.Name);
try
{
SqlParameter[] sqlParams = new SqlParameter[1];
sqlParams[0] = new SqlParameter("@IsIncorp", IsIncorp);
var reader = SqlHelper.ExecuteReader(ConnectionUtility.GetConnectionString(), CommandType.StoredProcedure, "[SpGetCSS1CompanyTypeDetails]", sqlParams);
var safe = new SafeDataReader(reader);
while (reader.Read())
{
var companyType = new CompanyType();
companyType.FetchPartialCompanyTypeContent(companyType, safe);
data.Add(companyType);
}
return data;
}
catch (Exception ex)
{
log.Error("Error: " + ex);
return data;
}
finally
{
log.Debug("End: " + methodBase.Name);
}
}
