public void Load_Batches(Department objDep)
{
PRPDBatch.PRPDType TYPE1 = new PRPDBatch.PRPDType();
PRPDBatch.PRPDType TYPE2 = new PRPDBatch.PRPDType();
PRPDBatch.PRPDType TYPE3 = new PRPDBatch.PRPDType();
try
{
//if ((objDep.DepHead.EmployeeID == CurrentUser.EmployeeID)|(objDepartment_DL.GetBySectionID(((int)objEmployee_DL.Get(CurrentUser.EmployeeID).Section))).DepType=="PRPD")
//{
TYPE1 = PRPDBatch.PRPDType.PrimaryPreperation;
TYPE2 = PRPDBatch.PRPDType.PrimaryOutsource;
TYPE3 = PRPDBatch.PRPDType.Rework;
dtPRPDBatcByState = objPRPDBatch_DL.GetDataByStateAndType(PRPDBatch.PRPDBatchStatus.Approved, PRPDBatch.PRPDBatchStatus.Started,
TYPE1, TYPE2, TYPE3);
//}
if (dtPRPDBatcByState.Rows.Count != 0)
{
cmbPRPDBatchID.DataSource = dtPRPDBatcByState;
cmbPRPDBatchID.SelectedIndex = 0;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
public System.Data.DataTable GetDataByStateAndType(PRPDBatch.PRPDBatchStatus PRPDBatchStatus1, PRPDBatch.PRPDBatchStatus PRPDBatchStatus2,
PRPDBatch.PRPDType BatchType1, PRPDBatch.PRPDType BatchType2, PRPDBatch.PRPDType BatchType3)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@PRPDBatchType1", (int)BatchType1),
new SqlParameter("@PRPDBatchType2", (int)BatchType2),
new SqlParameter("@PRPDBatchType3", (int)BatchType3),
new SqlParameter("@BatchState1", (int)PRPDBatchStatus1),
new SqlParameter("@BatchState2", (int)PRPDBatchStatus2)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_PRPDBatchByTypeAndState", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
public System.Data.DataTable GetDataByState_Type(PRPDBatch.PRPDBatchStatus PRPDBatchStatus, PRPDBatch.PRPDType BatchType)
{
try
{
SqlParameter[] paramList = new SqlParameter[] {
new SqlParameter("@PRPDBatchStatus", (int)PRPDBatchStatus),
new SqlParameter("@BatchType", (int)BatchType)
};
return(Execute.RunSP_DataTable(Connection, "SPGET_PRPDBatch_View_Status_Type", paramList));
}
catch (Exception ex)
{
throw new Exception(ex.Message, ex);
}
}
