public static CustomList <AccReportConfigurationHead> GetAllAccReportConfigurationHead(Int32 ReportTypeID) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList <AccReportConfigurationHead> AccReportConfigurationHeadCollection = new CustomList <AccReportConfigurationHead>(); IDataReader reader = null; String sql = "Exec spGetHeadCategoryMap " + ReportTypeID; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { AccReportConfigurationHead newAccReportConfigurationHead = new AccReportConfigurationHead(); newAccReportConfigurationHead.SetData(reader); AccReportConfigurationHeadCollection.Add(newAccReportConfigurationHead); } return(AccReportConfigurationHeadCollection); } catch (Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) { reader.Close(); } } }
public static CustomList<AccReportConfigurationHead> GetAllAccReportConfigurationHead(Int32 ReportTypeID) { ConnectionManager conManager = new ConnectionManager(ConnectionName.HR); CustomList<AccReportConfigurationHead> AccReportConfigurationHeadCollection = new CustomList<AccReportConfigurationHead>(); IDataReader reader = null; String sql = "Exec spGetHeadCategoryMap "+ReportTypeID; try { conManager.OpenDataReader(sql, out reader); while (reader.Read()) { AccReportConfigurationHead newAccReportConfigurationHead = new AccReportConfigurationHead(); newAccReportConfigurationHead.SetData(reader); AccReportConfigurationHeadCollection.Add(newAccReportConfigurationHead); } return AccReportConfigurationHeadCollection; } catch(Exception ex) { throw (ex); } finally { if (reader != null && !reader.IsClosed) reader.Close(); } }
private void PopulateACCInformation(AccReportConfigurationHead accReportConfigurationHead) { try { if (accReportConfigurationHead.HeadCategoryID != 0) ddlHeadCategory.SelectedValue = accReportConfigurationHead.HeadCategoryID.ToString(); txtHead.Text = accReportConfigurationHead.HeadName; txtSequence.Text = accReportConfigurationHead.Sequence.ToString(); ddlOperator.SelectedValue = accReportConfigurationHead.OperationOperator; AccReportConfigurationHeadCOAMapList = hCM.GetAllAccReportConfigurationHeadCOAMap(accReportConfigurationHead.HeadID); } catch (Exception ex) { throw (ex); } }
protected void btnSave_Click(object sender, EventArgs e) { try { CustomList<AccReportConfigurationHead> lstAccReportConfigurationHead = AccReportConfigurationHeadList; if (lstAccReportConfigurationHead.Count == 0) { AccReportConfigurationHead newAccReportConfigurationHead = new AccReportConfigurationHead(); lstAccReportConfigurationHead.Add(newAccReportConfigurationHead); } SetDataFromControlToObj(ref lstAccReportConfigurationHead); CustomList<AccReportConfigurationHeadCOAMap> lstAccReportConfigurationHeadCOAMap = (CustomList<AccReportConfigurationHeadCOAMap>)AccReportConfigurationHeadCOAMapList; if (!CheckUserAuthentication(lstAccReportConfigurationHead, lstAccReportConfigurationHeadCOAMap)) return; hCM.SaveAccReportConfigurationHead(ref lstAccReportConfigurationHead, ref lstAccReportConfigurationHeadCOAMap); ((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)); } }