/// <summary>
/// Finds and return cExcelEmployeeData objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cExcelEmployeeData objects</returns>
public static List <cExcelEmployeeData> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cExcelEmployeeData> l = new List <cExcelEmployeeData>();
cExcelEmployeeData oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cExcelEmployeeData();
oObj.m_iID = Convert.ToInt32(dt.Rows[i]["iID"]);
oObj.m_sName = dt.Rows[i]["sName"].ToString();
oObj.m_dtCreatedOn = Convert.ToDateTime(dt.Rows[i]["dtCreatedOn"]);
oObj.m_dtLastUpdatedOn = Convert.ToDateTime(dt.Rows[i]["dtLastUpdatedOn"]);
oObj.m_sFirstName = Convert.ToString(dt.Rows[i]["sFirstName"]);
oObj.m_sMiddleName = Convert.ToString(dt.Rows[i]["sMiddleName"]);
oObj.m_sLastNam = Convert.ToString(dt.Rows[i]["sLastNam"]);
oObj.m_sWorkEmailaID = Convert.ToString(dt.Rows[i]["sWorkEmailaID"]);
oObj.m_sDepartment = Convert.ToString(dt.Rows[i]["sDepartment"]);
oObj.m_sFunctionalGroup = Convert.ToString(dt.Rows[i]["sFunctionalGroup"]);
oObj.m_sDesignation = Convert.ToString(dt.Rows[i]["sDesignation"]);
oObj.m_sPersonalEmailID = Convert.ToString(dt.Rows[i]["sPersonalEmailID"]);
oObj.m_sTitle = Convert.ToString(dt.Rows[i]["sTitle"]);
oObj.m_sPassword = Convert.ToString(dt.Rows[i]["sPassword"]);
oObj.m_sReportingHead = Convert.ToString(dt.Rows[i]["sReportingHead"]);
oObj.m_sRollAccess = Convert.ToString(dt.Rows[i]["sRollAccess"]);
oObj.m_sLocation = Convert.ToString(dt.Rows[i]["sLocation"]);
oObj.m_dtDOJ = Convert.ToDateTime(dt.Rows[i]["dtDOJ"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Creates a cExcelEmployeeData object. It will be saved in permanent storage only
/// on calling Save()
/// </summary>
/// <returns>cExcelEmployeeData object</returns>
public static cExcelEmployeeData Create()
{
cExcelEmployeeData oObj = new cExcelEmployeeData();
SecurityCheck((int)enExcelEmployeeData_Action.Create);
// Create an object in memory, will be saved to storage on calling Save()
oObj.m_bCreating = true;
oObj.m_bInvalid = false;
return(oObj);
}
/// <summary>
/// Ensures that an object with the specified name exists, while creating other properties are set to their default values
/// </summary>
/// <param name="i_sName">Name</param>
/// <returns>cExcelEmployeeData object</returns>
public static cExcelEmployeeData CreateIfRequiredAndGet(string i_sName)
{
cExcelEmployeeData oObj = cExcelEmployeeData.Get_Name(i_sName);
if (oObj == null)
{
oObj = cExcelEmployeeData.Create();
oObj.sName = i_sName;
oObj.Save();
}
return(oObj);
}
using System;
