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(); } }