public Sections Get(long SectionID) { Employee_DL objEmployee_DL = new Employee_DL(Connection); SectionsCollec objSectionsCollec = new SectionsCollec(); try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@SectionID", SectionID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_Section_By_ID", paramList); Sections objSections = new Sections(); if (dt.Rows.Count > 0) { objSections.DepID = Convert.ToInt64(dt.Rows[0]["DepID"]); objSections.SectionHead = objEmployee_DL.Get(Convert.ToString(dt.Rows[0]["SuperviserID"])); objSections.SectionName = Convert.ToString(dt.Rows[0]["SectionName"]); objSections.SectionID = Convert.ToInt64(dt.Rows[0]["SectionID"]); } return(objSections); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public SectionsCollec Get() { Employee_DL objEmployee_DL = new Employee_DL(Connection); SectionsCollec objSectionsCollec = new SectionsCollec(); try { DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_Section"); for (int i = 0; i < dt.Rows.Count; i++) { Sections objSections = new Sections(); objSections.DepID = Convert.ToInt64(dt.Rows[i]["DepID"]); objSections.SectionHead = objEmployee_DL.Get(Convert.ToString(dt.Rows[i]["SuperviserID"])); objSections.SectionName = Convert.ToString(dt.Rows[i]["SectionName"]); objSections.SectionID = Convert.ToInt64(dt.Rows[i]["SectionID"]); objSectionsCollec.Add(objSections); } return(objSectionsCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }