//To Bind ParentGridBind #region [Parent Grid Bind] public DataSet ParentGridBind_BL(EWA_SendMessage objEWA) { try { DataSet ds = objDL.BindParentGrid_DL(objEWA); return(ds); } catch (Exception) { throw; } finally { objDL = null; } }
//To Bind EmployeeGrid #region [Bind Employee Grid] public DataSet BindEmployeeGrid_DL(EWA_SendMessage objEWA) { DataSet ds = new DataSet(); try { prmList = new string[10]; prmList[0] = "@Action"; prmList[1] = "SelectEmployee"; prmList[2] = "@OrgId"; prmList[3] = objEWA.OrgId; prmList[4] = "@DepartmentId"; prmList[5] = objEWA.DepartmentId; prmList[6] = "@DesignationTypeId"; prmList[7] = objEWA.DesignationTypeId; prmList[8] = "@DesignationId"; prmList[9] = objEWA.DesignationId; ds = ObjHelper.FillControl(prmList, "SP_SendSMS"); if (ds.Tables[0].Rows.Count > 0) { return(ds); } else { DataTable dt = new DataTable(); dt.Columns.Add("UserCode"); dt.Columns.Add("FullName"); dt.Columns.Add("Designation"); dt.Columns.Add("Mobile"); dt.Rows.Add(); dt.Rows.Add(); dt.Rows.Add(); dt.Rows.Add(); //return dsCode; } return(ds); } catch (Exception exp) { throw exp; } }
//To Bind ParentGrid #region [Bind Parent Grid] public DataSet BindParentGrid_DL(EWA_SendMessage objEWA) { DataSet ds = new DataSet(); try { prmList = new string[10]; prmList[0] = "@Action"; prmList[1] = "SelectParent"; prmList[2] = "@OrgId"; prmList[3] = objEWA.OrgId; prmList[4] = "@CourseId"; prmList[5] = objEWA.CourseId; prmList[6] = "@BranchId"; prmList[7] = objEWA.BranchId; prmList[8] = "@ClassId"; prmList[9] = objEWA.ClassId; ds = ObjHelper.FillControl(prmList, "SP_SendSMS"); if (ds.Tables[0].Rows.Count > 0) { return(ds); } else { DataTable dt = new DataTable(); dt.Columns.Add("UserCode"); dt.Columns.Add("FullName"); dt.Columns.Add("FatherName"); dt.Columns.Add("Mobile"); dt.Rows.Add(); dt.Rows.Add(); dt.Rows.Add(); dt.Rows.Add(); } return(ds); } catch (Exception exp) { throw exp; } }