//-----------------------------------------------------------------------
private List <CategoryStatus> Init(string LogFilePath, string LogFileName, SqlCommand cmd)
{
SqlConnection con = db.getConnection();
cmd.Connection = con;
List <CategoryStatus> l_CategoryStatus = new List <CategoryStatus>();
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
SmartDataReader smartReader = new SmartDataReader(reader);
while (smartReader.Read())
{
CategoryStatus m_CategoryStatus = new CategoryStatus(db.ConnectionString);
m_CategoryStatus.CategoryStatusId = smartReader.GetByte("CategoryStatusId");
m_CategoryStatus.CategoryStatusName = smartReader.GetString("CategoryStatusName");
m_CategoryStatus.CategoryStatusDesc = smartReader.GetString("CategoryStatusDesc");
l_CategoryStatus.Add(m_CategoryStatus);
}
smartReader.disposeReader(reader);
db.closeConnection(con);
}
catch (SqlException ex)
{
LogFiles.WriteLog(ex.Message, LogFilePath + "\\Exception", LogFileName + "." + this.GetType().Name + "." + MethodBase.GetCurrentMethod().Name);
}
return(l_CategoryStatus);
}
//-----------------------------------------------------------------------
public CategoryStatus Get(List <CategoryStatus> lCategoryStatus, byte CategoryStatusId)
{
CategoryStatus RetVal = new CategoryStatus(db.ConnectionString);
foreach (CategoryStatus mCategoryStatus in lCategoryStatus)
{
if (mCategoryStatus.CategoryStatusId == CategoryStatusId)
{
RetVal = mCategoryStatus;
break;
}
}
return(RetVal);
}
//-----------------------------------------------------------------------
public CategoryStatus Get(string LogFilePath, string LogFileName, byte CategoryStatusId)
{
CategoryStatus RetVal = new CategoryStatus(db.ConnectionString);
try
{
List <CategoryStatus> list = GetListByCategoryStatusId(LogFilePath, LogFileName, CategoryStatusId);
if (list.Count > 0)
{
RetVal = (CategoryStatus)list[0];
}
}
catch (Exception ex)
{
LogFiles.WriteLog(ex.Message, LogFilePath + "\\Exception", LogFileName + "." + this.GetType().Name + "." + MethodBase.GetCurrentMethod().Name);
}
return(RetVal);
}