//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;
}
}
