public static CustomList <CmnWorkFlowMaster> GetAllCmnWorkFlowMasterFind()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList <CmnWorkFlowMaster> CmnWorkFlowMasterCollection = new CustomList <CmnWorkFlowMaster>();
IDataReader reader = null;
String sql = "spFindWorkFlow";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
CmnWorkFlowMaster newCmnWorkFlowMaster = new CmnWorkFlowMaster();
newCmnWorkFlowMaster.SetDataFind(reader);
CmnWorkFlowMasterCollection.Add(newCmnWorkFlowMaster);
}
return(CmnWorkFlowMasterCollection);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
CustomList<CmnWorkFlowMaster> lstCmnWorkFlowMaster = CmnWorkFlowMasterList;
if (lstCmnWorkFlowMaster.Count == 0)
{
CmnWorkFlowMaster newCmnWorkFlowMaster = new CmnWorkFlowMaster();
lstCmnWorkFlowMaster.Add(newCmnWorkFlowMaster);
}
SetDataFromControlToObj(ref lstCmnWorkFlowMaster);
CustomList<CmnWorkFlowDetail> lstCmnWorkFlowDetail = (CustomList<CmnWorkFlowDetail>)CmnWorkFlowDetailList;
if (!((PageBase)this.Page).CheckUserAuthentication(lstCmnWorkFlowMaster, lstCmnWorkFlowDetail)) return;
_manager.SaveWorkFlow(ref lstCmnWorkFlowMaster, ref lstCmnWorkFlowDetail);
txtWorkFlowID.Text = _manager.WorkFlowID.ToString();
((PageBase)this.Page).SuccessMessage = (StaticInfo.SavedSuccessfullyMsg);
}
catch (SqlException ex)
{
((PageBase)this.Page).ErrorMessage = (ExceptionHelper.getSqlExceptionMessage(ex));
}
catch (Exception ex)
{
((PageBase)this.Page).ErrorMessage = (ExceptionHelper.getExceptionMessage(ex));
}
}
private void PopulateWorkFlowMaster(CmnWorkFlowMaster objWF)
{
try
{
txtWorkFlowID.Text = objWF.WorkFlowID.ToString();
ddlCostCenter.SelectedValue = objWF.CostCenterID.ToString();
ddlDepartment.SelectedValue = objWF.DeptID.ToString();
ddlDocList.SelectedValue = objWF.DocListID.ToString();
txtSequence.Text = objWF.Sequence.ToString();
CmnWorkFlowDetailList = new CustomList<CmnWorkFlowDetail>();
CmnWorkFlowDetailList = _manager.GetAllCmnWorkFlowDetail(objWF.WorkFlowID);
}
catch (Exception ex)
{
throw (ex);
}
}
public static CustomList<CmnWorkFlowMaster> GetAllCmnWorkFlowMasterFind()
{
ConnectionManager conManager = new ConnectionManager(ConnectionName.HR);
CustomList<CmnWorkFlowMaster> CmnWorkFlowMasterCollection = new CustomList<CmnWorkFlowMaster>();
IDataReader reader = null;
String sql = "spFindWorkFlow";
try
{
conManager.OpenDataReader(sql, out reader);
while (reader.Read())
{
CmnWorkFlowMaster newCmnWorkFlowMaster = new CmnWorkFlowMaster();
newCmnWorkFlowMaster.SetDataFind(reader);
CmnWorkFlowMasterCollection.Add(newCmnWorkFlowMaster);
}
return CmnWorkFlowMasterCollection;
}
catch (Exception ex)
{
throw (ex);
}
finally
{
if (reader != null && !reader.IsClosed)
reader.Close();
}
}
