//Student Bind
#region [Student Bind]
public DataSet StudentBind_DL(EWA_UploadDocument ObjEWA)
{
try
{
prmList = new string[12];
prmList[0] = "@Action";
prmList[1] = ObjEWA.Action;
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;
prmList[8] = "@DivisionId";
prmList[9] = ObjEWA.DivisionId;
ds = ObjHelper.FillControl(prmList, "SP_UploadDocument");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
return(ds);
}
catch (Exception)
{
throw;
}
}
//To Bind EmployeeGrid
#region [Bind Employee Grid]
public DataSet BindEmployeeGrid_DL(EWA_AssignDeptDes objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[10];
prmList[0] = "@Action";
prmList[1] = objEWA.Action;
prmList[2] = "@OrgId";
prmList[3] = objEWA.OrgId.ToString();
prmList[4] = "@DesignationTypeId";
prmList[5] = objEWA.DesignationTypeId.ToString();
prmList[6] = "@DepartmentId";
prmList[7] = objEWA.DepartmentId.ToString();
prmList[8] = "@DesignationId";
prmList[9] = objEWA.DesignationId.ToString();
ds = ObjHelper.FillControl(prmList, "SP_EmpAssignDeptDes");
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//Student View Profile
#region [Student Id View]
public DataSet DL_ShowStudentViewProfile(EWA_StudentView objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[6];
prmList[0] = "@Action";
//Stored procedure Action value
prmList[1] = "SelectStudentICardView";
prmList[2] = "@OrgId";
prmList[3] = Convert.ToString(objEWA.OrgId);
prmList[4] = "@UserCode";
prmList[5] = Convert.ToString(objEWA.StudentID);
//Stored procedure name
ds = ObjHelper.FillControl(prmList, "SP_Student");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
}
return(ds);
}
catch (Exception)
{
// GeneralErr(exp.Message.ToString());
throw;
}
}
//Bind Supplier category
#region [Bind Supplier category]
public DataSet BindCategory_DL()
{
DataSet ds = new DataSet();
try
{
prmList = new string[2];
prmList[0] = "@Action";
prmList[1] = "FetchCategory";
//prmList[2] = "@OrgId";
//prmList[3] = Convert.ToString(objEWA.OrgId);
ds = ObjHelper.FillControl(prmList, "SP_Supplier");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//Show Faculty
#region [View Faculty]
public DataSet DL_ShowFacultyProfile(EWA_Faculty objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[6];
prmList[0] = "@Action";
//Stored procedure Action value
prmList[1] = "FacultyViewProfile";
prmList[2] = "@OrgId";
prmList[3] = Convert.ToString(objEWA.OrgId);
prmList[4] = "@UserCode";
prmList[5] = Convert.ToString(objEWA.StaffId);
//Stored procedure name
ds = ObjHelper.FillControl(prmList, "SP_Employee");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
return(null);
}
}
catch (Exception)
{
// GeneralErr(exp.Message.ToString());
throw;
}
}
//Bind Faculty Data
#region [Bind Faculty Data]
public DataSet DL_BindFacultyData(EWA_StaffView objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[8];
prmList[0] = "@Action";
prmList[1] = "GetEmployeeProfile";
prmList[2] = "@OrgId";
prmList[3] = objEWA.OrgId.ToString();
prmList[4] = "@DepartmentId";
prmList[5] = objEWA.DepartmentId;
prmList[6] = "@DesignationId";
prmList[7] = objEWA.Designation;
//Stored procedure name
ds = ObjHelper.FillControl(prmList, "SP_Employee");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
}
return(ds);
}
catch (Exception)
{
throw;
}
}
//To Bind DocumentGrid
#region [Bind Document Grid]
public DataSet BindAcademicYearGrid_DL(EWA_AcademicYear objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "SelectData";
prmList[2] = "@OrgId";
prmList[3] = Convert.ToString(objEWA.OrgId);
ds = ObjHelper.FillControl(prmList, "SP_AcademicYear");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("AcademicYear");
dt.Columns.Add("StartDate");
dt.Columns.Add("EndDate");
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
//return dsCode;
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
// Fatch Student
#region [Fatch Student]
public DataSet FatchStudent_DL(EWA_UploadResult ObjEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[6];
prmList[0] = "@Action";
prmList[1] = "FetchStudent";
prmList[2] = "@OrgId";
prmList[3] = ObjEWA.OrgId;
prmList[4] = "@UserCode";
prmList[5] = ObjEWA.UserCode;
ds = ObjHelper.FillControl(prmList, "SP_UploadResult");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//To Bind DocumentGrid
#region [Bind Sport Grid]
public DataSet BindSportGrid_DL()
{
DataSet ds = new DataSet();
try
{
prmList = new string[2];
prmList[0] = "@Action";
prmList[1] = "FetchDepartment";
ds = ObjHelper.FillControl(prmList, "SP_SportMaster");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("SportId");
dt.Columns.Add("SportName");
//dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
//return dsCode;
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//Bind Item Category
#region [Bind Item Category Grid]
public DataSet BindCategoryGrid_DL(EWA_Category objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "SelectData";
prmList[2] = "OrgId";
prmList[3] = objEWA.OrgId.ToString();
ds = ObjHelper.FillControl(prmList, "SP_Category");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("CategoryName");
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
//return dsCode;
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//Get MaxStudentId
#region [Max Student Id]
public DataSet GetStudentCode_DL(EWA_Student objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "GetStudCode";
prmList[2] = "@OrgId";
prmList[3] = Convert.ToString(objEWA.OrgId);
ds = ObjHelper.FillControl(prmList, "SP_Student");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
return(ds);
}
catch (Exception)
{
//GeneralErr(exp.Message.ToString());
throw;
}
}
//To Bind CountryGrid
#region [Bind Country Grid]
public DataSet BindCountryGrid_DL(EWA_CountryStateDistrict objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[2];
prmList[0] = "@Action";
prmList[1] = objEWA.Action;
ds = ObjHelper.FillControl(prmList, "SP_CountryStateDistrict");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("CountryId");
dt.Columns.Add("CountryName");
//dt.Rows.Add();
//dt.Rows.Add();
//dt.Rows.Add();
//return dsCode;
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
public DataSet GetBookGroup_DL(EWA_AddBookGroup objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "GetData";
prmList[2] = "@OrgId";
prmList[3] = objEWA.OrgId.ToString();
ds = ObjHelper.FillControl(prmList, "SP_LibAddGroup");
if (ds.Tables[0].Rows.Count <= 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("GroupId");
dt.Columns.Add("GroupCode");
dt.Columns.Add("GroupName");
//dt.Rows.Add();
//dt.Rows.Add();
//dt.Rows.Add();
//ds.Tables.RemoveAt(0);
//ds.Tables.Add(dt);
}
}
catch (Exception ex)
{
}
return(ds);
}
// Bind Grid of StudentData_DL
#region [Bind Student Data Region]
public DataSet BindStudentData_DL(EWA_PayFees objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[8];
prmList[0] = "@Action";
prmList[1] = "FetchStudentToPayFees";
prmList[2] = "@AdmissionId";
prmList[3] = objEWA.AdmissionId;
prmList[4] = "@OrgId";
prmList[5] = Convert.ToString(objEWA.OrgId);
prmList[6] = "@AcademicId";
prmList[7] = objEWA.AcadmicYearId.ToString();
//prmList[7] = HttpContext.Current.Session["AcademicYearId"].ToString();
ds = ObjHelper.FillControl(prmList, "SP_PayFees");
return(ds);
}
catch (Exception ex)
{
throw;
}
}
//To Bind HolidayGrid
#region [Bind Holiday Grid]
public DataSet HolidayGridBind_DL(EWA_Holiday objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = objEWA.Action;
prmList[2] = "@OrgID";
prmList[3] = objEWA.OrgId;
ds = ObjHelper.FillControl(prmList, "SP_Holiday");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
return(null);
}
}
catch (Exception)
{
// GeneralErr(exp.Message.ToString());
throw;
}
}
//Bind Item Category
#region [Bind Item Grid]
public DataSet BindItemGrid_DL()
{
DataSet ds = new DataSet();
try
{
prmList = new string[2];
prmList[0] = "@Action";
prmList[1] = "SelectData";
ds = ObjHelper.FillControl(prmList, "SP_StockView");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("ItemName");
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
//return dsCode;
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
public DataSet DL_GetData(EWA_Dashbord objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "GetDashBordData";
prmList[2] = "@OrgID";
prmList[3] = objEWA.OrgId.ToString();
ds = ObjHelper.FillControl(prmList, "SP_ChartData");
if (ds.Tables[0].Rows.Count > 0 || ds.Tables[1].Rows.Count > 0)
{
return(ds);
}
else
{
ds = null;
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//Bind Grid Data
#region [Bind Grid Data]
public DataSet BindGridData_DL(EWA_ComposeMessage ObjEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[14];
prmList[0] = "@Action";
prmList[1] = ObjEWA.Action;
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;
prmList[10] = "@DepartmentId";
prmList[11] = ObjEWA.DepartmentId;
prmList[12] = "@DesignationId";
prmList[13] = ObjEWA.DesignationId;
ds = ObjHelper.FillControl(prmList, "SP_SMS");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
return(ds);
}
catch (Exception)
{
throw;
}
}
//To Bind EmployeeGrid
#region [BindEmployeeGrid]
public DataSet BindEmployeeGrid_DL(EWA_EmpAssignSubject objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[14];
prmList[0] = "@Action";
prmList[1] = objEWA.Action;
prmList[2] = "@OrgId";
prmList[3] = objEWA.OrgId.ToString();
prmList[4] = "@DesignationTypeId";
prmList[5] = objEWA.DesignationTypeId.ToString();
prmList[6] = "@CourseId";
prmList[7] = objEWA.CourseId;
prmList[8] = "@ClassId";
prmList[9] = objEWA.ClassId;
prmList[10] = "@SubjectId";
prmList[11] = objEWA.SubjectId;
prmList[12] = "@BranchId";
prmList[13] = objEWA.BranchId;
ds = ObjHelper.FillControl(prmList, "SP_EmpAssignSubject");
//if (ds.Tables[0].Rows.Count > 0)
//{
// return ds;
//}
//else
//{
// DataTable dt = new DataTable();
// dt.Columns.Add("UserCode");
// dt.Columns.Add("SubjectCode");
// dt.Columns.Add("SubjectName");
// dt.Rows.Add();
// dt.Rows.Add();
// dt.Rows.Add();
// //return dsCode;
//}
return(ds);
}
catch (Exception)
{
// GeneralErr(exp.Message.ToString());
throw;
}
}
//To Bind Usercode
#region BindUsercode
public DataSet BindUsercode_DL(EWA_LC objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[8];
prmList[0] = "@Action";
prmList[1] = "GetStudentUsercode";
prmList[2] = "@ClassId";
prmList[3] = objEWA.ClassId;
prmList[4] = "@DivisionId";
prmList[5] = objEWA.DivisionId;
prmList[6] = "@OrgId";
prmList[7] = objEWA.OrgId;
ds = ObjHelper.FillControl(prmList, "SP_LeavingCertificate");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
}
catch (Exception ex)
{
throw ex;
}
return(ds);
}
//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;
}
}
// Bind Reports Header
#region [Bind Reports Header]
public DataSet DL_BindReportsHeader(EWA_CommonReports objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@ViewName";
prmList[1] = objEWA.ViewName;
prmList[2] = "@OrgId";
prmList[3] = Convert.ToString(objEWA.OrgId);
ds = ObjHelper.FillControl(prmList, "SP_GetReportData");
return(ds);
}
catch (Exception ex)
{
throw ex;
}
}
//To Bind DeviceGrid
#region [Bind Device Grid]
public DataSet BindDeviceGrid_DL(EWA_DeviceSetting objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "SelectData";
prmList[2] = "@OrgId";
prmList[3] = objEWA.OrgId;
ds = ObjHelper.FillControl(prmList, "SP_DeviceSetting");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("DeviceSettingId");
dt.Columns.Add("DeviceName");
dt.Columns.Add("IP");
dt.Columns.Add("PortNo");
dt.Columns.Add("MachineId");
dt.Columns.Add("Description");
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
//To Bind LeaveGrid
#region [Bind Leave Grid]
public DataSet BindLeaveTypeGrid_DL(EWA_LeaveType objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[6];
prmList[0] = "@Action";
prmList[1] = "SelectData";
prmList[2] = "@OrgId";
prmList[3] = "1";
prmList[4] = "@UserId";
prmList[5] = "1";
ds = ObjHelper.FillControl(prmList, "SP_Leave");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("LeaveId");
dt.Columns.Add("LeaveName");
dt.Columns.Add("LeaveCode");
dt.Columns.Add("LeaveCount");
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
return(null);
}
}
catch (Exception)
{
// GeneralErr(exp.Message.ToString());
throw;
}
}
public DataSet GetBook_DL(EWA_AddBook objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "GetData";
prmList[2] = "OrgId";
prmList[3] = objEWA.OrgId.ToString();
ds = ObjHelper.FillControl(prmList, "SP_LibAddBook");
if (ds.Tables[0].Rows.Count <= 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("BookId");
dt.Columns.Add("BookCode");
dt.Columns.Add("BookName");
dt.Columns.Add("GroupId");
dt.Columns.Add("GroupName");
dt.Columns.Add("Publisher");
//dt.Columns.Add("barcode");
dt.Columns.Add("Author");
dt.Columns.Add("PublishingYear");
dt.Columns.Add("Edition");
dt.Columns.Add("Price");
dt.Columns.Add("qty");
//dt.Rows.Add();
//dt.Rows.Add();
//dt.Rows.Add();
//ds.Tables.RemoveAt(0);
//ds.Tables.Add(dt);
}
}
catch (Exception ex)
{
}
return(ds);
}
//Get GetPOCode
#region [Max POCode Code]
public DataSet GetPOCode_DL(EWA_QualityControl objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[6];
prmList[0] = "@Action";
prmList[1] = "GetPOCode";
prmList[2] = "@POCode";
prmList[3] = objEWA.PreText;
prmList[4] = "@OrgId";
prmList[5] = Convert.ToString(objEWA.OrgId);
ds = ObjHelper.FillControl(prmList, "SP_QualityControl");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
return(ds);
}
catch (Exception exp)
{
throw exp;
}
}
public DataSet GetTimeSlotData(EWA_TimeSlotMaster objEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[4];
prmList[0] = "@Action";
prmList[1] = "GetData";
prmList[2] = "@OrgId";
prmList[3] = Convert.ToString(objEWA.OrgId);
ds = ObjHelper.FillControl(prmList, "SP_TimeSlot");
if (ds.Tables[0].Rows.Count <= 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("SlotId");
dt.Columns.Add("TimeSlot");
dt.Columns.Add("SlotFrom");
dt.Columns.Add("SlotTo");
dt.Columns.Add("SlotType");
dt.Columns.Add("SlotTypeStr");
dt.Rows.Add();
dt.Rows.Add();
dt.Rows.Add();
ds.Tables.RemoveAt(0);
ds.Tables.Add(dt);
//return dsCode;
}
return(ds);
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
}
}
//Get Role
#region [Get Role]
public DataSet GetRole_DL(EWA_Role ObjEWA)
{
DataSet ds = new DataSet();
try
{
prmList = new string[6];
prmList[0] = "@Action";
prmList[1] = "GetRole";
prmList[2] = "@OrganizationId";
prmList[3] = ObjEWA.OrganizationId.ToString();
prmList[4] = "@UserType";
prmList[5] = ObjEWA.UserType;
ds = ObjHelper.FillControl(prmList, "SP_Role");
return(ds);
}
catch (Exception)
{
throw;
}
}
//To Bind UniversityGrid
#region [Bind Document Grid]
public DataSet BindUniversityGrid_DL()
{
DataSet ds = new DataSet();
try
{
prmList = new string[2];
prmList[0] = "@Action";
prmList[1] = "SelectData";
ds = ObjHelper.FillControl(prmList, "SP_University");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add("UniversityId");
dt.Columns.Add("UniversityName");
dt.Columns.Add("Address");
dt.Columns.Add("Country");
dt.Columns.Add("State");
dt.Rows.Add("City");
dt.Rows.Add("PinCode");
dt.Rows.Add("Email");
dt.Columns.Add("ContactNo");
dt.Columns.Add("FaxNo");
//return dsCode;
return(null);
}
}
catch (Exception ex)
{
// GeneralErr(exp.Message.ToString());
throw;
}
}
//Get Message Id
#region [Get Message Id]
public DataSet Get_MessageId()
{
DataSet ds = new DataSet();
try
{
prmList = new string[2];
prmList[0] = "@Action";
prmList[1] = "GetMaxMessageId";
ds = ObjHelper.FillControl(prmList, "SP_SendMessage");
if (ds.Tables[0].Rows.Count > 0)
{
return(ds);
}
return(ds);
}
catch (Exception)
{
//GeneralErr(exp.Message.ToString());
throw;
}
}