protected void btnGo_Click(object sender, EventArgs e) { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.OrgId = ddlorganization.SelectedValue;//Session["OrgId"].ToString(); objEWA.BranchId = ddlBranch.SelectedValue.ToString(); objEWA.CourseId = ddlCourse.SelectedValue.ToString(); objEWA.ClassId = ddlClass.SelectedValue.ToString(); objEWA.date = txtDate.Text; // Convert.ToDateTime((Convert.ToDateTime(txtDate.Text.ToString()).ToShortDateString())).ToString("dd/MM/yyyy"); DataSet ds = objBL.BindStudentAttendance_BL(objEWA); if (ds.Tables[0].Rows.Count > 0) { grdStudentAtten.DataSource = ds; grdStudentAtten.DataBind(); //grdStudentAtten.ControlStyle.Width = 90; //grdStudentAtten.CellPadding = 20; } else { grdStudentAtten.DataSource = ds; grdStudentAtten.DataBind(); GeneralErr("No Record Present...!"); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Bind Division #region [Bind Division] private void BindDivision() { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.ClassId = ddlClass.SelectedValue.ToString(); if (!objEWA.ClassId.Equals("Select")) { DataSet ds = objBL.BindDivision_BL(objEWA); ddlDivision.DataSource = ds; ddlDivision.DataTextField = "DivisionName"; ddlDivision.DataValueField = "DivisionId"; ddlDivision.DataBind(); } else { ddlDivision.Items.Clear(); } ddlDivision.Items.Insert(0, new ListItem("Select", "Select")); ShowEmptyGridView(GrdSender); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
private void BindClass() { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.BranchId = ddlBranch.SelectedValue.ToString(); if (!objEWA.BranchId.Equals("Select")) { DataSet ds = objBL.BindClass_BL(objEWA); ddlClass.DataSource = ds; if (ds.Tables[0].Rows.Count != 0) { ddlClass.DataTextField = "ClassName"; ddlClass.DataValueField = "ClassId"; ddlClass.DataBind(); } else { ddlClass.Items.Clear(); } } else { ddlClass.Items.Clear(); } ddlClass.Items.Insert(0, new ListItem("Select", "0")); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Bind Branch #region [Bind Branch] private void BindBranch() { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.CourseId = ddlCourse.SelectedValue.ToString(); if (!objEWA.CourseId.Equals("Select")) { DataSet ds = objBL.BindBranch_BL(objEWA); ddlBranch.DataSource = ds; ddlBranch.DataTextField = "BranchName"; ddlBranch.DataValueField = "BranchId"; ddlBranch.DataBind(); } else { ddlBranch.Items.Clear(); } ddlBranch.Items.Insert(0, new ListItem("Select", "Select")); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Bind Student Grid Data #region [Bind Student Grid Data] private void BindStudentGridData() { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.OrgId = Session["OrgId"].ToString(); objEWA.CourseId = ddlCourse.SelectedValue.ToString(); objEWA.BranchId = ddlBranch.SelectedValue.ToString(); objEWA.ClassId = ddlClass.SelectedValue.ToString(); objEWA.DivisionId = ddlDivision.SelectedValue.ToString(); DataSet ds = objBL.BindStudentData_BL(objEWA); if (ds.Tables[0].Rows.Count != 0) { GrdSender.DataSource = ds; GrdSender.DataBind(); GrdSender.Columns[2].Visible = true; dsGrdSender = ds.Copy(); } else { ShowEmptyGridView(GrdSender); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
private void BindCourse() { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.OrgId = Session["OrgId"].ToString(); DataSet ds = objBL.BindCourses_BL(objEWA); ddlCourse.DataSource = ds; ddlCourse.DataTextField = "CourseName"; ddlCourse.DataValueField = "CourseId"; ddlCourse.DataBind(); ddlCourse.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0")); ddlBranch.Items.Clear(); ddlClass.Items.Clear(); ddlBranch.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0")); ddlClass.Items.Insert(0, new System.Web.UI.WebControls.ListItem("Select", "0")); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Class Changed #region [Class Changed] protected void ddlClass_SelectedIndexChanged(object sender, EventArgs e) { try { EWA_Common ObjEWA = new EWA_Common(); BL_Common ObjBL = new BL_Common(); ObjEWA.OrgId = Session["OrgId"].ToString(); ObjEWA.CourseId = ddlCourse.SelectedValue.ToString(); ObjEWA.ClassId = ddlClass.SelectedValue.ToString(); DataSet ds = ObjBL.BindSubject_BL(ObjEWA); if (ds.Tables[0].Rows.Count != 0) { ddlSubject.DataSource = ds; ddlSubject.DataTextField = "SubjectName"; ddlSubject.DataValueField = "SubjectId"; ddlSubject.DataBind(); } else { ddlSubject.Items.Clear(); } ddlSubject.Items.Insert(0, "Select"); ddlSubject.SelectedIndex = 0; ShowEmptyGridView(GrdEmployee); ShowEmptyGridView(GrdViewEmployee); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
public DataSet BindAssigned_Subject_DL(EWA_Common ObjEWA) { DataSet ds = new DataSet(); try { prmList = new string[12]; prmList[0] = "@Action"; prmList[1] = "Fetch_Assigned_Subject"; prmList[2] = "@OrgId"; prmList[3] = ObjEWA.OrgId; prmList[4] = "@UserCode"; prmList[5] = ObjEWA.UserCode; prmList[6] = "@CourseId"; prmList[7] = ObjEWA.CourseId; prmList[8] = "@BranchId"; prmList[9] = ObjEWA.BranchId; prmList[10] = "@ClassId"; prmList[11] = ObjEWA.ClassId; ds = ObjHelper.FillControl(prmList, "SP_Common"); } catch (Exception exp) { //throw exp; } return(ds); }
// Bind Designation BindDesignation_DL #region [Bind Designation Region] public DataSet BindDesignation_DL(EWA_Common ObjEWA) { DataSet ds = new DataSet(); try { prmList = new string[6]; prmList[0] = "@Action"; prmList[1] = "FetchDesignation"; prmList[2] = "@DesignationTypeId"; prmList[3] = ObjEWA.DesignationTypeId; prmList[4] = "@DepartmentId"; prmList[5] = ObjEWA.DepartmentId; ds = ObjHelper.FillControl(prmList, "SP_Common"); if (ds.Tables[0].Rows.Count > 0) { return(ds); } return(ds); } catch (Exception exp) { throw exp; } }
public DataSet Bind_AdmissionCompleted_DL(EWA_Common ObjEWA) { DataSet ds = new DataSet(); try { prmList = new string[12]; prmList[0] = "@Action"; prmList[1] = "FetchAdmission_Completed"; prmList[2] = "@OrgId"; prmList[3] = ObjEWA.OrgId.ToString(); prmList[4] = "@CourseId"; prmList[5] = ObjEWA.CourseId.ToString(); prmList[6] = "@BranchId"; prmList[7] = ObjEWA.BranchId.ToString(); prmList[8] = "@ClassId"; prmList[9] = ObjEWA.ClassId.ToString(); prmList[10] = "@Status"; prmList[11] = ObjEWA.Status; ds = ObjHelper.FillControl(prmList, "SP_Common"); if (ds.Tables[0].Rows.Count > 0) { return(ds); } return(ds); } catch (Exception exp) { throw exp; } }
// Bind Grid of StudentData_DL #region [Bind Student Data Region] public DataSet BindStudentData_DL(EWA_Common objEWA) { DataSet ds = new DataSet(); try { prmList = new string[10]; prmList[0] = "@Action"; prmList[1] = "FetchStudent"; prmList[2] = "@CourseId"; prmList[3] = objEWA.CourseId; prmList[4] = "@ClassId"; prmList[5] = objEWA.ClassId; prmList[6] = "@OrgId"; prmList[7] = objEWA.OrgId; prmList[8] = "@BranchId"; prmList[9] = objEWA.BranchId; // prmList[10] = "@DivisionId"; //prmList[11] = objEWA.DivisionId; ds = ObjHelper.FillControl(prmList, "SP_Common"); return(ds); } catch (Exception exp) { throw exp; } }
//Added by ashwini 23-Oct-2020 public DataSet GetStudentListFilterWise(EWA_Common ObjEWA) { DataSet ds = new DataSet(); try { prmList = new string[6]; prmList[0] = "@Criteria"; prmList[1] = ObjEWA.Criteria; prmList[2] = "@CriteriaValue"; prmList[3] = ObjEWA.CriteriaValue; prmList[4] = "@Action"; prmList[5] = "GetStudentListFilterWise"; ds = ObjHelper.FillControl(prmList, "SP_GetAdmissionStatusByStudent"); if (ds.Tables[0].Rows.Count > 0) { return(ds); } return(ds); } catch (Exception exp) { throw exp; } }
//Bind Subject #region [Bind Subjects] private void BindSubject() { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.CourseId = ddlCourses.SelectedValue; objEWA.BranchId = ddlBranches.SelectedValue; objEWA.ClassId = ddlClasses.SelectedValue; objEWA.OrgId = Session["OrgId"].ToString(); objEWA.UserCode = Session["Username"].ToString(); DataSet ds = objBL.BindAssigned_Subject_BL(objEWA); ddlSelectSubject.DataSource = ds; ddlSelectSubject.DataTextField = "SubjectName"; ddlSelectSubject.DataValueField = "SubjectId"; ddlSelectSubject.DataBind(); ddlSelectSubject.Items.Insert(0, new ListItem("Select", "0")); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Bind Class #region [Bind Class] private void BindClass(DropDownList ddlBranch, DropDownList ddlClass) { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.BranchId = ddlBranch.SelectedValue.ToString(); if (!objEWA.BranchId.Equals("-1")) { objEWA.OrgId = Session["OrgId"].ToString();// Session["OrgId"].ToString(); DataSet ds = objBL.BindClass_BL(objEWA); ddlClass.DataSource = ds; ddlClass.DataTextField = "ClassName"; ddlClass.DataValueField = "ClassId"; ddlClass.DataBind(); ddlClass.Items.Insert(0, new ListItem("Select", "-1")); } else { ddlClass.Items.Clear(); ddlClass.Items.Insert(0, new ListItem("Select", "-1")); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
private void BindDesignation() { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.OrgId = Session["OrgId"].ToString(); objEWA.DepartmentId = DDL_Department.SelectedValue.ToString(); objEWA.DesignationTypeId = rbtnFacultyType.SelectedItem.Value; //RadioButtonList rbtnList = Page.FindControl("rbtnFacultyType") as RadioButtonList; //string str= rbtnList.SelectedValue; DataSet ds = objBL.BindDesignation_BL(objEWA); DDL_Designation.DataSource = ds; DDL_Designation.DataTextField = "DesignationName"; DDL_Designation.DataValueField = "DesignationId"; DDL_Designation.DataBind(); DDL_Designation.Items.Insert(0, "Select"); DDL_Designation.SelectedIndex = 0; DDL_Designation.DataSource = null; DDL_Designation.DataBind(); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
public DataSet BindTimeTable_DL(EWA_Common ObjEWA) { DataSet ds = new DataSet(); try { prmList = new string[12]; prmList[0] = "@Action"; prmList[1] = "GetTimeTable_HomeWork"; 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] = "@Date"; prmList[11] = ObjEWA.date; ds = ObjHelper.FillControl(prmList, "SP_TimeTableCreationAction"); if (ds.Tables[0].Rows.Count > 0 || ds.Tables[1].Rows.Count > 0) { return(ds); } return(ds); } catch (Exception exp) { throw exp; } }
private void BindBranch() { try { EWA_Common objEWA = new EWA_Common(); DL_Common objDL = new DL_Common(); objEWA.CourseId = ddlCourse.SelectedValue.ToString(); DataSet ds = objDL.BindBranch_DL(objEWA); ddlBranch.DataSource = ds; ddlBranch.DataTextField = "BranchName"; ddlBranch.DataValueField = "BranchId"; ddlBranch.DataBind(); ddlBranch.Items.Insert(0, new ListItem("Select", "0")); ddlClass.Items.Clear(); ddlClass.Items.Insert(0, new ListItem("---Select---", "0")); ddlDivision.Items.Clear(); ddlDivision.Items.Insert(0, new ListItem("---Select---", "0")); } catch (Exception exp) { throw exp; } }
public DataSet BindStudentAttendance_DL(EWA_Common ObjEWA) { DataSet ds = new DataSet(); try { prmList = new string[12]; prmList[0] = "@Action"; prmList[1] = "CountAttendace"; 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] = "@AttendanceDate"; prmList[11] = ObjEWA.date; ds = ObjHelper.FillControl(prmList, "SP_StudentAttendance"); return(ds); } catch (Exception exp) { throw exp; } }
private void bindData() { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.OrgId = Session["OrgId"].ToString(); DataSet ds = objBL.BindFeeStructure(objEWA); if (ds.Tables[0].Rows.Count > 0) { GRDFee.DataSource = ds; GRDFee.DataBind(); } else { GRDFee.DataSource = null; GRDFee.DataBind(); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
public DataSet BindResultFormat_DL(EWA_Common ObjEWA) { DataSet ds = new DataSet(); try { prmList = new string[10]; prmList[0] = "@Action"; prmList[1] = "FetchResultFormat"; 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] = "@SemesterId"; //prmList[11] = ObjEWA.SemesterId; ds = ObjHelper.FillControl(prmList, "SP_Common"); return(ds); } catch (Exception exp) { throw exp; } }
private void BindSemester() { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); //objEWA.OrgId = Session["OrgId"].ToString(); //objEWA.CourseId = ddlCourse.SelectedValue.ToString(); //objEWA.BranchId = ddlBranch.SelectedValue.ToString(); objEWA.ClassId = ddlClass.SelectedValue.ToString(); DataSet ds = objBL.BindSemester_BL(objEWA); ddlSemester.DataSource = ds; if (ds.Tables[0].Rows.Count != 0) { ddlSemester.DataTextField = "SemesterName"; ddlSemester.DataValueField = "SemesterId"; ddlSemester.DataBind(); } else { ddlSemester.Items.Clear(); } ddlSemester.Items.Insert(0, new ListItem("Select", "0")); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Fetch Staff with Filters #region [Fetch Staff with FiltersRegion] public DataSet DL_BindFacultyName(EWA_Common objEWA) { DataSet ds = new DataSet(); try { prmList = new string[10]; prmList[0] = "@Action"; prmList[1] = "GetFacultyName"; prmList[2] = "@DesignationId"; prmList[3] = objEWA.DesignationId; prmList[4] = "@DepartmentId"; prmList[5] = objEWA.DepartmentId; prmList[6] = "@DesignationTypeId"; prmList[7] = objEWA.DesignationTypeId; prmList[8] = "@OrgId"; prmList[9] = objEWA.OrgId; ds = ObjHelper.FillControl(prmList, "SP_Common"); return(ds); } catch (Exception exp) { throw exp; } }
//protected void ddlClass_SelectedIndexChanged(object sender, EventArgs e) //{ // string senderType=rbtnSender.SelectedValue.ToString(); // if (senderType.Equals("Student")) // { // BindStudentGridData(); // } //} //Bind Staff Grid Data #region [Bind Staff Grid Data] private void BindStaffGridData() { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.OrgId = Session["OrgId"].ToString(); objEWA.UserCode = Session["UserCode"].ToString(); objEWA.DesignationId = ddlDesignation.SelectedValue.ToString(); objEWA.DepartmentId = ddlDepartment.SelectedValue.ToString(); DataSet ds = objBL.BindFacultyData_BL(objEWA); if (ds.Tables[0].Rows.Count != 0) { GrdFacultySender.DataSource = ds; GrdFacultySender.DataBind(); GrdFacultySender.Columns[2].Visible = true; dsGrdFacultySender = ds.Copy(); } else { ShowEmptyGridView(GrdFacultySender); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
//Added by Ashwini 25-sep-2020 public DataSet GetAllFeesData(EWA_Common ObjEWA) { DataSet ds = new DataSet(); try { prmList = new string[8]; prmList[0] = "@OrgId"; prmList[1] = ObjEWA.OrgId.ToString(); prmList[2] = "@addmissionId"; prmList[3] = ObjEWA.addmissionId.ToString(); prmList[4] = "@StudId"; prmList[5] = ObjEWA.StudId.ToString(); prmList[6] = "@Course"; prmList[7] = ObjEWA.course.ToString(); ds = ObjHelper.FillControl(prmList, "SP_GetAllDataAboutFeesForUpgradeStudent"); if (ds.Tables[0].Rows.Count > 0) { return(ds); } return(ds); } catch (Exception exp) { throw exp; } }
//Bind Designation #region [Bind Designation] private void BindDesignation(String strFacultyType) { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.OrgId = Session["OrgId"].ToString(); objEWA.DepartmentId = ddlDepartment.SelectedValue.ToString(); objEWA.DesignationTypeId = strFacultyType; DataSet ds = objBL.BindDesignation_BL(objEWA); ddlDesignation.DataSource = ds; ddlDesignation.DataTextField = "DesignationName"; ddlDesignation.DataValueField = "DesignationId"; ddlDesignation.DataBind(); ddlDesignation.Items.Insert(0, "Select"); ddlDesignation.SelectedIndex = 0; GrdFacultySender.DataSource = null; GrdFacultySender.DataBind(); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
// Bind Courses BindCourses_DL #region [Bind Course Region] public DataSet BindCourses_DL(EWA_Common ObjEWA) { DataSet ds = new DataSet(); try { prmList = new string[4]; prmList[0] = "@Action"; prmList[1] = "FetchCourses"; prmList[2] = "@OrgId"; prmList[3] = ObjEWA.OrgId.ToString(); //prmList[4] = "@CourseId"; //prmList[5] = ObjEWA.CourseId.ToString(); ds = ObjHelper.FillControl(prmList, "SP_Common"); if (ds.Tables[0].Rows.Count > 0) { return(ds); } return(ds); } catch (Exception exp) { throw exp; } }
private void BindBranch() { try { EWA_Common objEWA = new EWA_Common(); DL_Common objDL = new DL_Common(); objEWA.CourseId = ddlCourse.SelectedValue.ToString(); DataSet ds = objDL.BindBranch_DL(objEWA); if (ds.Tables[0].Rows.Count != 0) { ddlBranch.DataSource = ds; ddlBranch.DataTextField = "BranchName"; ddlBranch.DataValueField = "BranchId"; ddlBranch.DataBind(); } else { ddlBranch.Items.Clear(); } ddlBranch.Items.Insert(0, new ListItem("Select", "0")); } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
// //Added by Ashwini 26-sep-2020 public DataSet GetBusFeesDetails(EWA_Common ObjEWA) { DataSet ds = new DataSet(); try { prmList = new string[10]; prmList[0] = "@StudId"; prmList[1] = ObjEWA.StudId.ToString(); prmList[2] = "@CourseId"; prmList[3] = ObjEWA.CourseId.ToString(); prmList[4] = "@ClassId"; prmList[5] = ObjEWA.ClassId.ToString(); prmList[6] = "@BranchId"; prmList[7] = ObjEWA.BranchId.ToString(); prmList[8] = "@AcademicYear"; prmList[9] = ObjEWA.AcademicYear.ToString(); ds = ObjHelper.FillControl(prmList, "SP_GetAllDataAboutBusFeesForUpgradeStudent"); if (ds.Tables[0].Rows.Count > 0) { return(ds); } return(ds); } catch (Exception exp) { throw exp; } }
protected void btnGo_Click(object sender, EventArgs e) { try { EWA_Common objEWA = new EWA_Common(); BL_Common objBL = new BL_Common(); objEWA.OrgId = ddlorganization.SelectedValue;//Session["OrgId"].ToString(); objEWA.BranchId = ddlBranch.SelectedValue.ToString(); objEWA.CourseId = ddlCourse.SelectedValue.ToString(); objEWA.ClassId = ddlClass.SelectedValue.ToString(); objEWA.date = Convert.ToDateTime(txtDate.Text.ToString()).ToShortDateString(); DataSet ds = objBL.BindTimeTable_BL(objEWA); if (ds.Tables[0].Rows.Count > 0) { bindGridView(ds); } else { msgBox.ShowMessage("Record not found", "Information", UserControls.MessageBox.MessageStyle.Critical); } } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }
private void BindSubject() { try { EWA_Common ObjEWA = new EWA_Common(); BL_Common ObjBL = new BL_Common(); ObjEWA.OrgId = Session["OrgId"].ToString(); ObjEWA.CourseId = ddlCourse.SelectedValue.ToString(); ObjEWA.ClassId = ddlClass.SelectedValue.ToString(); DataSet ds = ObjBL.BindSubject_BL(ObjEWA); if (ds.Tables[0].Rows.Count != 0) { ddlSubject.DataSource = ds; ddlSubject.DataTextField = "SubjectName"; ddlSubject.DataValueField = "SubjectId"; ddlSubject.DataBind(); } else { ddlSubject.Items.Clear(); } ddlSubject.Items.Insert(0, new ListItem("Select", "0")); ddlSubject.Items.Insert(1, new ListItem("Break", "501")); ddlSubject.SelectedIndex = 0; } catch (Exception exp) { GeneralErr(exp.Message.ToString()); } }