/// <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>
/// Finds and return cEmpEducationDetail objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cEmpEducationDetail objects</returns>
public static List <cEmpEducationDetail> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cEmpEducationDetail> l = new List <cEmpEducationDetail>();
cEmpEducationDetail oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cEmpEducationDetail();
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_sInstituteName = Convert.ToString(dt.Rows[i]["sInstituteName"]);
oObj.m_sHigestDegree = Convert.ToString(dt.Rows[i]["sHigestDegree"]);
oObj.m_sUniversity = Convert.ToString(dt.Rows[i]["sUniversity"]);
oObj.m_sDegreeType = Convert.ToString(dt.Rows[i]["sDegreeType"]);
oObj.m_sPassingYear = Convert.ToString(dt.Rows[i]["sPassingYear"]);
oObj.m_fPercentage = Convert.ToSingle(dt.Rows[i]["fPercentage"]);
oObj.m_sSpecialization = Convert.ToString(dt.Rows[i]["sSpecialization"]);
oObj.m_sCertification = Convert.ToString(dt.Rows[i]["sCertification"]);
oObj.m_objEmpLogin.iObjectID = Convert.ToInt32(dt.Rows[i]["objEmpLogin"].ToString());
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_sEducationLevel = Convert.ToString(dt.Rows[i]["sEducationLevel"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cReviewRating objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cReviewRating objects</returns>
public static List <cReviewRating> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cReviewRating> l = new List <cReviewRating>();
cReviewRating oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cReviewRating();
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_sManagerComment = Convert.ToString(dt.Rows[i]["sManagerComment"]);
oObj.m_objRatings.iObjectID = Convert.ToInt32(dt.Rows[i]["objRatings"].ToString());
oObj.m_sManagerSignature = Convert.ToString(dt.Rows[i]["sManagerSignature"]);
oObj.m_sEmployeeAcceptance = Convert.ToString(dt.Rows[i]["sEmployeeAcceptance"]);
oObj.m_sEmployeeSignature = Convert.ToString(dt.Rows[i]["sEmployeeSignature"]);
oObj.m_objEmpLogin.iObjectID = Convert.ToInt32(dt.Rows[i]["objEmpLogin"].ToString());
oObj.m_iEmployeeID = Convert.ToInt32(dt.Rows[i]["iEmployeeID"]);
oObj.m_bEmpFlag = Convert.ToBoolean(dt.Rows[i]["bEmpFlag"]);
oObj.m_bManagerFlag = Convert.ToBoolean(dt.Rows[i]["bManagerFlag"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cTimeSheetActivityDes objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cTimeSheetActivityDes objects</returns>
public static List <cTimeSheetActivityDes> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cTimeSheetActivityDes> l = new List <cTimeSheetActivityDes>();
cTimeSheetActivityDes oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cTimeSheetActivityDes();
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_objTimeSheetActivity.iObjectID = Convert.ToInt32(dt.Rows[i]["objTimeSheetActivity"].ToString());
oObj.m_sDescription = Convert.ToString(dt.Rows[i]["sDescription"]);
oObj.m_sMonday = Convert.ToString(dt.Rows[i]["sMonday"]);
oObj.m_sTuesday = Convert.ToString(dt.Rows[i]["sTuesday"]);
oObj.m_sWed = Convert.ToString(dt.Rows[i]["sWed"]);
oObj.m_sThu = Convert.ToString(dt.Rows[i]["sThu"]);
oObj.m_sFri = Convert.ToString(dt.Rows[i]["sFri"]);
oObj.m_sSat = Convert.ToString(dt.Rows[i]["sSat"]);
oObj.m_sSun = Convert.ToString(dt.Rows[i]["sSun"]);
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cProject objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cProject objects</returns>
public static List <cProject> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cProject> l = new List <cProject>();
cProject oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cProject();
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_sProjectName = Convert.ToString(dt.Rows[i]["sProjectName"]);
oObj.m_objClient.iObjectID = Convert.ToInt32(dt.Rows[i]["objClient"].ToString());
oObj.m_objExternalProjectHead.iObjectID = Convert.ToInt32(dt.Rows[i]["objExternalProjectHead"].ToString());
oObj.m_iInternalHead = Convert.ToInt32(dt.Rows[i]["iInternalHead"]);
oObj.m_sDescription = Convert.ToString(dt.Rows[i]["sDescription"]);
oObj.m_dtStartDate = Convert.ToDateTime(dt.Rows[i]["dtStartDate"]);
oObj.m_dtEndDate = Convert.ToDateTime(dt.Rows[i]["dtEndDate"]);
oObj.m_objStatus.iObjectID = Convert.ToInt32(dt.Rows[i]["objStatus"].ToString());
oObj.m_sCompletion = Convert.ToString(dt.Rows[i]["sCompletion"]);
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cCareerDevelopmentPlan objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cCareerDevelopmentPlan objects</returns>
public static List <cCareerDevelopmentPlan> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cCareerDevelopmentPlan> l = new List <cCareerDevelopmentPlan>();
cCareerDevelopmentPlan oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cCareerDevelopmentPlan();
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_sDevGoalName = Convert.ToString(dt.Rows[i]["sDevGoalName"]);
oObj.m_sActionRequired = Convert.ToString(dt.Rows[i]["sActionRequired"]);
oObj.m_sTracking = Convert.ToString(dt.Rows[i]["sTracking"]);
oObj.m_sManagerComment = Convert.ToString(dt.Rows[i]["sManagerComment"]);
oObj.m_objEmpLogin.iObjectID = Convert.ToInt32(dt.Rows[i]["objEmpLogin"].ToString());
oObj.m_objStatus.iObjectID = Convert.ToInt32(dt.Rows[i]["objStatus"].ToString());
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cQuadrantMeasureMain objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cQuadrantMeasureMain objects</returns>
public static List <cQuadrantMeasureMain> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cQuadrantMeasureMain> l = new List <cQuadrantMeasureMain>();
cQuadrantMeasureMain oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cQuadrantMeasureMain();
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_objEmpLogin.iObjectID = Convert.ToInt32(dt.Rows[i]["objEmpLogin"].ToString());
oObj.m_bIsEmployeeReleased = Convert.ToBoolean(dt.Rows[i]["bIsEmployeeReleased"]);
oObj.m_bIsHRReleased = Convert.ToBoolean(dt.Rows[i]["bIsHRReleased"]);
oObj.m_objStatus.iObjectID = Convert.ToInt32(dt.Rows[i]["objStatus"].ToString());
oObj.m_sYear = Convert.ToString(dt.Rows[i]["sYear"]);
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
private void cmdFilterClear_Click(object sender, EventArgs e)
{
ZFilterFormsClose();
mFilter = null;
lblFilter.Text = kNone;
ZQueryMessagesAsync();
}
public void FilterApply()
{
cFilter lFilter = null;
foreach (frmFilter lForm in mFilterForms)
{
if (!lForm.ValidateChildren(ValidationConstraints.Enabled))
{
Program.Focus(lForm);
return;
}
if (lFilter == null)
{
lFilter = lForm.Filter();
}
else
{
lFilter = lFilter | lForm.Filter();
}
}
mFilter = lFilter;
if (mFilter == null)
{
lblFilter.Text = kNone;
}
else
{
lblFilter.Text = mFilter.ToString();
}
ZQueryMessagesAsync();
}
/// <summary>
/// Finds and return cEmpLeave objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cEmpLeave objects</returns>
public static List <cEmpLeave> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cEmpLeave> l = new List <cEmpLeave>();
cEmpLeave oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cEmpLeave();
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_dtFromDate = Convert.ToDateTime(dt.Rows[i]["dtFromDate"]);
oObj.m_dtToDate = Convert.ToDateTime(dt.Rows[i]["dtToDate"]);
oObj.m_sReason = Convert.ToString(dt.Rows[i]["sReason"]);
oObj.m_objLeaveType.iObjectID = Convert.ToInt32(dt.Rows[i]["objLeaveType"].ToString());
oObj.m_objEmpLogin.iObjectID = Convert.ToInt32(dt.Rows[i]["objEmpLogin"].ToString());
oObj.m_sLeaveStatus = Convert.ToString(dt.Rows[i]["sLeaveStatus"]);
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_iReportingHead = Convert.ToInt32(dt.Rows[i]["iReportingHead"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cEmployeeQuadrant objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cEmployeeQuadrant objects</returns>
public static List <cEmployeeQuadrant> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cEmployeeQuadrant> l = new List <cEmployeeQuadrant>();
cEmployeeQuadrant oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cEmployeeQuadrant();
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_sMeasureDescription = Convert.ToString(dt.Rows[i]["sMeasureDescription"]);
oObj.m_sEmployeeDescription = Convert.ToString(dt.Rows[i]["sEmployeeDescription"]);
oObj.m_sManagerDescription = Convert.ToString(dt.Rows[i]["sManagerDescription"]);
oObj.m_objQuadrant.iObjectID = Convert.ToInt32(dt.Rows[i]["objQuadrant"].ToString());
oObj.m_objStatus.iObjectID = Convert.ToInt32(dt.Rows[i]["objStatus"].ToString());
oObj.m_objEmpLogin.iObjectID = Convert.ToInt32(dt.Rows[i]["objEmpLogin"].ToString());
oObj.m_bEmpFlag = Convert.ToBoolean(dt.Rows[i]["bEmpFlag"]);
oObj.m_bManagerFlag = Convert.ToBoolean(dt.Rows[i]["bManagerFlag"]);
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cTimesheet objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cTimesheet objects</returns>
public static List <cTimesheet> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cTimesheet> l = new List <cTimesheet>();
cTimesheet oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cTimesheet();
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_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_dtStartDate = Convert.ToDateTime(dt.Rows[i]["dtStartDate"]);
oObj.m_dtEndDate = Convert.ToDateTime(dt.Rows[i]["dtEndDate"]);
oObj.m_objProject.iObjectID = Convert.ToInt32(dt.Rows[i]["objProject"].ToString());
oObj.m_sTotalTime = Convert.ToString(dt.Rows[i]["sTotalTime"]);
oObj.m_objEmpLogin.iObjectID = Convert.ToInt32(dt.Rows[i]["objEmpLogin"].ToString());
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cEmpLogin objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cEmpLogin objects</returns>
public static List <cEmpLogin> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cEmpLogin> l = new List <cEmpLogin>();
cEmpLogin oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cEmpLogin();
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_sEmailID = Convert.ToString(dt.Rows[i]["sEmailID"]);
oObj.m_sPassword = Convert.ToString(dt.Rows[i]["sPassword"]);
oObj.m_objRoleAccess.iObjectID = Convert.ToInt32(dt.Rows[i]["objRoleAccess"].ToString());
oObj.m_sFirstTime = Convert.ToString(dt.Rows[i]["sFirstTime"]);
oObj.m_objDesignation.iObjectID = Convert.ToInt32(dt.Rows[i]["objDesignation"].ToString());
oObj.m_objLocation.iObjectID = Convert.ToInt32(dt.Rows[i]["objLocation"].ToString());
oObj.m_objTitle.iObjectID = Convert.ToInt32(dt.Rows[i]["objTitle"].ToString());
oObj.m_objManageGroup.iObjectID = Convert.ToInt32(dt.Rows[i]["objManageGroup"].ToString());
oObj.m_bFirstTime = Convert.ToBoolean(dt.Rows[i]["bFirstTime"]);
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cEmpProfessionalDetail objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cEmpProfessionalDetail objects</returns>
public static List <cEmpProfessionalDetail> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cEmpProfessionalDetail> l = new List <cEmpProfessionalDetail>();
cEmpProfessionalDetail oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cEmpProfessionalDetail();
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_sCompanyName = Convert.ToString(dt.Rows[i]["sCompanyName"]);
oObj.m_sDesignation = Convert.ToString(dt.Rows[i]["sDesignation"]);
oObj.m_sProfileDescription = Convert.ToString(dt.Rows[i]["sProfileDescription"]);
oObj.m_dtFromDate = Convert.ToDateTime(dt.Rows[i]["dtFromDate"]);
oObj.m_dtEndDate = Convert.ToDateTime(dt.Rows[i]["dtEndDate"]);
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_objEmpLogin.iObjectID = Convert.ToInt32(dt.Rows[i]["objEmpLogin"].ToString());
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Returns a DataTable of deleted records matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <param name="i_oOutputFields">Fields to return (SELECT clause), pass null to return all fields(SELECT *)</param>
/// <returns>DataTable</returns>
public static DataTable Find_DataTable(cFilter i_oFilter, cFilterOutput i_oOutputFields)
{
SecurityCheck((int)enCountry_Action.Find);
List <SqlParameter> a = new List <SqlParameter>();
a.Add(new SqlParameter("@sFilter", SqlDbType.VarChar, 8000));
if (i_oFilter == null)
{
a[a.Count - 1].Value = "";
}
else
{
a[a.Count - 1].Value = i_oFilter.ToSQL_WHERE_Clause(new cCountry());
}
a[a.Count - 1].Value = GetSecurityScopeFilter(a[a.Count - 1].Value.ToString(), (int)enCountry_Action.Find);
a.Add(new SqlParameter("@sSelect", SqlDbType.VarChar, 8000));
if (i_oOutputFields == null)
{
a[a.Count - 1].Value = "*";
}
else
{
a[a.Count - 1].Value = i_oOutputFields.ToString(new cCountry());
}
DataTable dt = new DataTable();
bool bNoFilterOutput = i_oOutputFields == null;
if (!bNoFilterOutput)
{
bNoFilterOutput = i_oOutputFields.aOutputs.Count < 1;
}
if (bNoFilterOutput)
{
dt.Columns.Add("iID");
dt.Columns.Add("sName");
dt.Columns.Add("dtCreatedOn");
dt.Columns.Add("dtLastUpdatedOn");
}
else
{
for (int i = 0; i < i_oOutputFields.aOutputs.Count; i++)
{
dt.Columns.Add(i_oOutputFields.aOutputs[i].sName);
}
}
oDB.CallSPROC(m_oClass.sName + "_Find", a, dt);
if (!bNoFilterOutput)
{
for (int i = 0; i < i_oOutputFields.aOutputs.Count; i++)
{
dt.Columns[i_oOutputFields.aOutputs[i].sName].ColumnName = i_oOutputFields.aOutputs[i].ToString();
}
}
return(dt);
}
//---- SELECT список накладных или накладная
public void srv_select_ConsignmentList(cFilter filter)
{
client = OperationContext.Current.GetCallbackChannel<IDuplexClient>();
try
{
client.receiveConsignmentList( DataManager.sel_ConsignmentNote(filter) );
}
catch
{
client.receiveConsignmentList( null );
}
}
//---- SELECT список накладных или накладная
public void srv_select_ConsignmentList(cFilter filter)
{
client = OperationContext.Current.GetCallbackChannel <IDuplexClient>();
try
{
client.receiveConsignmentList(DataManager.sel_ConsignmentNote(filter));
}
catch
{
client.receiveConsignmentList(null);
}
}
//---- INSERT накладная
public void srv_work_Consignment(cConsignmentItem item, cFilter filter)
{
try
{
DataManager.ins_upd_ConsignmentNote(item);
client.notifyWorkConsignmentItem(1);
client.receiveConsignmentList(DataManager.sel_ConsignmentNote(filter));
}
catch
{
client.notifyWorkConsignmentItem(0);
}
}
//---- INSERT накладная
public void srv_work_Consignment(cConsignmentItem item,cFilter filter)
{
try
{
DataManager.ins_upd_ConsignmentNote(item);
client.notifyWorkConsignmentItem(1);
client.receiveConsignmentList(DataManager.sel_ConsignmentNote(filter));
}
catch
{
client.notifyWorkConsignmentItem(0);
}
}
/// <summary>
/// Finds and return cCountry objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cCountry objects</returns>
public static List <cCountry> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cCountry> l = new List <cCountry>();
cCountry oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cCountry();
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_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cFunctionalDepartment objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cFunctionalDepartment objects</returns>
public static List <cFunctionalDepartment> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cFunctionalDepartment> l = new List <cFunctionalDepartment>();
cFunctionalDepartment oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cFunctionalDepartment();
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_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cSummaryComments objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cSummaryComments objects</returns>
public static List <cSummaryComments> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cSummaryComments> l = new List <cSummaryComments>();
cSummaryComments oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cSummaryComments();
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_sDescription = Convert.ToString(dt.Rows[i]["sDescription"]);
oObj.m_objEmpLogin.iObjectID = Convert.ToInt32(dt.Rows[i]["objEmpLogin"].ToString());
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cEmpPersonalDetails objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cEmpPersonalDetails objects</returns>
public static List <cEmpPersonalDetails> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cEmpPersonalDetails> l = new List <cEmpPersonalDetails>();
cEmpPersonalDetails oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cEmpPersonalDetails();
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_sLastName = Convert.ToString(dt.Rows[i]["sLastName"]);
oObj.m_sGender = Convert.ToString(dt.Rows[i]["sGender"]);
oObj.m_sFatherName = Convert.ToString(dt.Rows[i]["sFatherName"]);
oObj.m_sMotherName = Convert.ToString(dt.Rows[i]["sMotherName"]);
oObj.m_sCurrAddress = Convert.ToString(dt.Rows[i]["sCurrAddress"]);
oObj.m_sPerAddress = Convert.ToString(dt.Rows[i]["sPerAddress"]);
oObj.m_sMartialStatus = Convert.ToString(dt.Rows[i]["sMartialStatus"]);
oObj.m_dtDOB = Convert.ToDateTime(dt.Rows[i]["dtDOB"]);
oObj.m_sGovtID = Convert.ToString(dt.Rows[i]["sGovtID"]);
oObj.m_sCity = Convert.ToString(dt.Rows[i]["sCity"]);
oObj.m_sState = Convert.ToString(dt.Rows[i]["sState"]);
oObj.m_sZipCode = Convert.ToString(dt.Rows[i]["sZipCode"]);
oObj.m_sCountry = Convert.ToString(dt.Rows[i]["sCountry"]);
oObj.m_sNationality = Convert.ToString(dt.Rows[i]["sNationality"]);
oObj.m_sPerContactNo = Convert.ToString(dt.Rows[i]["sPerContactNo"]);
oObj.m_sWorkTelp = Convert.ToString(dt.Rows[i]["sWorkTelp"]);
oObj.m_sPersoanlEmailID = Convert.ToString(dt.Rows[i]["sPersoanlEmailID"]);
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_objEmpLogin.iObjectID = Convert.ToInt32(dt.Rows[i]["objEmpLogin"].ToString());
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cPermissionEmpLogin objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cPermissionEmpLogin objects</returns>
public static List <cPermissionEmpLogin> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cPermissionEmpLogin> l = new List <cPermissionEmpLogin>();
cPermissionEmpLogin oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cPermissionEmpLogin();
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_objPermission.iObjectID = Convert.ToInt32(dt.Rows[i]["objPermission"].ToString());
oObj.m_objEmpLogin.iObjectID = Convert.ToInt32(dt.Rows[i]["objEmpLogin"].ToString());
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cManageGroup objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cManageGroup objects</returns>
public static List <cManageGroup> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cManageGroup> l = new List <cManageGroup>();
cManageGroup oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cManageGroup();
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_objFunctionalGroup.iObjectID = Convert.ToInt32(dt.Rows[i]["objFunctionalGroup"].ToString());
oObj.m_iReportingHead = Convert.ToInt32(dt.Rows[i]["iReportingHead"]);
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cFile objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cFile objects</returns>
public static List <cFile> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cFile> l = new List <cFile>();
cFile oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cFile();
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_sFileName = Convert.ToString(dt.Rows[i]["sFileName"]);
oObj.m_objEmpLogin.iObjectID = Convert.ToInt32(dt.Rows[i]["objEmpLogin"].ToString());
oObj.m_objCareerDevelopmentPlan.iObjectID = Convert.ToInt32(dt.Rows[i]["objCareerDevelopmentPlan"].ToString());
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cTimeSheetActivity objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cTimeSheetActivity objects</returns>
public static List <cTimeSheetActivity> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cTimeSheetActivity> l = new List <cTimeSheetActivity>();
cTimeSheetActivity oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cTimeSheetActivity();
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_objTimesheet.iObjectID = Convert.ToInt32(dt.Rows[i]["objTimesheet"].ToString());
oObj.m_objActivity.iObjectID = Convert.ToInt32(dt.Rows[i]["objActivity"].ToString());
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Returns the count of object matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter condition (WHERE clause)</param>
/// <returns>Total number of objects found matching the specified criteria</returns>
public static int Count(cFilter i_oFilter)
{
SecurityCheck((int)enQuadrantMeasure_Action.Find);
List <SqlParameter> a = new List <SqlParameter>();
a.Add(new SqlParameter("@sFilter", SqlDbType.VarChar, 8000));
if (i_oFilter == null)
{
a[a.Count - 1].Value = "";
}
else
{
a[a.Count - 1].Value = i_oFilter.ToSQL_WHERE_Clause(new cQuadrantMeasure());
}
DataTable dt = new DataTable();
dt.Columns.Add("iCount");
oDB.CallSPROC(m_oClass.sName + "_Count", a, dt);
return(Convert.ToInt32(dt.Rows[0]["iCount"]));
}
/// <summary>
/// Finds and return cQuadrantMeasureEnforce objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cQuadrantMeasureEnforce objects</returns>
public static List <cQuadrantMeasureEnforce> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cQuadrantMeasureEnforce> l = new List <cQuadrantMeasureEnforce>();
cQuadrantMeasureEnforce oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cQuadrantMeasureEnforce();
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_objEmpLogin.iObjectID = Convert.ToInt32(dt.Rows[i]["objEmpLogin"].ToString());
oObj.m_objFunctionalGroup.iObjectID = Convert.ToInt32(dt.Rows[i]["objFunctionalGroup"].ToString());
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
//---- SELECT накладной расширенный
public cConsignmentEx srv_select_ConsignmentEx(int?id, out string OpStatus)
{
cConsignmentEx C_Ex = new cConsignmentEx();
try
{
C_Ex.list_BacterialInsiminateClass = DataManager.sel_DatFromLists("BacterialInsiminateClassList");
C_Ex.list_Contractor = DataManager.sel_DatFromLists("ContractorList");
C_Ex.list_PurityGroup = DataManager.sel_DatFromLists("PurityGroupList");
C_Ex.list_Sort = DataManager.sel_DatFromLists("SortList");
C_Ex.list_Status = DataManager.sel_DatFromLists("StatusList");
if (id != null)
{
cFilter filter = new cFilter();
filter.ConsignmentNoteID = id;
C_Ex.CNote = DataManager.sel_ConsignmentNote(filter).ToList()[0];
}
else
{
C_Ex.CNote = new cConsignmentItem();
C_Ex.CNote.item_BacterialInsiminateClass = C_Ex.list_BacterialInsiminateClass[0];
C_Ex.CNote.item_Contractor = C_Ex.list_Contractor[0];
C_Ex.CNote.item_PurityGroup = C_Ex.list_PurityGroup[0];
C_Ex.CNote.item_Sort = C_Ex.list_Sort[0];
C_Ex.CNote.item_Status = C_Ex.list_Status[0];
}
OpStatus = "Операция выполнена успешно";
return(C_Ex);
}
catch (Exception err)
{
OpStatus = err.ToString();
return(null);
}
}
/// <summary>
/// Finds and return cExternalProjectHead objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cExternalProjectHead objects</returns>
public static List <cExternalProjectHead> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cExternalProjectHead> l = new List <cExternalProjectHead>();
cExternalProjectHead oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cExternalProjectHead();
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_sContactNo = Convert.ToString(dt.Rows[i]["sContactNo"]);
oObj.m_sEmailID = Convert.ToString(dt.Rows[i]["sEmailID"]);
oObj.m_objClient.iObjectID = Convert.ToInt32(dt.Rows[i]["objClient"].ToString());
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
/// <summary>
/// Finds and return cEmpEmergencyContact objects matching the specified criteria
/// </summary>
/// <param name="i_oFilter">Filter criteria (WHERE clause)</param>
/// <returns>cEmpEmergencyContact objects</returns>
public static List <cEmpEmergencyContact> Find(cFilter i_oFilter)
{
DataTable dt = Find_DataTable(i_oFilter, null);
List <cEmpEmergencyContact> l = new List <cEmpEmergencyContact>();
cEmpEmergencyContact oObj;
for (int i = 0; i < dt.Rows.Count; i++)
{
oObj = new cEmpEmergencyContact();
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_sRelationShip = Convert.ToString(dt.Rows[i]["sRelationShip"]);
oObj.m_sContactNo = Convert.ToString(dt.Rows[i]["sContactNo"]);
oObj.m_objEmpLogin.iObjectID = Convert.ToInt32(dt.Rows[i]["objEmpLogin"].ToString());
oObj.m_bIsActive = Convert.ToBoolean(dt.Rows[i]["bIsActive"]);
oObj.m_bInvalid = false;
l.Add(oObj);
}
return(l);
}
//---- SELECT накладной расширенный
public cConsignmentEx srv_select_ConsignmentEx(int? id, out string OpStatus)
{
cConsignmentEx C_Ex = new cConsignmentEx();
try
{
C_Ex.list_BacterialInsiminateClass = DataManager.sel_DatFromLists("BacterialInsiminateClassList");
C_Ex.list_Contractor = DataManager.sel_DatFromLists("ContractorList");
C_Ex.list_PurityGroup = DataManager.sel_DatFromLists("PurityGroupList");
C_Ex.list_Sort = DataManager.sel_DatFromLists("SortList");
C_Ex.list_Status = DataManager.sel_DatFromLists("StatusList");
if (id != null)
{
cFilter filter = new cFilter();
filter.ConsignmentNoteID = id;
C_Ex.CNote = DataManager.sel_ConsignmentNote(filter).ToList()[0];
}
else
{
C_Ex.CNote = new cConsignmentItem();
C_Ex.CNote.item_BacterialInsiminateClass = C_Ex.list_BacterialInsiminateClass[0];
C_Ex.CNote.item_Contractor = C_Ex.list_Contractor[0];
C_Ex.CNote.item_PurityGroup = C_Ex.list_PurityGroup[0];
C_Ex.CNote.item_Sort = C_Ex.list_Sort[0];
C_Ex.CNote.item_Status = C_Ex.list_Status[0];
}
OpStatus = "Операция выполнена успешно";
return C_Ex;
}
catch (Exception err)
{
OpStatus = err.ToString();
return null;
}
}
