using System; using System.Data; using System.Configuration; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; using nmsSetup; using nmsADO; using System.Collections.Generic; namespace nmsSetup { public class clsDLSetup { //-------------------------------------------------------- clsBLado ADO = new clsBLado(); clsPRPadoBL ADOprp = new clsPRPadoBL(); clsPRPadoDL ADOprpDL = new clsPRPadoDL(); clsPRPadoBL adoBL = new clsPRPadoBL(); //------------------------------------------------ clsprpADO objadoprp = new clsprpADO(); clsADO objado = new clsADO(); //--Start State.Raj public string InsState(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[2]; ADOprp.ArrayPram[0] = new SqlParameter("@stateName", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@Abbreviation", objprp.abbriviation); ADOprp.SPName = "insState"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdState(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[3]; ADOprp.ArrayPram[0] = new SqlParameter("@stateID", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@stateName", objprp.name); ADOprp.ArrayPram[2] = new SqlParameter("@Abbreviation", objprp.abbriviation); ADOprp.SPName = "updState"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string DelState(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@stateID", objprp.id); ADOprp.SPName = "delState"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelState(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@stateID", objprp.id); ADOprpDL.SPName = "selState"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj.id = ADOprpDL.Dr["stateID"].ToString(); obj.name = ADOprpDL.Dr["stateName"].ToString(); obj.abbriviation = ADOprpDL.Dr["statecode"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } //--End State //--Start District. public string InsDistrict(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[3]; ADOprp.ArrayPram[0] = new SqlParameter("@distName", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@stateID", objprp.Stid); ADOprp.ArrayPram[2] = new SqlParameter("@districtCode", objprp.abbriviation); ADOprp.SPName = "insDistrict"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdDistrict(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[4]; ADOprp.ArrayPram[0] = new SqlParameter("@distId", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@distName", objprp.name); ADOprp.ArrayPram[2] = new SqlParameter("@stateId", objprp.Stid); ADOprp.ArrayPram[3] = new SqlParameter("@districtCode", objprp.abbriviation); ADOprp.SPName = "updDistrict"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string DelDistrict(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@distId", objprp.id); ADOprp.SPName = "delDistrict"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelDistrict(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@distId", objprp.id); ADOprpDL.SPName = "selDistrict"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj.id = ADOprpDL.Dr["districtId"].ToString(); obj.name = ADOprpDL.Dr["districtName"].ToString(); obj.Stid = ADOprpDL.Dr["districtSCode"].ToString(); obj.abbriviation = ADOprpDL.Dr["districtCode"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } //--End District. //--Start City. public string InsCity(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[3]; ADOprp.ArrayPram[0] = new SqlParameter("@cityName", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@distID", objprp.uniID); ADOprp.ArrayPram[2] = new SqlParameter("@cityCode", objprp.abbriviation); ADOprp.SPName = "insCity"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdCity(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[4]; ADOprp.ArrayPram[0] = new SqlParameter("@cityID", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@cityName", objprp.name); ADOprp.ArrayPram[2] = new SqlParameter("@distID", objprp.uniID); ADOprp.ArrayPram[3] = new SqlParameter("@cityCode", objprp.abbriviation); ADOprp.SPName = "updCity"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string DelCity(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@cityID", objprp.id); ADOprp.SPName = "delCity"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelCity(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@cityID", objprp.id); ADOprpDL.SPName = "selCity"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj.id = ADOprpDL.Dr["cityId"].ToString(); obj.name = ADOprpDL.Dr["cityName"].ToString(); obj.uniID = ADOprpDL.Dr["cityDCode"].ToString(); obj.abbriviation = ADOprpDL.Dr["cityCode"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } //--End City. //--start--University------------------- public string InsertUniversity(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[13]; ADOprp.ArrayPram[0] = new SqlParameter("@orgName", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@orgType", objprp.Type); ADOprp.ArrayPram[2] = new SqlParameter("@orgAddress", objprp.address); ADOprp.ArrayPram[3] = new SqlParameter("@orgCity", objprp.city); ADOprp.ArrayPram[4] = new SqlParameter("@orgDistrict", objprp.District); ADOprp.ArrayPram[5] = new SqlParameter("@orgState", objprp.Stid); ADOprp.ArrayPram[6] = new SqlParameter("@orgPhoneNo", objprp.phoneNo); ADOprp.ArrayPram[7] = new SqlParameter("@orgMobile", objprp.mobNo); ADOprp.ArrayPram[8] = new SqlParameter("@orgEmailId", objprp.mailId); ADOprp.ArrayPram[9] = new SqlParameter("@orgApprovalDate", objprp.DOJ); ADOprp.ArrayPram[10] = new SqlParameter("@orgApprovalEndDate", objprp.Enddate); ADOprp.ArrayPram[11] = new SqlParameter("@orgFaxNo", objprp.FaxNo); ADOprp.ArrayPram[12] = new SqlParameter("@orgPinCode", objprp.pinCode); ADOprp.SPName = "InsOrgmasterDetail"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdateUniversity(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[14]; ADOprp.ArrayPram[0] = new SqlParameter("@orgName", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@orgType", objprp.Type); ADOprp.ArrayPram[2] = new SqlParameter("@orgAddress", objprp.address); ADOprp.ArrayPram[3] = new SqlParameter("@orgCity", objprp.city); ADOprp.ArrayPram[4] = new SqlParameter("@orgDistrict", objprp.District); ADOprp.ArrayPram[5] = new SqlParameter("@orgState", objprp.Stid); ADOprp.ArrayPram[6] = new SqlParameter("@orgPhoneNo", objprp.phoneNo); ADOprp.ArrayPram[7] = new SqlParameter("@orgMobile", objprp.mobNo); ADOprp.ArrayPram[8] = new SqlParameter("@orgEmailId", objprp.mailId); ADOprp.ArrayPram[9] = new SqlParameter("@orgApprovalDate", objprp.DOJ); ADOprp.ArrayPram[10] = new SqlParameter("@orgApprovalEndDate", objprp.Enddate); ADOprp.ArrayPram[11] = new SqlParameter("@orgFaxNo", objprp.FaxNo); ADOprp.ArrayPram[12] = new SqlParameter("@orgPinCode", objprp.pinCode); ADOprp.ArrayPram[13] = new SqlParameter("@orgId", objprp.id); ADOprp.SPName = "updOrgmasterDetail"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string DeleteUniversity(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@universityCodeId", objprp.codeId); ADOprp.SPName = "deleteUniversity"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelectUniversity(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@orgId", objprp.id); ADOprpDL.SPName = "selectOrgmasterDetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj.id = ADOprpDL.Dr["orgId"].ToString(); obj.name = ADOprpDL.Dr["orgName"].ToString(); obj.address = ADOprpDL.Dr["orgAddress"].ToString(); obj.city = ADOprpDL.Dr["orgCity"].ToString(); obj.District = ADOprpDL.Dr["orgDistrict"].ToString(); obj.Distid = ADOprpDL.Dr["orgDistrict"].ToString(); obj.Cityid = ADOprpDL.Dr["orgCity"].ToString(); obj.Stid = ADOprpDL.Dr["orgState"].ToString(); obj.phoneNo = ADOprpDL.Dr["orgPhoneNo"].ToString(); obj.mobNo = ADOprpDL.Dr["orgMobile"].ToString(); obj.mailId = ADOprpDL.Dr["orgEmailId"].ToString(); obj.DOJ = ADOprpDL.Dr["orgApprovalDate"].ToString(); obj.Type = ADOprpDL.Dr["orgType"].ToString(); obj.Enddate = ADOprpDL.Dr["orgApprovalEndDate"].ToString(); obj.FaxNo = ADOprpDL.Dr["orgFaxNo"].ToString(); obj.pinCode = ADOprpDL.Dr["orgPinCode"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } public List ViewUniversity(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.SPName = "viewOrgmasterDetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.srNo = ADOprpDL.Dr["row"].ToString(); objprp.id = ADOprpDL.Dr["orgId"].ToString(); objprp.name = ADOprpDL.Dr["orgName"].ToString(); objprp.Type = ADOprpDL.Dr["orgType"].ToString(); objprp.address = ADOprpDL.Dr["orgAddress"].ToString(); objprp.city = ADOprpDL.Dr["cityName"].ToString(); objprp.District = ADOprpDL.Dr["districtName"].ToString(); objprp.Stid = ADOprpDL.Dr["stateName"].ToString(); objprp.phoneNo = ADOprpDL.Dr["orgPhoneNo"].ToString(); objprp.mobNo = ADOprpDL.Dr["orgMobile"].ToString(); objprp.mailId = ADOprpDL.Dr["orgEmailId"].ToString(); objprp.DOB = ADOprpDL.Dr["orgDate"].ToString(); objprp.FaxNo = ADOprpDL.Dr["orgFaxNo"].ToString(); objprp.pinCode = ADOprpDL.Dr["orgPinCode"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } //--End----university----------------------- public List ViewOLDStudentDetail(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[4]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.ArrayPram[2] = new SqlParameter("@status", prp.status); ADOprpDL.ArrayPram[3] = new SqlParameter("@branchid", prp.branchId); ADOprpDL.SPName = "oldViewStudentDetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.srNo = ADOprpDL.Dr["row"].ToString(); objprp.id = ADOprpDL.Dr["studentCode"].ToString(); objprp.name = ADOprpDL.Dr["studentName"].ToString(); objprp.fatherName = ADOprpDL.Dr["studentFatherName"].ToString(); objprp.StartDate = ADOprpDL.Dr["Joiningdate"].ToString(); objprp.city = ADOprpDL.Dr["studentCity"].ToString(); objprp.District = ADOprpDL.Dr["studentDistrict"].ToString(); objprp.CourseType = ADOprpDL.Dr["courseName"].ToString(); objprp.Organisation = ADOprpDL.Dr["orgName"].ToString(); objprp.status = ADOprpDL.Dr["Status"].ToString(); objprp.photo = ADOprpDL.Dr["photo"].ToString(); objprp.coursefee = ADOprpDL.Dr["smFee"].ToString(); objprp.branchName = ADOprpDL.Dr["branchName"].ToString(); objprp.loginName = ADOprpDL.Dr["loginName"].ToString(); objprp.rollNo = ADOprpDL.Dr["loginSrNo"].ToString(); objprp.Password = ADOprpDL.Dr["password"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } //Course Type public string InsCourseType(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@cTypeName", objprp.name); ADOprp.SPName = "InsCourseType"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdCourseType(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[2]; ADOprp.ArrayPram[0] = new SqlParameter("@CTypeId", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@cTypeName", objprp.name); ADOprp.SPName = "UpdCourseType"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelCourseType(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@CTypeId", objprp.id); ADOprpDL.SPName = "SelCourseType"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj.id = ADOprpDL.Dr["id"].ToString(); obj.name = ADOprpDL.Dr["name"].ToString(); obj.status = ADOprpDL.Dr["isActive"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } //courseTypeEnd //Course Category public string InsCourseCategory(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[4]; ADOprp.ArrayPram[0] = new SqlParameter("@catName", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@catOrgId", objprp.Organisation); ADOprp.ArrayPram[2] = new SqlParameter("@catCourseType", objprp.CourseType); ADOprp.ArrayPram[3] = new SqlParameter("@isActive", objprp.status); ADOprp.SPName = "InsmasterCourseCategory"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdCourseCategory(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[5]; ADOprp.ArrayPram[0] = new SqlParameter("@catId", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@catName", objprp.name); ADOprp.ArrayPram[2] = new SqlParameter("@catOrgId", objprp.Organisation); ADOprp.ArrayPram[3] = new SqlParameter("@catCourseType", objprp.CourseType); ADOprp.ArrayPram[4] = new SqlParameter("@isActive", objprp.status); ADOprp.SPName = "UpdmasterCourseCategory"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelCourseCategory(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@catId", objprp.id); ADOprpDL.SPName = "selCourseCategory"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj.id = ADOprpDL.Dr["id"].ToString(); obj.name = ADOprpDL.Dr["name"].ToString(); obj.status = ADOprpDL.Dr["isActive"].ToString(); obj.CourseType = ADOprpDL.Dr["catCourseType"].ToString(); obj.Organisation = ADOprpDL.Dr["catOrgId"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } //Course Category //--start--Course Detail--------- public string insertcoursedetail(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[10]; ADOprp.ArrayPram[0] = new SqlParameter("@courseName", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@courseCode", objprp.codeId); ADOprp.ArrayPram[2] = new SqlParameter("@courseShortName", objprp.title); ADOprp.ArrayPram[3] = new SqlParameter("@courseTime", objprp.courseTime); ADOprp.ArrayPram[4] = new SqlParameter("@courseOrgID", objprp.Organisation); ADOprp.ArrayPram[5] = new SqlParameter("@courseCatId", objprp.CourseType); ADOprp.ArrayPram[6] = new SqlParameter("@IsActive", objprp.status); ADOprp.ArrayPram[7] = new SqlParameter("@courseContent", objprp.description); ADOprp.ArrayPram[8] = new SqlParameter("@courseTimeType", objprp.CourseType1); ADOprp.ArrayPram[9] = new SqlParameter("@img", objprp.CourseType1); ADOprp.SPName = "insCourse"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string Updcoursedetail(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[10]; ADOprp.ArrayPram[0] = new SqlParameter("@courseName", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@courseCode", objprp.codeId); ADOprp.ArrayPram[2] = new SqlParameter("@courseShortName", objprp.title); ADOprp.ArrayPram[3] = new SqlParameter("@courseTime", objprp.courseTime); ADOprp.ArrayPram[4] = new SqlParameter("@courseOrgID", objprp.Organisation); ADOprp.ArrayPram[5] = new SqlParameter("@courseCatId", objprp.CourseType); ADOprp.ArrayPram[6] = new SqlParameter("@IsActive", objprp.status); ADOprp.ArrayPram[7] = new SqlParameter("@courseContent", objprp.description); ADOprp.ArrayPram[8] = new SqlParameter("@courseId", objprp.id); ADOprp.ArrayPram[9] = new SqlParameter("@courseTimeType", objprp.CourseType1); ADOprp.SPName = "updCourse"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup Selcoursedetail(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@courseId", objprp.id); ADOprpDL.SPName = "selCourse"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj=new PRPSetup(); obj.id = ADOprpDL.Dr["courseId"].ToString(); obj.name = ADOprpDL.Dr["courseName"].ToString(); obj.codeId = ADOprpDL.Dr["courseCode"].ToString(); obj.courseTime = ADOprpDL.Dr["courseTime"].ToString(); obj.CourseCategory = ADOprpDL.Dr["CTypeId"].ToString(); obj.CourseType = ADOprpDL.Dr["courseCatId"].ToString(); obj.Type = ADOprpDL.Dr["courseCatId"].ToString(); obj.Organisation = ADOprpDL.Dr["courseOrgID"].ToString(); obj.Organisation1 = ADOprpDL.Dr["courseOrgID"].ToString(); obj.description = ADOprpDL.Dr["courseContent"].ToString(); obj.title = ADOprpDL.Dr["courseShortName"].ToString(); obj.status = ADOprpDL.Dr["IsActive"].ToString(); obj.CourseType1 = ADOprpDL.Dr["courseCatId"].ToString(); obj.CourseCategory1 = ADOprpDL.Dr["courseTimeType"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } public List ViewCourseDetail(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[4]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.ArrayPram[2] = new SqlParameter("@courseUniID", prp.Organisation); ADOprpDL.ArrayPram[3] = new SqlParameter("@courseCatID", prp.CourseType); ADOprpDL.SPName = "viewCourse"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.srNo = ADOprpDL.Dr["row"].ToString(); objprp.id = ADOprpDL.Dr["courseId"].ToString(); objprp.name = ADOprpDL.Dr["courseName"].ToString(); objprp.title = ADOprpDL.Dr["courseShortName"].ToString(); objprp.codeId = ADOprpDL.Dr["courseCode"].ToString(); objprp.courseTime = ADOprpDL.Dr["courseTime"].ToString(); objprp.CourseType = ADOprpDL.Dr["courseCatId"].ToString(); objprp.Organisation = ADOprpDL.Dr["courseOrgID"].ToString(); objprp.description = ADOprpDL.Dr["courseContent"].ToString(); objprp.status = ADOprpDL.Dr["IsActive"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } //--End--Course Detail----------- //Insert Subject Start public string InsSubject(PRPSetup objprp) { var c = objprp.name.Replace("$", "&"); c = c.Replace("**", "++"); c = c.Replace("*", "+"); ADOprp.ArrayPram = new SqlParameter[6]; ADOprp.ArrayPram[0] = new SqlParameter("@subCode", objprp.codeId); ADOprp.ArrayPram[1] = new SqlParameter("@subName", c); ADOprp.ArrayPram[2] = new SqlParameter("@subMaxMarks", objprp.maxmark); ADOprp.ArrayPram[3] = new SqlParameter("@subMinMarks", objprp.minmark); ADOprp.ArrayPram[4] = new SqlParameter("@subOrgId", objprp.Organisation); ADOprp.ArrayPram[5] = new SqlParameter("@subIsActive", objprp.status); ADOprp.SPName = "InsmasterSubject"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdSubject(PRPSetup objprp) { var c = objprp.name.Replace("$", "&"); c = c.Replace("**", "++"); c = c.Replace("*", "+"); ADOprp.ArrayPram = new SqlParameter[7]; ADOprp.ArrayPram[0] = new SqlParameter("@subCode", objprp.codeId); ADOprp.ArrayPram[1] = new SqlParameter("@subName", c); ADOprp.ArrayPram[2] = new SqlParameter("@subMaxMarks", objprp.maxmark); ADOprp.ArrayPram[3] = new SqlParameter("@subMinMarks", objprp.minmark); ADOprp.ArrayPram[4] = new SqlParameter("@subOrgId", objprp.Organisation); ADOprp.ArrayPram[5] = new SqlParameter("@subIsActive", objprp.status); ADOprp.ArrayPram[6] = new SqlParameter("@subId", objprp.id); ADOprp.SPName = "UpdmasterSubject"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelSubject(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@subId", objprp.id); ADOprpDL.SPName = "SelmasterSubject"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["subId"].ToString(); obj.codeId = ADOprpDL.Dr["subCode"].ToString(); obj.name = ADOprpDL.Dr["subName"].ToString(); obj.maxmark = ADOprpDL.Dr["subMaxMarks"].ToString(); obj.minmark = ADOprpDL.Dr["subMinMarks"].ToString(); obj.Organisation = ADOprpDL.Dr["subOrgId"].ToString(); obj.status = ADOprpDL.Dr["subIsActive"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } public List ViewSubject(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", prp.Organisation); ADOprpDL.ArrayPram[1] = new SqlParameter("@IsActive", prp.status); ADOprpDL.SPName = "viewmasterSubject"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.srNo = ADOprpDL.Dr["row"].ToString(); objprp.id = ADOprpDL.Dr["id"].ToString(); objprp.codeId = ADOprpDL.Dr["subCode"].ToString(); objprp.name = ADOprpDL.Dr["name"].ToString(); objprp.maxmark = ADOprpDL.Dr["subMaxMarks"].ToString(); objprp.minmark = ADOprpDL.Dr["subMinMarks"].ToString(); objprp.Organisation = ADOprpDL.Dr["subOrgId"].ToString(); objprp.status = ADOprpDL.Dr["subIsActive"].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } //Insert Subject End //Subject CourseWise public string InsCourseWiseSubject(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[5]; ADOprp.ArrayPram[0] = new SqlParameter("@scwSubjectId", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@scwCourseId", objprp.name); ADOprp.ArrayPram[2] = new SqlParameter("@scwTrimID", objprp.semMode); ADOprp.ArrayPram[3] = new SqlParameter("@subOrgId", objprp.Organisation); ADOprp.ArrayPram[4] = new SqlParameter("@scwSerialNo", objprp.serial); ADOprp.SPName = "InssubjectCourseWise"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public List BindCourseWiseSubject(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@orgid", prp.Organisation); ADOprpDL.ArrayPram[1] = new SqlParameter("@courseid", prp.CourseCategory); ADOprpDL.SPName = "bindsubjectcoursewise"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.srNo = ADOprpDL.Dr["row"].ToString(); objprp.id = ADOprpDL.Dr["scwId"].ToString(); objprp.serial = ADOprpDL.Dr["scwSerialNo"].ToString(); objprp.name = ADOprpDL.Dr["subName"].ToString(); objprp.semMode = ADOprpDL.Dr["scwTrimID"].ToString(); objprp.CourseCategory = ADOprpDL.Dr["courseName"].ToString(); objprp.codeId = ADOprpDL.Dr["courseCode"].ToString(); objprp.total = ADOprpDL.Dr["totalFees"].ToString(); objprp.courseId = ADOprpDL.Dr["courseId"].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public string Deldata(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@id", objprp.id); ADOprp.SPName = objprp.name; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string updCourseWiseSubject(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[2]; ADOprp.ArrayPram[0] = new SqlParameter("@id", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@scwSerialNo", objprp.serial); ADOprp.SPName = "updsubjectCourseWise"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //End Subject Coursewise //Insert Course wise fee public string insCoursewisefee(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[8]; //ADOprp.ArrayPram[0] = new SqlParameter("@id", objprp.Organisation); ADOprp.ArrayPram[0] = new SqlParameter("@feeCourseId", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@feeSemCode", objprp.codeId); ADOprp.ArrayPram[2] = new SqlParameter("@feeSemName", objprp.title); ADOprp.ArrayPram[3] = new SqlParameter("@feeCourseFee", objprp.coursefee); ADOprp.ArrayPram[4] = new SqlParameter("@feeExamFee", objprp.examfee); ADOprp.ArrayPram[5] = new SqlParameter("@feeregFee", objprp.Regfee); ADOprp.ArrayPram[6] = new SqlParameter("@feeOtherFee", objprp.Otherfee); ADOprp.ArrayPram[7] = new SqlParameter("@feeTotalFee", objprp.Total); ADOprp.SPName = "insmasterCourseFee"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string updCoursewisefee(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[9]; ADOprp.ArrayPram[0] = new SqlParameter("@feeCourseId", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@feeSemCode", objprp.codeId); ADOprp.ArrayPram[2] = new SqlParameter("@feeSemName", objprp.title); ADOprp.ArrayPram[3] = new SqlParameter("@feeCourseFee", objprp.coursefee); ADOprp.ArrayPram[4] = new SqlParameter("@feeExamFee", objprp.examfee); ADOprp.ArrayPram[5] = new SqlParameter("@feeregFee", objprp.Regfee); ADOprp.ArrayPram[6] = new SqlParameter("@feeOtherFee", objprp.Otherfee); ADOprp.ArrayPram[7] = new SqlParameter("@feeTotalFee", objprp.Total); ADOprp.ArrayPram[8] = new SqlParameter("@feeId", objprp.id); ADOprp.SPName = "updmasterCourseFee"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelCoursewisefee(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@courseid", objprp.id); ADOprpDL.SPName = "selmasterCourseFee"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["feeId"].ToString(); obj.name = ADOprpDL.Dr["feeCourseId"].ToString(); obj.codeId = ADOprpDL.Dr["feeSemCode"].ToString(); obj.title = ADOprpDL.Dr["feeSemName"].ToString(); obj.coursefee = ADOprpDL.Dr["feeCourseFee"].ToString(); obj.examfee = ADOprpDL.Dr["feeExamFee"].ToString(); obj.Regfee = ADOprpDL.Dr["feeregFee"].ToString(); obj.Otherfee = ADOprpDL.Dr["feeOtherFee"].ToString(); obj.Total = ADOprpDL.Dr["feeTotalFee"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } public List BindCoursewisefee(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@courseid", prp.id); ADOprpDL.SPName = "BindmasterCourseFee"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.srNo = ADOprpDL.Dr["row"].ToString(); obj.id = ADOprpDL.Dr["feeId"].ToString(); obj.name = ADOprpDL.Dr["feeCourseId"].ToString(); obj.codeId = ADOprpDL.Dr["feeSemCode"].ToString(); obj.title = ADOprpDL.Dr["feeSemName"].ToString(); obj.coursefee = ADOprpDL.Dr["feeCourseFee"].ToString(); obj.examfee = ADOprpDL.Dr["feeExamFee"].ToString(); obj.Regfee = ADOprpDL.Dr["feeregFee"].ToString(); obj.Otherfee = ADOprpDL.Dr["feeOtherFee"].ToString(); obj.Total = ADOprpDL.Dr["feeTotalFee"].ToString(); lst.Add(obj); } } else { obj = new PRPSetup(); obj.srNo = "Result Not Find"; lst.Add(obj); } ADO.ReaderClose(ADOprpDL); return lst; } //End course wise fee //Branch Detail public string insBranchDetail(PRPSetup objprp) { if (objprp.rechargeDate != "" && objprp.rechargeDate != null) { objprp.rechargeDate = DateTime.ParseExact(objprp.rechargeDate, "yyyy-MM-dd", null).ToString("MM/dd/yyyy"); } string Name = objprp.name; Int64 Mob = Int64.Parse(objprp.mobNo); Int32 status= Convert.ToInt32(objprp.status); ADOprp.ArrayPram = new SqlParameter[22]; var c= objprp.name.Replace("$", "&"); var cn = objprp.branchCodeName.Replace("$", "&"); //ADOprp.ArrayPram[0] = new SqlParameter("@id", objprp.Organisation); ADOprp.ArrayPram[0] = new SqlParameter("@branchCode", objprp.codeId); ADOprp.ArrayPram[1] = new SqlParameter("@branchName", c); ADOprp.ArrayPram[2] = new SqlParameter("@branchAddress", objprp.address); ADOprp.ArrayPram[3] = new SqlParameter("@branchPhone", objprp.phoneNo); ADOprp.ArrayPram[4] = new SqlParameter("@branchMobile", objprp.mobNo); ADOprp.ArrayPram[5] = new SqlParameter("@branchEmail", objprp.emailID); ADOprp.ArrayPram[6] = new SqlParameter("@branchCity", objprp.city); ADOprp.ArrayPram[7] = new SqlParameter("@branchDistrict", objprp.District); ADOprp.ArrayPram[8] = new SqlParameter("@branchState", objprp.Stid); ADOprp.ArrayPram[9] = new SqlParameter("@branchLimit", objprp.branchLimit); ADOprp.ArrayPram[10] = new SqlParameter("@branchType", objprp.Type); ADOprp.ArrayPram[11] = new SqlParameter("@ReferenceBrachCodeId", objprp.reference); ADOprp.ArrayPram[12] = new SqlParameter("@password", objprp.Password); ADOprp.ArrayPram[13] = new SqlParameter("@branchStatus", objprp.status); ADOprp.ArrayPram[14] = new SqlParameter("@branchSecurity", objprp.branchSecurity); ADOprp.ArrayPram[15] = new SqlParameter("@openBalance", objprp.openBalance); ADOprp.ArrayPram[16] = new SqlParameter("@commPerStudent", objprp.commPerStudent); ADOprp.ArrayPram[17] = new SqlParameter("@branchMStudentComm", objprp.branchMStudentComm); ADOprp.ArrayPram[18] = new SqlParameter("@branchMSecurityComm", objprp.branchMSecurityComm); ADOprp.ArrayPram[19] = new SqlParameter("@branchContactPerson", cn); ADOprp.ArrayPram[20] = new SqlParameter("@branchRenewal", objprp.RAmount); ADOprp.ArrayPram[21] = new SqlParameter("@branchApproveDate", objprp.rechargeDate); ADOprp.SPName = "InsBranch"; string st= ADO.ScalarQueryWithProceduresandParam(ADOprp); string[] s = st.Split('!'); if (s[0].ToString() == "Successfully Done " && Mob > 9 && status==1 ) { nms_sms.cls_sms sms = new nms_sms.cls_sms(); //Visitus:www.BPPS.com sms.SMSSend("Dear " + Name + " Welcome To Gramin Shiksha. Your Registration has been done successfully. Your ID :" + s[1].ToString(), Mob); } else if (s[0].ToString() == "Successfully Done " && Mob > 9) { nms_sms.cls_sms sms = new nms_sms.cls_sms(); sms.SMSSend("Dear " + Name + " Welcome To Gramin Shiksha. Your Query has been done successfully. Call Us:99968-11114", Mob); //Your ID :" + s[1].ToString(), Mob); } return st; } public string updBranchDetail(PRPSetup objprp) { string Name = objprp.name; Int64 Mob = Int64.Parse(objprp.mobNo); Int32 status = Convert.ToInt32(objprp.status); Int32 Code = Convert.ToInt32(objprp.codeId); if (objprp.rechargeDate != "" && objprp.rechargeDate != null) { objprp.rechargeDate = DateTime.ParseExact(objprp.rechargeDate, "yyyy-MM-dd", null).ToString("MM/dd/yyyy"); } var c = objprp.name.Replace("$", "&"); var cn = objprp.branchCodeName.Replace("$", "&"); Int32 openBalance=0; string password=objprp.Password; if(objprp.openBalance!="" && objprp.openBalance!=null) { openBalance = Convert.ToInt32(objprp.openBalance); } ADOprp.ArrayPram = new SqlParameter[16]; // ADOprp.ArrayPram[0] = new SqlParameter("@branchCode", objprp.codeId); ADOprp.ArrayPram[0] = new SqlParameter("@branchName", c); ADOprp.ArrayPram[1] = new SqlParameter("@branchAddress", objprp.address); ADOprp.ArrayPram[2] = new SqlParameter("@branchPhone", objprp.phoneNo); ADOprp.ArrayPram[3] = new SqlParameter("@branchMobile", objprp.mobNo); ADOprp.ArrayPram[4] = new SqlParameter("@branchEmail", objprp.emailID); ADOprp.ArrayPram[5] = new SqlParameter("@branchCity", objprp.city); ADOprp.ArrayPram[6] = new SqlParameter("@branchDistrict", objprp.District); ADOprp.ArrayPram[7] = new SqlParameter("@branchState", objprp.Stid); //ADOprp.ArrayPram[8] = new SqlParameter("@branchLimit", objprp.branchLimit); ADOprp.ArrayPram[8] = new SqlParameter("@branchType", objprp.Type); ADOprp.ArrayPram[9] = new SqlParameter("@ReferenceBrachCodeId", objprp.reference); ADOprp.ArrayPram[10] = new SqlParameter("@password", objprp.Password); ADOprp.ArrayPram[11] = new SqlParameter("@branchStatus", objprp.status); // ADOprp.ArrayPram[14] = new SqlParameter("@branchSecurity", objprp.branchSecurity); // ADOprp.ArrayPram[15] = new SqlParameter("@openBalance", objprp.openBalance); // ADOprp.ArrayPram[16] = new SqlParameter("@commPerStudent", objprp.commPerStudent); // ADOprp.ArrayPram[17] = new SqlParameter("@branchMStudentComm", objprp.branchMStudentComm); // ADOprp.ArrayPram[18] = new SqlParameter("@branchMSecurityComm", objprp.branchMSecurityComm); ADOprp.ArrayPram[12] = new SqlParameter("@branchCodeId", objprp.id); ADOprp.ArrayPram[13] = new SqlParameter("@branchContactPerson", cn); ADOprp.ArrayPram[14] = new SqlParameter("@branchRenewal", objprp.RAmount); ADOprp.ArrayPram[15] = new SqlParameter("@branchApproveDate", objprp.rechargeDate); ADOprp.SPName = "updBranch"; string st= ADO.ScalarQueryWithProceduresandParam(ADOprp); if (st == "Successfully Done !" && Mob > 9 && status == 1 && openBalance>0) { nms_sms.cls_sms sms = new nms_sms.cls_sms(); //Visitus:www.BPPS.com sms.SMSSend("Dear " + Name + " Welcome To Gramin Shiksha. Your Registration has been done successfully. Your ID :" + Code + " and Password:=" + password , Mob); } return st; } public PRPSetup SelBranchDetail(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", objprp.id); ADOprpDL.SPName = "SelBranch"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["branchCodeId"].ToString(); obj.name = ADOprpDL.Dr["branchName"].ToString(); obj.codeId = ADOprpDL.Dr["branchCode"].ToString(); obj.address = ADOprpDL.Dr["branchAddress"].ToString(); obj.phoneNo = ADOprpDL.Dr["branchPhone"].ToString(); obj.mobNo = ADOprpDL.Dr["branchMobile"].ToString(); obj.emailID = ADOprpDL.Dr["branchEmail"].ToString(); obj.District = ADOprpDL.Dr["branchDistrict"].ToString(); obj.Stid = ADOprpDL.Dr["branchState"].ToString(); obj.Distid = ADOprpDL.Dr["branchDistrict"].ToString(); obj.Cityid = ADOprpDL.Dr["branchCity"].ToString(); obj.city = ADOprpDL.Dr["branchCity"].ToString(); obj.Type = ADOprpDL.Dr["branchType"].ToString(); obj.status = ADOprpDL.Dr["branchStatus"].ToString(); obj.Password = ADOprpDL.Dr["empLoginPassword"].ToString(); obj.title = ADOprpDL.Dr["empLoginName"].ToString(); obj.reference = ADOprpDL.Dr["ReferenceBrachCodeId"].ToString(); obj.branchSecurity = ADOprpDL.Dr["branchSecurity"].ToString(); obj.branchMSecurityComm = ADOprpDL.Dr["branchMSecurityComm"].ToString(); obj.branchMStudentComm = ADOprpDL.Dr["branchMStudentComm"].ToString(); obj.commPerStudent = ADOprpDL.Dr["commPerStudent"].ToString(); obj.branchLimit = ADOprpDL.Dr["branchLimit"].ToString(); obj.branchCodeName = ADOprpDL.Dr["branchContactPerson"].ToString(); obj.RAmount = ADOprpDL.Dr["branchRenewal"].ToString(); obj.rechargeDate = ADOprpDL.Dr["RenewalDate"].ToString(); obj.openBalance = "0"; } } ADO.ReaderClose(ADOprpDL); return obj; } public List BindBranchDetail(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", prp.id); ADOprpDL.SPName = "BindBranch"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.srNo = ADOprpDL.Dr["row"].ToString(); obj.id = ADOprpDL.Dr["branchCodeId"].ToString(); obj.name = ADOprpDL.Dr["branchName"].ToString(); obj.codeId = ADOprpDL.Dr["branchCode"].ToString(); obj.address = ADOprpDL.Dr["branchAddress"].ToString(); obj.phoneNo = ADOprpDL.Dr["branchPhone"].ToString(); obj.mobNo = ADOprpDL.Dr["branchMobile"].ToString(); obj.emailID = ADOprpDL.Dr["branchEmail"].ToString(); obj.District = ADOprpDL.Dr["branchDistrict"].ToString(); obj.Stid = ADOprpDL.Dr["branchState"].ToString(); obj.Type = ADOprpDL.Dr["branchType"].ToString(); obj.status = ADOprpDL.Dr["branchStatus"].ToString(); obj.Password = ADOprpDL.Dr["empLoginPassword"].ToString(); obj.title = ADOprpDL.Dr["empLoginName"].ToString(); obj.branchCodeName = ADOprpDL.Dr["branchContactPerson"].ToString(); obj.RAmount = ADOprpDL.Dr["branchRenewal"].ToString(); obj.rechargeDate = ADOprpDL.Dr["RenewalDate"].ToString(); lst.Add(obj); } } else { obj = new PRPSetup(); obj.srNo = "Result Not Find"; lst.Add(obj); } ADO.ReaderClose(ADOprpDL); return lst; } public List BindBranchDetail1(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[3]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.id); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.id); ADOprpDL.ArrayPram[2] = new SqlParameter("@state", prp.Stid); ADOprpDL.SPName = "BindBranch"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.srNo = ADOprpDL.Dr["row"].ToString(); obj.id = ADOprpDL.Dr["branchCodeId"].ToString(); obj.name = ADOprpDL.Dr["branchName"].ToString(); obj.codeId = ADOprpDL.Dr["branchCode"].ToString(); obj.address = ADOprpDL.Dr["branchAddress"].ToString(); obj.phoneNo = ADOprpDL.Dr["branchPhone"].ToString(); obj.mobNo = ADOprpDL.Dr["branchMobile"].ToString(); obj.emailID = ADOprpDL.Dr["branchEmail"].ToString(); obj.District = ADOprpDL.Dr["branchDistrict"].ToString(); obj.Stid = ADOprpDL.Dr["branchState"].ToString(); obj.Type = ADOprpDL.Dr["branchType"].ToString(); obj.status = ADOprpDL.Dr["branchStatus"].ToString(); obj.Password = ADOprpDL.Dr["empLoginPassword"].ToString(); obj.title = ADOprpDL.Dr["empLoginName"].ToString(); obj.branchCodeName = ADOprpDL.Dr["branchContactPerson"].ToString(); obj.RAmount = ADOprpDL.Dr["branchRenewal"].ToString(); obj.rechargeDate = ADOprpDL.Dr["RenewalDate"].ToString(); lst.Add(obj); } } else { obj = new PRPSetup(); obj.srNo = "Result Not Find"; lst.Add(obj); } ADO.ReaderClose(ADOprpDL); return lst; } public List viewBranchRenewal(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[3]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", prp.id); ADOprpDL.ArrayPram[1] = new SqlParameter("@status", prp.status); ADOprpDL.ArrayPram[2] = new SqlParameter("@date", prp.rechargeDate); ADOprpDL.SPName = "viewBranchRenewal"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.srNo = ADOprpDL.Dr["brdId"].ToString(); obj.id = ADOprpDL.Dr["branchCodeId"].ToString(); obj.name = ADOprpDL.Dr["branchName"].ToString(); obj.codeId = ADOprpDL.Dr["branchCode"].ToString(); obj.address = ADOprpDL.Dr["branchAddress"].ToString(); obj.phoneNo = ADOprpDL.Dr["branchPhone"].ToString(); obj.mobNo = ADOprpDL.Dr["branchMobile"].ToString(); obj.emailID = ADOprpDL.Dr["branchEmail"].ToString(); obj.District = ADOprpDL.Dr["branchDistrict"].ToString(); obj.Stid = ADOprpDL.Dr["branchState"].ToString(); obj.Type = ADOprpDL.Dr["branchType"].ToString(); obj.status = ADOprpDL.Dr["branchStatus"].ToString(); obj.Password = ADOprpDL.Dr["empLoginPassword"].ToString(); obj.title = ADOprpDL.Dr["empLoginName"].ToString(); obj.branchCodeName = ADOprpDL.Dr["branchContactPerson"].ToString(); obj.RAmount = ADOprpDL.Dr["brdInsValue"].ToString(); obj.rechargeDate = ADOprpDL.Dr["RenewalDate"].ToString(); obj.StartDate = ADOprpDL.Dr["brdStartDate"].ToString(); obj.Enddate = ADOprpDL.Dr["brdEndDate"].ToString(); obj.pv = ADOprpDL.Dr["brdStatus"].ToString(); obj.rechargeActDate = ADOprpDL.Dr["payDate"].ToString(); obj.duedate = ADOprpDL.Dr["RenewalDay"].ToString(); lst.Add(obj); } } else { obj = new PRPSetup(); obj.srNo = "Result Not Find"; lst.Add(obj); } ADO.ReaderClose(ADOprpDL); return lst; } //end Branch Detail //Set authority-------------// public string setBranchAuthority(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[2]; ADOprp.ArrayPram[0] = new SqlParameter("@id", objprp.branchId); ADOprp.ArrayPram[1] = new SqlParameter("@Page", objprp.title); ADOprp.SPName = "SetBranchAuthority"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //Set Authority----------------// //-----------Insert Student----------// public string insstudentDetail(PRPSetup objprp) { string Name = objprp.name; Int64 Mob =Int64.Parse(objprp.mobNo); Function inw = new Function(); ADOprp.ArrayPram = new SqlParameter[41]; //System.Globalization.CultureInfo ci = System.Globalization.CultureInfo.CreateSpecificCulture("en-GB"); // objprp.DOB = DateTime.Parse(objprp.DOB, ci.DateTimeFormat).ToString("d"); objprp.DOB = DateTime.ParseExact(objprp.DOB, "yyyy-MM-dd", null).ToString("MM/dd/yyyy"); objprp.StartDate = DateTime.ParseExact(objprp.StartDate, "yyyy-MM-dd", null).ToString("MM/dd/yyyy"); if(objprp.duedate!="" && objprp.duedate!=null) { objprp.duedate = DateTime.ParseExact(objprp.duedate, "yyyy-MM-dd", null).ToString("MM/dd/yyyy"); } if (objprp.Paidfee == "" || objprp.Paidfee == null) { objprp.Paidfee = "0"; } if (objprp.Latefee == "" || objprp.Latefee == null) { objprp.Latefee = "0"; } if (objprp.otherFees == "" || objprp.otherFees == null) { objprp.otherFees = "0"; } ADOprp.ArrayPram[0] = new SqlParameter("@smSessionStartDate", objprp.StartDate); ADOprp.ArrayPram[1] = new SqlParameter("@studentName", objprp.name); ADOprp.ArrayPram[2] = new SqlParameter("@studentRelation", objprp.relation); ADOprp.ArrayPram[3] = new SqlParameter("@studentFatherName", objprp.fatherName); ADOprp.ArrayPram[4] = new SqlParameter("@studentDOB", objprp.DOB); ADOprp.ArrayPram[5] = new SqlParameter("@studentSex", objprp.sex); ADOprp.ArrayPram[6] = new SqlParameter("@studentMarital", objprp.marital); ADOprp.ArrayPram[7] = new SqlParameter("@studentAddress", objprp.address); ADOprp.ArrayPram[8] = new SqlParameter("@studentCity", objprp.city); ADOprp.ArrayPram[9] = new SqlParameter("@studentDistrict", objprp.District); ADOprp.ArrayPram[10] = new SqlParameter("@studentState", objprp.Stid); ADOprp.ArrayPram[11] = new SqlParameter("@studentPinCode", objprp.pinCode); ADOprp.ArrayPram[12] = new SqlParameter("@studentMobileNo", objprp.mobNo); ADOprp.ArrayPram[13] = new SqlParameter("@studentPhone", objprp.phoneNo); ADOprp.ArrayPram[14] = new SqlParameter("@studentEmail", objprp.emailID); ADOprp.ArrayPram[15] = new SqlParameter("@pinBranchId", objprp.branchId); ADOprp.ArrayPram[16] = new SqlParameter("@pinEmployeeId", objprp.EmployeeID); ADOprp.ArrayPram[17] = new SqlParameter("@photo", objprp.photo); ADOprp.ArrayPram[18] = new SqlParameter("@documentProof", objprp.document); ADOprp.ArrayPram[19] = new SqlParameter("@smOrgId", objprp.Organisation); ADOprp.ArrayPram[20] = new SqlParameter("@smCourseId", objprp.courseName); ADOprp.ArrayPram[21] = new SqlParameter("@fmInsPaid", objprp.Paidfee); ADOprp.ArrayPram[22] = new SqlParameter("@smApplicationNo", objprp.Applicationno); ADOprp.ArrayPram[23] = new SqlParameter("@smFee", objprp.coursefee); ADOprp.ArrayPram[24] = new SqlParameter("@fmPendingAmount", objprp.PendingFee); ADOprp.ArrayPram[25] = new SqlParameter("@fmInsDueDate", objprp.duedate);//---- next due date ADOprp.ArrayPram[26] = new SqlParameter("@ftLateFee", objprp.Latefee); ADOprp.ArrayPram[27] = new SqlParameter("@ftOtherCharges", objprp.otherFees); int netamt = int.Parse(objprp.Paidfee) + int.Parse(objprp.Latefee) + int.Parse(objprp.otherFees); ADOprp.ArrayPram[28] = new SqlParameter("@ftNetAmount", netamt); ADOprp.ArrayPram[29] = new SqlParameter("@ftDueDate", objprp.status); //ADOprp.ArrayPram[30] = new SqlParameter("@ftPayDate", objprp.status); ADOprp.ArrayPram[30] = new SqlParameter("@ftFeeInWord", inw.IntoWord(netamt)); ADOprp.ArrayPram[31] = new SqlParameter("@ftPaymentType", objprp.tranType); ADOprp.ArrayPram[32] = new SqlParameter("@paymentDDNo", objprp.Chequenum); ADOprp.ArrayPram[33] = new SqlParameter("@paymentBankUserName", objprp.username); ADOprp.ArrayPram[34] = new SqlParameter("@paymentBankName", objprp.Bankname); ADOprp.ArrayPram[35] = new SqlParameter("@paymentBankAC", objprp.BankAccount); ADOprp.ArrayPram[36] = new SqlParameter("@paymentNote", objprp.remark); ADOprp.ArrayPram[37] = new SqlParameter("@motherName", objprp.MotherName); ADOprp.ArrayPram[38] = new SqlParameter("@catId", objprp.catID); ADOprp.ArrayPram[39] = new SqlParameter("@Concession", objprp.Concession); ADOprp.ArrayPram[40] = new SqlParameter("@ConcessionR", objprp.ConcessionR); ADOprp.SPName = "InsStudent"; string st=ADO.ScalarQueryWithProceduresandParam(ADOprp); string []s=st.Split('!'); if (s[0].ToString() == "Successfully Done " && Mob>9 ) { nms_sms.cls_sms sms = new nms_sms.cls_sms(); sms.SMSSend("Dear " + Name + " Welcome To Gramin Shiksha. Your admission has been done successfully ContactUs: 9996811114. Your ID :" + s[1].ToString() , Mob); } return st; } public string insStudentFee(PRPSetup objprp) { string Name = objprp.name; Int64 Mob = Int64.Parse(objprp.mobNo); Function inw = new Function(); ADOprp.ArrayPram = new SqlParameter[19]; if (objprp.duedate != "" && objprp.duedate != null) { objprp.duedate = DateTime.ParseExact(objprp.duedate, "yyyy-MM-dd", null).ToString("MM/dd/yyyy"); } if (objprp.Paidfee == "" || objprp.Paidfee == null) { objprp.Paidfee = "0"; } if (objprp.Latefee == "" || objprp.Latefee == null) { objprp.Latefee = "0"; } if (objprp.otherFees == "" || objprp.otherFees == null) { objprp.otherFees = "0"; } ADOprp.ArrayPram[0] = new SqlParameter("@fmInsPaid", objprp.Paidfee); ADOprp.ArrayPram[1] = new SqlParameter("@smFee", objprp.coursefee); ADOprp.ArrayPram[2] = new SqlParameter("@fmPendingAmount", objprp.PendingFee); ADOprp.ArrayPram[3] = new SqlParameter("@fmInsDueDate", objprp.duedate);//---- next due date ADOprp.ArrayPram[4] = new SqlParameter("@ftLateFee", objprp.Latefee); ADOprp.ArrayPram[5] = new SqlParameter("@ftOtherCharges", objprp.otherFees); int netamt = int.Parse(objprp.Paidfee) + int.Parse(objprp.Latefee) + int.Parse(objprp.otherFees); ADOprp.ArrayPram[6] = new SqlParameter("@ftNetAmount", netamt); ADOprp.ArrayPram[7] = new SqlParameter("@ftDueDate", objprp.duedate); ADOprp.ArrayPram[8] = new SqlParameter("@ftFeeInWord", inw.IntoWord(netamt)); ADOprp.ArrayPram[9] = new SqlParameter("@ftPaymentType", objprp.tranType); ADOprp.ArrayPram[10] = new SqlParameter("@paymentDDNo", objprp.Chequenum); ADOprp.ArrayPram[11] = new SqlParameter("@paymentBankUserName", objprp.username); ADOprp.ArrayPram[12] = new SqlParameter("@paymentBankName", objprp.Bankname); ADOprp.ArrayPram[13] = new SqlParameter("@paymentBankAC", objprp.BankAccount); ADOprp.ArrayPram[14] = new SqlParameter("@paymentNote", objprp.remark); ADOprp.ArrayPram[15] = new SqlParameter("@Concession", objprp.Concession); ADOprp.ArrayPram[16] = new SqlParameter("@ConcessionR", objprp.ConcessionR); ADOprp.ArrayPram[17] = new SqlParameter("@studentCode", objprp.codeId); ADOprpDL.ArrayPram[18] = new SqlParameter("@ftPayDate", objprp.rechargeDate); ADOprp.SPName = "insFee"; string st = ADO.ScalarQueryWithProceduresandParam(ADOprp); return st; } public string updStudentDetail(PRPSetup objprp) { string Name = objprp.name; Int64 Mob = Int64.Parse(objprp.mobNo); Function inw = new Function(); ADOprp.ArrayPram = new SqlParameter[17]; objprp.DOB = DateTime.ParseExact(objprp.DOB, "dd/MM/yyyy", null).ToString("MM/dd/yyyy"); objprp.StartDate = DateTime.ParseExact(objprp.StartDate, "dd/MM/yyyy", null).ToString("MM/dd/yyyy"); // objprp.duedate = DateTime.ParseExact(objprp.duedate, "dd/MM/yyyy", null).ToString("MM/dd/yyyy"); ADOprp.ArrayPram[0] = new SqlParameter("@studentDate", objprp.StartDate); ADOprp.ArrayPram[1] = new SqlParameter("@studentName", objprp.name); ADOprp.ArrayPram[2] = new SqlParameter("@studentRelation", objprp.relation); ADOprp.ArrayPram[3] = new SqlParameter("@studentFatherName", objprp.fatherName); ADOprp.ArrayPram[4] = new SqlParameter("@studentDOB", objprp.DOB); ADOprp.ArrayPram[5] = new SqlParameter("@catID", objprp.catID); ADOprp.ArrayPram[6] = new SqlParameter("@motherName", objprp.MotherName); ADOprp.ArrayPram[7] = new SqlParameter("@studentAddress", objprp.address); ADOprp.ArrayPram[8] = new SqlParameter("@studentMarital", objprp.marital); ADOprp.ArrayPram[9] = new SqlParameter("@applicationNo", objprp.Applicationno); ADOprp.ArrayPram[10] = new SqlParameter("@studentPinCode", objprp.pinCode); ADOprp.ArrayPram[11] = new SqlParameter("@studentMobileNo", objprp.mobNo); ADOprp.ArrayPram[12] = new SqlParameter("@studentPhone", objprp.phoneNo); ADOprp.ArrayPram[13] = new SqlParameter("@studentEmail", objprp.emailID); ADOprp.ArrayPram[14] = new SqlParameter("@photo", objprp.photo); ADOprp.ArrayPram[15] = new SqlParameter("@documentProof", objprp.document); ADOprp.ArrayPram[16] = new SqlParameter("@studentCode", objprp.id); // ADOprpDL.ArrayPram[17] = new SqlParameter("@password", objprp.Password); // ADOprpDL.ArrayPram[18] = new SqlParameter("@loginStatus", objprp.status); ADOprp.SPName = "UpdStudent"; string st = ADO.ScalarQueryWithProceduresandParam(ADOprp); return st; } public string updStudentDetail1(PRPSetup objprp) { string Name = objprp.name; Int64 Mob = Int64.Parse(objprp.mobNo); Function inw = new Function(); ADOprp.ArrayPram = new SqlParameter[26]; objprp.DOB = DateTime.ParseExact(objprp.DOB, "dd/MM/yyyy", null).ToString("MM/dd/yyyy"); objprp.StartDate = DateTime.ParseExact(objprp.StartDate, "dd/MM/yyyy", null).ToString("MM/dd/yyyy"); // objprp.duedate = DateTime.ParseExact(objprp.duedate, "dd/MM/yyyy", null).ToString("MM/dd/yyyy"); if (objprp.Paidfee == "" || objprp.Paidfee == null) { objprp.Paidfee = "0"; } if (objprp.Latefee == "" || objprp.Latefee == null) { objprp.Latefee = "0"; } if (objprp.otherFees == "" || objprp.otherFees == null) { objprp.otherFees = "0"; } ADOprp.ArrayPram[0] = new SqlParameter("@smSessionStartDate", objprp.StartDate); ADOprp.ArrayPram[1] = new SqlParameter("@studentName", objprp.name); ADOprp.ArrayPram[2] = new SqlParameter("@studentRelation", objprp.relation); ADOprp.ArrayPram[3] = new SqlParameter("@studentFatherName", objprp.fatherName); ADOprp.ArrayPram[4] = new SqlParameter("@studentDOB", objprp.DOB); ADOprp.ArrayPram[5] = new SqlParameter("@studentSex", objprp.sex); ADOprp.ArrayPram[6] = new SqlParameter("@studentMarital", objprp.marital); ADOprp.ArrayPram[7] = new SqlParameter("@studentAddress", objprp.address); ADOprp.ArrayPram[8] = new SqlParameter("@studentCity", objprp.city); ADOprp.ArrayPram[9] = new SqlParameter("@studentDistrict", objprp.District); ADOprp.ArrayPram[10] = new SqlParameter("@studentState", objprp.Stid); ADOprp.ArrayPram[11] = new SqlParameter("@studentPinCode", objprp.pinCode); ADOprp.ArrayPram[12] = new SqlParameter("@studentMobileNo", objprp.mobNo); ADOprp.ArrayPram[13] = new SqlParameter("@studentPhone", objprp.phoneNo); ADOprp.ArrayPram[14] = new SqlParameter("@studentEmail", objprp.emailID); ADOprp.ArrayPram[15] = new SqlParameter("@pinBranchId", objprp.branchId); ADOprp.ArrayPram[16] = new SqlParameter("@pinEmployeeId", objprp.EmployeeID); ADOprp.ArrayPram[17] = new SqlParameter("@photo", objprp.photo); ADOprp.ArrayPram[18] = new SqlParameter("@documentProof", objprp.document); ADOprp.ArrayPram[19] = new SqlParameter("@smOrgId", objprp.Organisation); ADOprp.ArrayPram[20] = new SqlParameter("@smCourseId", objprp.courseName); ADOprp.ArrayPram[21] = new SqlParameter("@smApplicationNo", objprp.Applicationno); ADOprp.ArrayPram[22] = new SqlParameter("@smFee", objprp.coursefee); ADOprp.ArrayPram[23] = new SqlParameter("@catId", objprp.catID); ADOprp.ArrayPram[24]=new SqlParameter("@studentCode",objprp.id); ADOprp.ArrayPram[25] = new SqlParameter("@motherName", objprp.MotherName); ADOprp.SPName = "updStudent1"; string st = ADO.ScalarQueryWithProceduresandParam(ADOprp); return st; } public PRPSetup selStudentDetail(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@studentId", objprp.id); ADOprpDL.SPName = "selStudentDetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["studentCode"].ToString(); obj.StartDate = ADOprpDL.Dr["studentDate"].ToString(); obj.name = ADOprpDL.Dr["studentName"].ToString(); obj.relation = ADOprpDL.Dr["studentRelation"].ToString(); obj.fatherName = ADOprpDL.Dr["studentFatherName"].ToString(); obj.MotherName = ADOprpDL.Dr["studentMother"].ToString(); obj.catID = ADOprpDL.Dr["studentCategory"].ToString(); obj.DOB = ADOprpDL.Dr["studentDOB"].ToString(); obj.address = ADOprpDL.Dr["studentAddress"].ToString(); obj.city = ADOprpDL.Dr["studentCity"].ToString(); obj.city1 = ADOprpDL.Dr["studentCity"].ToString(); obj.District = ADOprpDL.Dr["studentDistrict"].ToString(); obj.Stid = ADOprpDL.Dr["studentState"].ToString(); obj.pinCode = ADOprpDL.Dr["studentPinCode"].ToString(); obj.mobNo = ADOprpDL.Dr["studentMobileNo"].ToString(); obj.phoneNo = ADOprpDL.Dr["studentPhone"].ToString(); obj.emailID = ADOprpDL.Dr["studentEmail"].ToString(); obj.Applicationno = ADOprpDL.Dr["smApplicationNo"].ToString(); obj.marital = ADOprpDL.Dr["studentMarital"].ToString(); obj.photo = ADOprpDL.Dr["photo"].ToString(); obj.document = ADOprpDL.Dr["documentProof"].ToString(); obj.uniID = ADOprpDL.Dr["orgId"].ToString(); obj.Organisation1 = ADOprpDL.Dr["orgName"].ToString(); obj.CourseType = ADOprpDL.Dr["cTypeName"].ToString(); obj.CourseType1 = ADOprpDL.Dr["cTypeName"].ToString(); obj.CourseCategory = ADOprpDL.Dr["catName"].ToString(); obj.CourseCategory1 = ADOprpDL.Dr["catName"].ToString(); obj.codeId = ADOprpDL.Dr["courseId"].ToString(); obj.courseName1 = ADOprpDL.Dr["courseName"].ToString(); obj.Password = ADOprpDL.Dr["loginAPassword"].ToString(); obj.status = ADOprpDL.Dr["loginStatus"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } public List BindstateDistict(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", prp.id); ADOprpDL.SPName = "BindStateCityname"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.name = ADOprpDL.Dr["stateName"].ToString(); obj.title = ADOprpDL.Dr["districtName"].ToString(); lst.Add(obj); } } else { obj = new PRPSetup(); obj.srNo = "Result Not Find"; lst.Add(obj); } ADO.ReaderClose(ADOprpDL); return lst; } public List ViewPendStudentDetail(PRPSetup prp) { //if (prp.StartDate != "" && prp.StartDate != null) //{ // prp.StartDate = DateTime.ParseExact(prp.StartDate, "yyyy-MM-dd", null).ToString("MM/dd/yyyy"); //} //if (prp.Enddate != "" && prp.Enddate != null) //{ // prp.Enddate = DateTime.ParseExact(prp.Enddate, "yyyy-MM-dd", null).ToString("MM/dd/yyyy"); //} ADOprpDL.ArrayPram = new SqlParameter[15]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.ArrayPram[2] = new SqlParameter("@status", prp.status); ADOprpDL.ArrayPram[3] = new SqlParameter("@branchid", prp.branchId); ADOprpDL.ArrayPram[4] = new SqlParameter("@mobNo", prp.mobNo); ADOprpDL.ArrayPram[5] = new SqlParameter("@courseName", prp.courseName); ADOprpDL.ArrayPram[6] = new SqlParameter("@name", prp.name); ADOprpDL.ArrayPram[7] = new SqlParameter("@fatherName", prp.fatherName); ADOprpDL.ArrayPram[8] = new SqlParameter("@MotherName", prp.MotherName); ADOprpDL.ArrayPram[9] = new SqlParameter("@DOB", prp.DOB); ADOprpDL.ArrayPram[10] = new SqlParameter("@branchCodeName", prp.branchCodeName); ADOprpDL.ArrayPram[11] = new SqlParameter("@studentId", prp.id); ADOprpDL.ArrayPram[12] = new SqlParameter("@regNo", prp.codeId); ADOprpDL.ArrayPram[13] = new SqlParameter("@sdate", prp.StartDate); ADOprpDL.ArrayPram[14] = new SqlParameter("@edate", prp.Enddate); ADOprpDL.SPName = "viewStudentDetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.srNo = ADOprpDL.Dr["row"].ToString(); objprp.id = ADOprpDL.Dr["studentCode"].ToString(); objprp.name = ADOprpDL.Dr["studentName"].ToString(); objprp.fatherName = ADOprpDL.Dr["studentFatherName"].ToString(); objprp.StartDate = ADOprpDL.Dr["Joiningdate"].ToString(); objprp.city = ADOprpDL.Dr["studentCity"].ToString(); objprp.District = ADOprpDL.Dr["studentDistrict"].ToString(); objprp.CourseType = ADOprpDL.Dr["courseName"].ToString(); objprp.Organisation = ADOprpDL.Dr["orgName"].ToString(); objprp.status = ADOprpDL.Dr["Status"].ToString(); objprp.photo = ADOprpDL.Dr["photo"].ToString(); objprp.coursefee = ADOprpDL.Dr["smFee"].ToString(); objprp.branchName = ADOprpDL.Dr["branchName"].ToString(); objprp.loginName = ADOprpDL.Dr["loginName"].ToString(); objprp.rollNo = ADOprpDL.Dr["loginSrNo"].ToString(); objprp.Password = ADOprpDL.Dr["password"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public List ViewPendStudentDetailDownload(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[15]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.ArrayPram[2] = new SqlParameter("@status", prp.status); ADOprpDL.ArrayPram[3] = new SqlParameter("@branchid", prp.branchId); ADOprpDL.ArrayPram[4] = new SqlParameter("@mobNo", prp.mobNo); ADOprpDL.ArrayPram[5] = new SqlParameter("@courseName", prp.courseName); ADOprpDL.ArrayPram[6] = new SqlParameter("@name", prp.name); ADOprpDL.ArrayPram[7] = new SqlParameter("@fatherName", prp.fatherName); ADOprpDL.ArrayPram[8] = new SqlParameter("@MotherName", prp.MotherName); ADOprpDL.ArrayPram[9] = new SqlParameter("@DOB", prp.DOB); ADOprpDL.ArrayPram[10] = new SqlParameter("@branchCodeName", prp.branchCodeName); ADOprpDL.ArrayPram[11] = new SqlParameter("@studentId", prp.id); ADOprpDL.ArrayPram[12] = new SqlParameter("@regNo", prp.codeId); ADOprpDL.ArrayPram[13] = new SqlParameter("@sdate", prp.StartDate); ADOprpDL.ArrayPram[14] = new SqlParameter("@edate", prp.Enddate); ADOprpDL.SPName = "viewStudentDetailDownload"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.srNo = ADOprpDL.Dr["row"].ToString(); objprp.id = ADOprpDL.Dr["studentCode"].ToString(); objprp.name = ADOprpDL.Dr["studentName"].ToString(); objprp.fatherName = ADOprpDL.Dr["studentFatherName"].ToString(); objprp.StartDate = ADOprpDL.Dr["Joiningdate"].ToString(); objprp.city = ADOprpDL.Dr["studentCity"].ToString(); objprp.District = ADOprpDL.Dr["studentDistrict"].ToString(); objprp.CourseType = ADOprpDL.Dr["courseName"].ToString(); objprp.Organisation = ADOprpDL.Dr["orgName"].ToString(); objprp.status = ADOprpDL.Dr["Status"].ToString(); objprp.photo = ADOprpDL.Dr["photo"].ToString(); objprp.coursefee = ADOprpDL.Dr["smFee"].ToString(); objprp.branchName = ADOprpDL.Dr["branchName"].ToString(); objprp.loginName = ADOprpDL.Dr["loginName"].ToString(); objprp.rollNo = ADOprpDL.Dr["loginSrNo"].ToString(); objprp.Password = ADOprpDL.Dr["password"].ToString(); objprp.Enddate = ADOprpDL.Dr["RegDate"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public string SendForConfirmation(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[2]; ADOprp.ArrayPram[0] = new SqlParameter("@status", objprp.status); ADOprp.ArrayPram[1] = new SqlParameter("@id", objprp.title); ADOprp.SPName = "sendforconf"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string ConfirStuByAdmin(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[3]; ADOprp.ArrayPram[0] = new SqlParameter("@pinConBranchId", objprp.branchId); ADOprp.ArrayPram[1] = new SqlParameter("@pinConEmployeeId", objprp.EmployeeID); // ADOprp.ArrayPram[2] = new SqlParameter("@status", objprp.status); ADOprp.ArrayPram[2] = new SqlParameter("@studentcodeid", objprp.id); ADOprp.SPName = "ConfirmStudent"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //----------End Insert Student-----------------// //----------Wallet Detail-------------------// public string AdminWalletRecharge(PRPSetup objprp) { Function inw = new Function(); ADOprp.ArrayPram = new SqlParameter[4]; ADOprp.ArrayPram[0] = new SqlParameter("@Ramount", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@RDate", objprp.StartDate); ADOprp.ArrayPram[2] = new SqlParameter("@Remark", objprp.remark); ADOprp.ArrayPram[3] = new SqlParameter("@RechBranchid", objprp.branchId); ADOprp.SPName = "AdminWalletRecharge"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public List viewLatestFiveRecharge(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[0]; //ADOprpDL.ArrayPram[0] = new SqlParameter("@branchid", prp.branchId); ADOprpDL.SPName = "AdminfiveTran"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.name = ADOprpDL.Dr["Ramount"].ToString(); objprp.StartDate = ADOprpDL.Dr["RDate"].ToString(); objprp.remark = ADOprpDL.Dr["Remark"].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public string BranchWalletRecharge(PRPSetup objprp) { Function inw = new Function(); ADOprp.ArrayPram = new SqlParameter[5]; ADOprp.ArrayPram[0] = new SqlParameter("@rcBalance", objprp.RAmount); ADOprp.ArrayPram[1] = new SqlParameter("@validity", objprp.StartDate); ADOprp.ArrayPram[2] = new SqlParameter("@Remark", objprp.remark); ADOprp.ArrayPram[3] = new SqlParameter("@rcBranchId", objprp.branchId); ADOprp.ArrayPram[4] = new SqlParameter("@rcRechargedBy", objprp.EmployeeID); ADOprp.SPName = "branchRecharge"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public List viewBranchLatestFiveRecharge(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@Branchid", prp.branchId); ADOprpDL.ArrayPram[1] = new SqlParameter("@status", prp.status); ADOprpDL.SPName = "BranchfiveTran"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.branchName = ADOprpDL.Dr["RechargeBranch"].ToString(); objprp.rechargeType = ADOprpDL.Dr["rcType"].ToString(); objprp.rechargeDate = ADOprpDL.Dr["rcCreateDate"].ToString(); objprp.balanceBeforeRecharge = ADOprpDL.Dr["balanceBeforeRecharge"].ToString(); objprp.rechargeBalance = ADOprpDL.Dr["rcBalance"].ToString(); objprp.balanceAfterRecharge = ADOprpDL.Dr["balanceAfterRecharge"].ToString(); objprp.carryforwardedBalance = ADOprpDL.Dr["carryforwardedBalance"].ToString(); objprp.validity = ADOprpDL.Dr["Validity"].ToString(); objprp.remark = ADOprpDL.Dr["Remark"].ToString(); objprp.rechargeBy = ADOprpDL.Dr["RechargeBy"].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public string BranchCommisionSetting(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[4]; ADOprp.ArrayPram[0] = new SqlParameter("@bsBranchId", objprp.branchId); ADOprp.ArrayPram[1] = new SqlParameter("@bsCommissionType", objprp.tranType); ADOprp.ArrayPram[2] = new SqlParameter("@CommValue", objprp.RAmount); ADOprp.ArrayPram[3] = new SqlParameter("@bsPaymentDeduct", objprp.Type); ADOprp.SPName = "InsmasterBranchSetting"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public List viewBranchCommSetting(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@branchid", prp.branchId); ADOprpDL.SPName = "viewCommSetting"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.name = ADOprpDL.Dr["branchName"].ToString(); objprp.RAmount = ADOprpDL.Dr["CommValue"].ToString(); objprp.tranType = ADOprpDL.Dr["DedName"].ToString(); objprp.Type = ADOprpDL.Dr["CommType"].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public List viewCourseCommissionValue(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@branch", prp.branchId); ADOprpDL.SPName = "viewCourseCommissionValue"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.catID = ADOprpDL.Dr["catId"].ToString(); objprp.Organisation = ADOprpDL.Dr["orgName"].ToString(); objprp.CourseCategory = ADOprpDL.Dr["catName"].ToString(); objprp.RAmount = ADOprpDL.Dr["Value"].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public string InsCourseCommissionValue(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[3]; ADOprp.ArrayPram[0] = new SqlParameter("@branchid", objprp.branchId); ADOprp.ArrayPram[1] = new SqlParameter("@Courseid", objprp.catID); ADOprp.ArrayPram[2] = new SqlParameter("@value", objprp.RAmount); ADOprp.SPName = "insCommissionvalue"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public List viewBranchSecurity(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@branch", prp.branchId); ADOprpDL.SPName = "viewBranchSecurity"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.codeId = ADOprpDL.Dr["CodeId"].ToString(); objprp.name = ADOprpDL.Dr["branchName"].ToString(); objprp.branchLimit = ADOprpDL.Dr["branchLimit"].ToString(); objprp.branchSecurity = ADOprpDL.Dr["branchSecurity"].ToString(); objprp.branchId = ADOprpDL.Dr["mCodeId"].ToString(); objprp.branchName = ADOprpDL.Dr["mbranchName"].ToString(); objprp.branchMSecurityComm = ADOprpDL.Dr["securityComm"].ToString(); objprp.designationName = ADOprpDL.Dr["branchDesination"].ToString(); objprp.designationStatus = ADOprpDL.Dr["mbranchDesination"].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public string insBranchSecurity(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[4]; ADOprp.ArrayPram[0] = new SqlParameter("@branchid", objprp.branchId); ADOprp.ArrayPram[1] = new SqlParameter("@limit", objprp.branchLimit); ADOprp.ArrayPram[2] = new SqlParameter("@branchSecurity", objprp.branchSecurity); ADOprp.ArrayPram[3] = new SqlParameter("@branchMSecurityComm", objprp.branchMSecurityComm); ADOprp.SPName = "insBranchSecurity"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //--Start--News Type. public List viewcommDesWise(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@branch", prp.branchId); ADOprpDL.SPName = "viewcommDesWise"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.catID = ADOprpDL.Dr["catId"].ToString(); objprp.Organisation = ADOprpDL.Dr["orgName"].ToString(); objprp.CourseCategory = ADOprpDL.Dr["catName"].ToString(); objprp.branchId = ADOprpDL.Dr["branchCodeId"].ToString(); objprp.branchName = ADOprpDL.Dr["branchName"].ToString(); objprp.RAmount = ADOprpDL.Dr["Value"].ToString(); objprp.branchMStudentComm = ADOprpDL.Dr["cdValue"].ToString(); objprp.codeId = ADOprpDL.Dr["ComId"].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public string InsCommDesWise(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[3]; ADOprp.ArrayPram[0] = new SqlParameter("@branchid", objprp.branchId); ADOprp.ArrayPram[1] = new SqlParameter("@CommissionId", objprp.codeId); ADOprp.ArrayPram[2] = new SqlParameter("@value", objprp.RAmount); ADOprp.SPName = "insCommDegWise"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public List viewSecurityDesWise(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@branchId", prp.branchId); ADOprpDL.SPName = "viewSecurityDesWise"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.catID = ADOprpDL.Dr["catId"].ToString(); objprp.Organisation = ADOprpDL.Dr["orgName"].ToString(); objprp.CourseCategory = ADOprpDL.Dr["catName"].ToString(); objprp.branchId = ADOprpDL.Dr["branchCodeId"].ToString(); objprp.branchName = ADOprpDL.Dr["branchName"].ToString(); objprp.RAmount = ADOprpDL.Dr["Value"].ToString(); objprp.branchMStudentComm = ADOprpDL.Dr["cdValue"].ToString(); objprp.codeId = ADOprpDL.Dr["ComId"].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public string InsSecurityDesWise(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[3]; ADOprp.ArrayPram[0] = new SqlParameter("@branchid", objprp.branchId); ADOprp.ArrayPram[1] = new SqlParameter("@CommissionId", objprp.codeId); ADOprp.ArrayPram[2] = new SqlParameter("@value", objprp.RAmount); ADOprp.SPName = "insSecurityDegWise"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //---Start Add Marks. public List viewMarksDetail(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@studentId", prp.id); ADOprpDL.SPName = "createMark"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["studentCode"].ToString(); objprp.loginName = ADOprpDL.Dr["loginName"].ToString(); objprp.name = ADOprpDL.Dr["studentName"].ToString(); objprp.StartDate = ADOprpDL.Dr["studentDate"].ToString(); objprp.courseName = ADOprpDL.Dr["courseName"].ToString(); objprp.branchId = ADOprpDL.Dr["BranchId"].ToString(); objprp.branchName = ADOprpDL.Dr["BName"].ToString(); objprp.moduleId = ADOprpDL.Dr["scwTrimID"].ToString(); objprp.courseId = ADOprpDL.Dr["courseId"].ToString(); objprp.practicalMark = ADOprpDL.Dr["practicalmark"].ToString(); objprp.paperMark = ADOprpDL.Dr["papermark"].ToString(); objprp.fatherName = ADOprpDL.Dr["studentFatherName"].ToString(); objprp.scwSubjectId = ADOprpDL.Dr["scwSubjectId"].ToString(); objprp.subName = ADOprpDL.Dr["subName"].ToString(); // objprp.scwSubjectId = ADOprpDL.Dr["scwSubjectId"].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public List viewMarksDetailSubject(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@studentId", prp.id); ADOprpDL.SPName = "createMarkSubject"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["studentCode"].ToString(); objprp.loginName = ADOprpDL.Dr["loginName"].ToString(); objprp.name = ADOprpDL.Dr["studentName"].ToString(); objprp.StartDate = ADOprpDL.Dr["studentDate"].ToString(); objprp.courseName = ADOprpDL.Dr["courseName"].ToString(); objprp.branchId = ADOprpDL.Dr["BranchId"].ToString(); objprp.branchName = ADOprpDL.Dr["BName"].ToString(); objprp.moduleId = ADOprpDL.Dr["scwTrimID"].ToString(); objprp.courseId = ADOprpDL.Dr["courseId"].ToString(); objprp.subId = ADOprpDL.Dr["subId"].ToString(); objprp.subName = ADOprpDL.Dr["subName"].ToString(); objprp.practicalMark = ADOprpDL.Dr["practicalmark"].ToString(); objprp.paperMark = ADOprpDL.Dr["papermark"].ToString(); objprp.fatherName = ADOprpDL.Dr["studentFatherName"].ToString(); objprp.AssociateName = ADOprpDL.Dr["subCatStatus"].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public string insMarkDetail(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[2]; ADOprp.ArrayPram[0] = new SqlParameter("@querry", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@querry1", objprp.address); ADOprp.SPName = "insmarkDetail"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public DataSet viewPrintdiplomaOther(PRPSetup prp) { adoBL.ArrayPram = new SqlParameter[1]; adoBL.ArrayPram[0] = new SqlParameter("@studentId", prp.id); adoBL.SPName = "viewPrintdiplomaOther"; return ADO.DataSetWithProceduresandParam(adoBL); } public DataSet viewPrintdiplomaNTTall(PRPSetup prp) { adoBL.ArrayPram = new SqlParameter[2]; adoBL.ArrayPram[0] = new SqlParameter("@studentId", prp.id); adoBL.ArrayPram[1] = new SqlParameter("@moduleId", prp.moduleId); adoBL.SPName = "viewPrintNTT_verify"; return ADO.DataSetWithProceduresandParam(adoBL); } public DataSet viewprintDiploma(PRPSetup prp) { adoBL.ArrayPram = new SqlParameter[1]; adoBL.ArrayPram[0] = new SqlParameter("@studentId", prp.id); adoBL.SPName = "viewPrintdiploma"; return ADO.DataSetWithProceduresandParam(adoBL); } public DataSet viewprintDiplomaSubject(PRPSetup prp) { adoBL.ArrayPram = new SqlParameter[2]; adoBL.ArrayPram[0] = new SqlParameter("@studentId", prp.id); adoBL.ArrayPram[1] = new SqlParameter("@moduleId", prp.moduleId); adoBL.SPName = "viewPrintdiplomaSubject"; return ADO.DataSetWithProceduresandParam(adoBL); } //--Start Text Editor. public string Changequestion(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[11]; ADOprp.ArrayPram[0] = new SqlParameter("@mcatid", objprp.uniID); ADOprp.ArrayPram[1] = new SqlParameter("@validAns", objprp.status); ADOprp.ArrayPram[2] = new SqlParameter("@AnsA", objprp.AnsA); ADOprp.ArrayPram[3] = new SqlParameter("@Question", objprp.description); ADOprp.ArrayPram[4] = new SqlParameter("@AnsB", objprp.AnsB); ADOprp.ArrayPram[5] = new SqlParameter("@AnsC", objprp.AnsC); ADOprp.ArrayPram[6] = new SqlParameter("@AnsD", objprp.AnsD); ADOprp.ArrayPram[7] = new SqlParameter("@SubCatid", objprp.catID); ADOprp.ArrayPram[8] = new SqlParameter("@heading", objprp.name); ADOprp.ArrayPram[9] = new SqlParameter("@description", objprp.title); ADOprp.ArrayPram[10] = new SqlParameter("@qid", objprp.id); ADOprp.SPName = "instblQuestionComp1"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string InsQuestionText(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[11]; ADOprp.ArrayPram[0] = new SqlParameter("@mcatid", objprp.uniID); ADOprp.ArrayPram[1] = new SqlParameter("@validAns", objprp.status); ADOprp.ArrayPram[2] = new SqlParameter("@AnsA", objprp.AnsA); ADOprp.ArrayPram[3] = new SqlParameter("@Question", objprp.description); ADOprp.ArrayPram[4] = new SqlParameter("@AnsB", objprp.AnsB); ADOprp.ArrayPram[5] = new SqlParameter("@AnsC", objprp.AnsC); ADOprp.ArrayPram[6] = new SqlParameter("@AnsD", objprp.AnsD); ADOprp.ArrayPram[7] = new SqlParameter("@SubCatid", objprp.catID); ADOprp.ArrayPram[8] = new SqlParameter("@heading", objprp.name); ADOprp.ArrayPram[9] = new SqlParameter("@description", objprp.title); ADOprp.ArrayPram[10] = new SqlParameter("@QuestionMarks", objprp.codeId); ADOprp.SPName = "instblQuestionComp"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdQuestionText(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[12]; ADOprp.ArrayPram[0] = new SqlParameter("@mcatid", objprp.uniID); ADOprp.ArrayPram[1] = new SqlParameter("@validAns", objprp.status); ADOprp.ArrayPram[2] = new SqlParameter("@AnsA", objprp.AnsA); ADOprp.ArrayPram[3] = new SqlParameter("@Question", objprp.description); ADOprp.ArrayPram[4] = new SqlParameter("@AnsB", objprp.AnsB); ADOprp.ArrayPram[5] = new SqlParameter("@AnsC", objprp.AnsC); ADOprp.ArrayPram[6] = new SqlParameter("@AnsD", objprp.AnsD); ADOprp.ArrayPram[7] = new SqlParameter("@SubCatid", objprp.catID); ADOprp.ArrayPram[8] = new SqlParameter("@heading", objprp.name); ADOprp.ArrayPram[9] = new SqlParameter("@description", objprp.title); ADOprp.ArrayPram[10] = new SqlParameter("@QuestionMarks", objprp.codeId); ADOprp.ArrayPram[11] = new SqlParameter("@QuesId", objprp.id); ADOprp.SPName = "UpdtblQuestionComp"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string DelQuestionText(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@QuesId", objprp.id); ADOprp.SPName = "deltblQuestionComp"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public List ViewQuestionpaper(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[3]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.ArrayPram[2] = new SqlParameter("@UniId", prp.uniID); //ADOprpDL.ArrayPram[3] = new SqlParameter("@textId", prp.catID); ADOprpDL.SPName = "viewquestionpaper"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["Quesid"].ToString(); objprp.AnsA = ADOprpDL.Dr["AnsA"].ToString(); objprp.AnsB = ADOprpDL.Dr["AnsB"].ToString(); objprp.description = ADOprpDL.Dr["Question"].ToString(); //objprp.uniID = ADOprpDL.Dr["name"].ToString(); //objprp.catID = ADOprpDL.Dr["catname"].ToString(); objprp.isActive = ADOprpDL.Dr["validAns"].ToString(); objprp.AnsC = ADOprpDL.Dr["AnsC"].ToString(); objprp.AnsD = ADOprpDL.Dr["AnsD"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public PRPSetup SelQuestionText(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@QuesId", objprp.id); ADOprpDL.SPName = "seltblQuestionComp"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["QuesId"].ToString(); obj.AnsA = ADOprpDL.Dr["AnsA"].ToString(); obj.AnsB = ADOprpDL.Dr["AnsB"].ToString(); obj.description = ADOprpDL.Dr["Question"].ToString(); obj.catID = ADOprpDL.Dr["SubCatid"].ToString(); obj.uniID = ADOprpDL.Dr["mcatid"].ToString(); obj.isActive = ADOprpDL.Dr["validAns"].ToString(); obj.AnsC = ADOprpDL.Dr["AnsC"].ToString(); obj.AnsD = ADOprpDL.Dr["AnsD"].ToString(); obj.name = ADOprpDL.Dr["heading"].ToString(); obj.title = ADOprpDL.Dr["description"].ToString(); obj.codeId = ADOprpDL.Dr["QuestionMarks"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } public List ViewQuestionText(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[4]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.ArrayPram[2] = new SqlParameter("@UniId", prp.uniID); ADOprpDL.ArrayPram[3] = new SqlParameter("@textId", prp.catID); ADOprpDL.SPName = "viewQuestionText"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.srNo = ADOprpDL.Dr["row"].ToString(); objprp.status = ADOprpDL.Dr["QuestionMarks"].ToString(); objprp.id = ADOprpDL.Dr["Quesid"].ToString(); objprp.AnsA = ADOprpDL.Dr["AnsA"].ToString(); objprp.AnsB = ADOprpDL.Dr["AnsB"].ToString(); objprp.description = ADOprpDL.Dr["Question"].ToString(); objprp.uniID = ADOprpDL.Dr["name"].ToString(); objprp.catID = ADOprpDL.Dr["catname"].ToString(); objprp.isActive = ADOprpDL.Dr["validAns"].ToString(); objprp.AnsC = ADOprpDL.Dr["AnsC"].ToString(); objprp.AnsD = ADOprpDL.Dr["AnsD"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } //--Start Text Category. //make Question Paper public string insMasterQuestionpaper(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[3]; ADOprp.ArrayPram[0] = new SqlParameter("@Testname", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@courseId", objprp.catID); ADOprp.ArrayPram[2] = new SqlParameter("@isActive", objprp.isActive); ADOprp.SPName = "insMasterQuestionpaper"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string updMasterQuestionpaper(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[3]; ADOprp.ArrayPram[0] = new SqlParameter("@Testname", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@id", objprp.id); ADOprp.ArrayPram[2] = new SqlParameter("@isActive", objprp.isActive); ADOprp.SPName = "updMasterQuestionpaper"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup selMasterQuestionpaper(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", objprp.id); ADOprpDL.SPName = "selquestionpapername"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj.id = ADOprpDL.Dr["id"].ToString(); obj.name = ADOprpDL.Dr["Testname"].ToString(); obj.isActive = ADOprpDL.Dr["isActive"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } public string makequestionpaper(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[6]; ADOprp.ArrayPram[0] = new SqlParameter("@TestDuration", objprp.durationMaxTime); ADOprp.ArrayPram[1] = new SqlParameter("@Testname", objprp.name); ADOprp.ArrayPram[2] = new SqlParameter("@query", objprp.description); ADOprp.ArrayPram[3] = new SqlParameter("@courseId", objprp.catID); ADOprp.ArrayPram[4] = new SqlParameter("@trimesterID", objprp.uniID); ADOprp.ArrayPram[5] = new SqlParameter("@QuestionId", objprp.id); ADOprp.SPName = "spmakeQuestionpaper"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string setquestionpapertostudent(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@query", objprp.Query); ADOprp.SPName = "insviewstudentquestionpaper"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public List viewQPLevelWiseQue(PRPSetup obj) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@courseId", obj.catID); ADOprpDL.ArrayPram[1] = new SqlParameter("@QuestionId", obj.uniID); ADOprpDL.SPName = "viewQPLevelWiseQue"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["QPLID"].ToString(); objprp.title = ADOprpDL.Dr["levelTitle"].ToString(); objprp.total = ADOprpDL.Dr["totalQuestion"].ToString(); objprp.mainLandMark = ADOprpDL.Dr["totalMarks"].ToString(); objprp.courseTime = ADOprpDL.Dr["totalTime"].ToString(); objprp.catID = ADOprpDL.Dr["levelID"].ToString(); objprp.name = ADOprpDL.Dr["TestName"].ToString(); objprp.fatherName = ADOprpDL.Dr["courseName"].ToString(); lst.Add(objprp); } } ADO.ReaderClose(ADOprpDL); return lst; } public List viewmarks(PRPSetup obj) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@subcatid", obj.catID); ADOprpDL.SPName = "viewMarks"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["questionmarks"].ToString(); objprp.noOfRecord = ADOprpDL.Dr["total"].ToString(); objprp.catID = ADOprpDL.Dr["catid"].ToString(); objprp.name = ADOprpDL.Dr["name"].ToString(); lst.Add(objprp); } } ADO.ReaderClose(ADOprpDL); return lst; } public List viewStudentCourseBranchWise(PRPSetup obj) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", obj.uniID); ADOprpDL.ArrayPram[1] = new SqlParameter("@courseId", obj.catID); ADOprpDL.SPName = "viewStudentBranchwise"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["id"].ToString(); objprp.name = ADOprpDL.Dr["name"].ToString(); lst.Add(objprp); } } ADO.ReaderClose(ADOprpDL); return lst; } public List viewStudentCourseBranchWise1(PRPSetup obj) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", obj.uniID); ADOprpDL.ArrayPram[1] = new SqlParameter("@courseId", obj.catID); ADOprpDL.SPName = "viewStudentBranchwise1"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["id"].ToString(); objprp.name = ADOprpDL.Dr["name"].ToString(); lst.Add(objprp); } } ADO.ReaderClose(ADOprpDL); return lst; } public List viewstudentResult(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@paperid", prp.catID); ADOprpDL.SPName = "viewStudentResult"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["questionpaperid"].ToString(); objprp.catID = ADOprpDL.Dr["Studentid"].ToString(); objprp.name = ADOprpDL.Dr["stName"].ToString(); objprp.title = ADOprpDL.Dr["Testname"].ToString(); objprp.noOfRecord = ADOprpDL.Dr["TotalQuestion"].ToString(); objprp.DOB = ADOprpDL.Dr["Helddate"].ToString(); objprp.status = ADOprpDL.Dr["marks"].ToString(); objprp.isActive = ADOprpDL.Dr["TestStatus"].ToString(); lst.Add(objprp); } } ADO.ReaderClose(ADOprpDL); return lst; } public string checkstudentpaper(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[2]; ADOprp.ArrayPram[0] = new SqlParameter("@paperid", objprp.uniID); ADOprp.ArrayPram[1] = new SqlParameter("@studentId", objprp.id); ADOprp.SPName = "checkstudentpaper"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //end Question paper public List viewSubjectTrimesterWise(PRPSetup obj) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", obj.catID); ADOprpDL.ArrayPram[1] = new SqlParameter("@maincatgory", obj.id); ADOprpDL.SPName = "viewSubjectTrimesterWise"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["scwId"].ToString(); objprp.codeId = ADOprpDL.Dr["id"].ToString(); objprp.name = ADOprpDL.Dr["name"].ToString(); objprp.fatherName = ADOprpDL.Dr["courseName"].ToString(); objprp.durationMaxTime = ADOprpDL.Dr["maxMarks"].ToString(); objprp.durationMinTime = ADOprpDL.Dr["minMarks"].ToString(); objprp.phoneCode = ADOprpDL.Dr["TrimesterID"].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public PRPSetup viewTestDetail(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@studentId", objprp.id); ADOprpDL.SPName = "viewTestDetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj.id = ADOprpDL.Dr["questionpaperid"].ToString(); obj.isActive = ADOprpDL.Dr["isactive"].ToString(); obj.status = ADOprpDL.Dr["isview"].ToString(); obj.DOB = ADOprpDL.Dr["TestHeldDate"].ToString(); obj.hour = ADOprpDL.Dr["Testhour"].ToString(); obj.mint = ADOprpDL.Dr["TestMinute"].ToString(); obj.name = ADOprpDL.Dr["courseName"].ToString(); obj.fatherName = ADOprpDL.Dr["Testname"].ToString(); obj.uniID = ADOprpDL.Dr["testtime"].ToString(); obj.total = ADOprpDL.Dr["totalQuestion"].ToString(); obj.Total = ADOprpDL.Dr["totalTime"].ToString(); obj.DOJ = ADOprpDL.Dr["TestEndDate"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } public List selectStudentPracticalmark(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[4]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.ArrayPram[2] = new SqlParameter("@branchId", prp.branchId); ADOprpDL.ArrayPram[3] = new SqlParameter("@moduleid", prp.moduleId); ADOprpDL.SPName = "studentPracticalmark"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["studentCode"].ToString(); objprp.name = ADOprpDL.Dr["studentName"].ToString(); objprp.total = ADOprpDL.Dr["valueTotalAmount"].ToString(); objprp.DOJ = ADOprpDL.Dr["memberJoiningDate"].ToString(); objprp.branchName = ADOprpDL.Dr["cBranchName"].ToString(); objprp.courseName = ADOprpDL.Dr["courseName"].ToString(); objprp.branchId = ADOprpDL.Dr["pinBranchId"].ToString(); objprp.moduleId = ADOprpDL.Dr["module1"].ToString(); objprp.courseId = ADOprpDL.Dr["smCourseId"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public string inspracticalmark(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@querry", objprp.name); ADOprp.SPName = "inspracticalmark"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public List View_coursetype(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@CTypeId", objprp.catID); ADOprpDL.SPName = "SelCourseType"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.catID = ADOprpDL.Dr["id"].ToString(); obj.CourseType = ADOprpDL.Dr["name"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } //---------------View Course Category----------------// public List view_coursecategory(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@catcoursetype", prp.catID); ADOprpDL.SPName = "view_coursecategory"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.catID = ADOprpDL.Dr["catid"].ToString(); obj.name = ADOprpDL.Dr["catname"].ToString(); obj.Type = ADOprpDL.Dr["catcoursetype"].ToString(); lst.Add(obj); } } else { obj = new PRPSetup(); obj.srNo = "Result Not Find"; lst.Add(obj); } ADO.ReaderClose(ADOprpDL); return lst; } //----------------------View Course Detail----------// public List view_coursedetail(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@coursecatid", prp.catID); ADOprpDL.ArrayPram[1] = new SqlParameter("@courseid", prp.courseId); ADOprpDL.SPName = "view_coursedetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.courseId = ADOprpDL.Dr["courseid"].ToString(); obj.courseName = ADOprpDL.Dr["courseName"].ToString(); obj.description = ADOprpDL.Dr["coursecontent"].ToString(); obj.catID = ADOprpDL.Dr["coursecatid"].ToString(); obj.name = ADOprpDL.Dr["catname"].ToString(); obj.courseduraction = ADOprpDL.Dr["courseTime"].ToString(); obj.mastercoursedetailimage = ADOprpDL.Dr["courseimage"].ToString(); // obj.coursecode = ADOprpDL.Dr["courseCode"].ToString(); obj.courseFees = ADOprpDL.Dr["feeTotalFee"].ToString(); obj.Level = ADOprpDL.Dr["courselevel"].ToString(); obj.courseeligibility = ADOprpDL.Dr["courseEligibility"].ToString(); obj.overviewpic = ADOprpDL.Dr["overviewPicture"].ToString(); obj.viewcourselevel = ADOprpDL.Dr["courselevel"].ToString(); obj.viewcourseEligibility = ADOprpDL.Dr["courseEligibility"].ToString(); obj.viewcourseQPFile = ADOprpDL.Dr["courseQPFile"].ToString(); obj.viewcoursecurriculumfile = ADOprpDL.Dr["coursecurriculumfile"].ToString(); obj.viewcourseDuration = ADOprpDL.Dr["courseDuration"].ToString(); obj.AnsB = ADOprpDL.Dr["caturl"].ToString(); lst.Add(obj); } } else { obj = new PRPSetup(); obj.srNo = "Result Not Find"; lst.Add(obj); } ADO.ReaderClose(ADOprpDL); return lst; } //--------------------------View course highlights Detail---------// //--------------------------View New Front Course Detail---------// public List view_frontCourse_Detail(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[3]; ADOprpDL.ArrayPram[0] = new SqlParameter("@textCatID", prp.catID); ADOprpDL.ArrayPram[1] = new SqlParameter("@Branchid", prp.courseId); ADOprpDL.ArrayPram[2] = new SqlParameter("@textid", prp.id); ADOprpDL.SPName = "view_frontCourse_Detail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["textid"].ToString(); obj.title = ADOprpDL.Dr["textTitle"].ToString(); obj.courseId = ADOprpDL.Dr["Branchid"].ToString(); obj.courseName = ADOprpDL.Dr["courseName"].ToString(); obj.description = ADOprpDL.Dr["textDescription"].ToString(); obj.urlPath = ADOprpDL.Dr["imagePath"].ToString(); obj.catID = ADOprpDL.Dr["textCatID"].ToString(); obj.name = ADOprpDL.Dr["catname"].ToString(); lst.Add(obj); } } else { obj = new PRPSetup(); obj.srNo = "Result Not Find"; lst.Add(obj); } ADO.ReaderClose(ADOprpDL); return lst; } //Course name view public DataTable ViewCoursename(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@id", objprp.id); ADOprp.SPName = "viewCoursename"; return ADO.DataTableWithProceduresAndParam(ADOprp); } //End Course name //--Start Local Text Editor. public string UpdLocalText(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[4]; ADOprp.ArrayPram[0] = new SqlParameter("@textID", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@textTitle", objprp.title); ADOprp.ArrayPram[2] = new SqlParameter("@textDescription", objprp.description); ADOprp.ArrayPram[3] = new SqlParameter("@isActive", objprp.isActive); ADOprp.SPName = "updLocalText"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelLocalText(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@textID", objprp.id); ADOprpDL.SPName = "selLocalText"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["textID"].ToString(); obj.title = ADOprpDL.Dr["textTitle"].ToString(); obj.description = ADOprpDL.Dr["textDescription"].ToString(); obj.isActive = ADOprpDL.Dr["isActive"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } //--End Local Text Editor. //--Start Course Text Editor. public string InsCourseText(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[7]; ADOprp.ArrayPram[0] = new SqlParameter("@textUniID", objprp.uniID); ADOprp.ArrayPram[1] = new SqlParameter("@textCatID", objprp.catID); ADOprp.ArrayPram[2] = new SqlParameter("@textTitle", objprp.title); ADOprp.ArrayPram[3] = new SqlParameter("@textDescription", objprp.description); ADOprp.ArrayPram[4] = new SqlParameter("@textImageUrl", objprp.urlPath); ADOprp.ArrayPram[5] = new SqlParameter("@isActive", objprp.isActive); ADOprp.ArrayPram[6] = new SqlParameter("@Branchid", objprp.branchId); ADOprp.SPName = "insCourseText"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdCourseText(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[8]; ADOprp.ArrayPram[0] = new SqlParameter("@textID", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@textCatID", objprp.catID); ADOprp.ArrayPram[2] = new SqlParameter("@textUniID", objprp.uniID); ADOprp.ArrayPram[3] = new SqlParameter("@textTitle", objprp.title); ADOprp.ArrayPram[4] = new SqlParameter("@textDescription", objprp.description); ADOprp.ArrayPram[5] = new SqlParameter("@textImageUrl", objprp.urlPath); ADOprp.ArrayPram[6] = new SqlParameter("@isActive", objprp.isActive); ADOprp.ArrayPram[7] = new SqlParameter("@Branchid", objprp.branchId); ADOprp.SPName = "updCourseText"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string DelCourseText(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@textID", objprp.id); ADOprp.SPName = "delCourseText"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelCourseText(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@textID", objprp.id); ADOprpDL.SPName = "selCourseText"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["textID"].ToString(); obj.title = ADOprpDL.Dr["textTitle"].ToString(); obj.urlPath = ADOprpDL.Dr["ImagePath"].ToString(); obj.description = ADOprpDL.Dr["textDescription"].ToString(); obj.catID = ADOprpDL.Dr["textCatID"].ToString(); obj.uniID = ADOprpDL.Dr["textUniID"].ToString(); obj.isActive = ADOprpDL.Dr["isActive"].ToString(); obj.branchId = ADOprpDL.Dr["Branchid"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } public List SelCourseText1(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[3]; ADOprpDL.ArrayPram[0] = new SqlParameter("@uniId", objprp.uniID); ADOprpDL.ArrayPram[1] = new SqlParameter("@catId", objprp.catID); ADOprpDL.ArrayPram[2] = new SqlParameter("@id", objprp.id); ADOprpDL.SPName = "selCourseText1"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["textID"].ToString(); obj.title = ADOprpDL.Dr["textTitle"].ToString(); obj.urlPath = ADOprpDL.Dr["ImagePath"].ToString(); obj.description = ADOprpDL.Dr["textDescription"].ToString(); obj.catID = ADOprpDL.Dr["textCatID"].ToString(); obj.uniID = ADOprpDL.Dr["textUniID"].ToString(); obj.isActive = ADOprpDL.Dr["isActive"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List ViewCourseText(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[4]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.ArrayPram[2] = new SqlParameter("@uniID", prp.uniID); ADOprpDL.ArrayPram[3] = new SqlParameter("@catID", prp.catID); ADOprpDL.SPName = "viewCourseText"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["textID"].ToString(); objprp.title = ADOprpDL.Dr["textTitle"].ToString(); objprp.urlPath = ADOprpDL.Dr["ImagePath"].ToString(); objprp.description = ADOprpDL.Dr["textDescription"].ToString(); objprp.uniID = ADOprpDL.Dr["uniName"].ToString(); objprp.catID = ADOprpDL.Dr["CatName"].ToString(); objprp.isActive = ADOprpDL.Dr["isActive"].ToString(); objprp.codeId = ADOprpDL.Dr["BranchId"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } //--End Course Text Editor. //--Start--News Type. public string InsNewsType(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[2]; ADOprp.ArrayPram[0] = new SqlParameter("@typeName", objprp.name); //ADOprp.ArrayPram[1] = new SqlParameter("@uniID", objprp.uniID); ADOprp.ArrayPram[1] = new SqlParameter("@isActive", objprp.isActive); ADOprp.SPName = "insNewsType"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdNewsType(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[3]; ADOprp.ArrayPram[0] = new SqlParameter("@typeID", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@typeName", objprp.name); //ADOprp.ArrayPram[1] = new SqlParameter("@uniID", objprp.uniID); ADOprp.ArrayPram[2] = new SqlParameter("@isActive", objprp.isActive); ADOprp.SPName = "updNewsType"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string DelNewsType(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@typeID", objprp.id); ADOprp.SPName = "delNewsType"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelNewsType(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@typeID", objprp.id); ADOprpDL.SPName = "selNewsType"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj.id = ADOprpDL.Dr["typeID"].ToString(); obj.name = ADOprpDL.Dr["typeName"].ToString(); obj.isActive = ADOprpDL.Dr["isActive"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } //public DataTable ViewNewsType(PRPSetup objprp) //{ // ADOprp.ArrayPram = new SqlParameter[1]; // ADOprp.ArrayPram[0] = new SqlParameter("@status", objprp.status); // ADOprp.SPName = "viewNewsType"; // return ADO.DataTableWithProcedures(ADOprp); //} //--End--News Type //--Start--News. public string InsNews(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[6]; ADOprp.ArrayPram[0] = new SqlParameter("@uniID", objprp.uniID); ADOprp.ArrayPram[1] = new SqlParameter("@catID", objprp.catID); ADOprp.ArrayPram[2] = new SqlParameter("@newsTitle", objprp.title); ADOprp.ArrayPram[3] = new SqlParameter("@newsDescription", objprp.description); ADOprp.ArrayPram[4] = new SqlParameter("@isActive", objprp.isActive); ADOprp.ArrayPram[5] = new SqlParameter("@imgStatus", objprp.status); ADOprp.SPName = "insNews"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdNews(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[7]; ADOprp.ArrayPram[0] = new SqlParameter("@newsID", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@uniID", objprp.uniID); ADOprp.ArrayPram[2] = new SqlParameter("@catID", objprp.catID); ADOprp.ArrayPram[3] = new SqlParameter("@newsTitle", objprp.title); ADOprp.ArrayPram[4] = new SqlParameter("@newsDescription", objprp.description); ADOprp.ArrayPram[5] = new SqlParameter("@isActive", objprp.isActive); ADOprp.ArrayPram[6] = new SqlParameter("@imgStatus", objprp.status); ADOprp.SPName = "updNews"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string DelNews(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@newsID", objprp.id); ADOprp.SPName = "delNews"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelNews(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@newsID", objprp.id); ADOprpDL.SPName = "selNews"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["newsID"].ToString(); obj.title = ADOprpDL.Dr["newsTitle"].ToString(); obj.description = ADOprpDL.Dr["newsDescription"].ToString(); obj.catID = ADOprpDL.Dr["newsTypeID"].ToString(); obj.uniID = ADOprpDL.Dr["newsUniversityID"].ToString(); obj.DOJ = ADOprpDL.Dr["newsDate"].ToString(); obj.isActive = ADOprpDL.Dr["isActive"].ToString(); obj.status = ADOprpDL.Dr["imgStatus"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } //-------------------------View New Detail---------------// public List view_NewDetail(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[3]; ADOprpDL.ArrayPram[0] = new SqlParameter("@unid", objprp.uniID); ADOprpDL.ArrayPram[1] = new SqlParameter("@typeid", objprp.catID); ADOprpDL.ArrayPram[2] = new SqlParameter("@newid", objprp.id); ADOprpDL.SPName = "view_NewDetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["newsID"].ToString(); obj.title = ADOprpDL.Dr["newsTitle"].ToString(); obj.description = ADOprpDL.Dr["newsDescription"].ToString(); obj.catID = ADOprpDL.Dr["newsTypeID"].ToString(); obj.DOJ = ADOprpDL.Dr["newsDate"].ToString(); obj.isActive = ADOprpDL.Dr["isActive"].ToString(); obj.status = ADOprpDL.Dr["imgStatus"].ToString(); obj.pageurl = ADOprpDL.Dr["pageurl"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } //------------------------------View Jack state-------// public List selState(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@stateId", objprp.Stid); ADOprpDL.SPName = "selState"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["stateId"].ToString(); obj.title = ADOprpDL.Dr["stateName"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List selState1(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@stateId", objprp.Stid1); ADOprpDL.SPName = "selState"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["stateId"].ToString(); obj.title = ADOprpDL.Dr["stateName"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } //---------------------------View jack Distict----------// public List viewDistrict(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@Id", objprp.Stid); ADOprpDL.SPName = "viewDistrict"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["id"].ToString(); obj.title = ADOprpDL.Dr["name"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List viewDistrict1(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@Id", objprp.Stid1); ADOprpDL.SPName = "viewDistrict"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["id"].ToString(); obj.title = ADOprpDL.Dr["name"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List ViewNews(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.SPName = "viewNews"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["newsID"].ToString(); objprp.title = ADOprpDL.Dr["newsTitle"].ToString(); objprp.description = ADOprpDL.Dr["newsDescription"].ToString(); objprp.catID = ADOprpDL.Dr["newsType"].ToString(); objprp.uniID = ADOprpDL.Dr["uniName"].ToString(); objprp.DOJ = ADOprpDL.Dr["newsDate"].ToString(); objprp.isActive = ADOprpDL.Dr["isActive"].ToString(); objprp.status = ADOprpDL.Dr["imgStatus"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public List ViewNews1(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@newsType", prp.catID); ADOprpDL.SPName = "viewNews1"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["newsID"].ToString(); objprp.title = ADOprpDL.Dr["newsTitle"].ToString(); objprp.description = ADOprpDL.Dr["newsDescription"].ToString(); objprp.DOJ = ADOprpDL.Dr["newsDate"].ToString(); objprp.status = ADOprpDL.Dr["imgStatus"].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } //--End--News. //--Start--New Job. public string InsJob(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[3]; ADOprp.ArrayPram[0] = new SqlParameter("@JobTitle", objprp.title); ADOprp.ArrayPram[1] = new SqlParameter("@JobDescription", objprp.description); ADOprp.ArrayPram[2] = new SqlParameter("@isActive", objprp.isActive); ADOprp.SPName = "insJob"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdJob(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[4]; ADOprp.ArrayPram[0] = new SqlParameter("@JobID", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@JobTitle", objprp.title); ADOprp.ArrayPram[2] = new SqlParameter("@JobDescription", objprp.description); ADOprp.ArrayPram[3] = new SqlParameter("@isActive", objprp.isActive); ADOprp.SPName = "updJob"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string DelJob(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@JobID", objprp.id); ADOprp.SPName = "delJob"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelJob(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@JobID", objprp.id); ADOprpDL.SPName = "selJob"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["jobID"].ToString(); obj.title = ADOprpDL.Dr["jobTitle"].ToString(); obj.description = ADOprpDL.Dr["jobDescription"].ToString(); obj.DOJ = ADOprpDL.Dr["postedOn"].ToString(); obj.isActive = ADOprpDL.Dr["isActive"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } public List ViewJob(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.SPName = "viewJob"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["jobID"].ToString(); objprp.title = ADOprpDL.Dr["jobTitle"].ToString(); objprp.description = ADOprpDL.Dr["jobDescription"].ToString(); objprp.DOJ = ADOprpDL.Dr["postedOn"].ToString(); objprp.isActive = ADOprpDL.Dr["isActive"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public List ViewJob1(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.SPName = "viewJob1"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["jobID"].ToString(); objprp.title = ADOprpDL.Dr["jobTitle"].ToString(); objprp.description = ADOprpDL.Dr["jobDescription"].ToString(); objprp.DOJ = ADOprpDL.Dr["postedOn"].ToString(); objprp.isActive = ADOprpDL.Dr["isActive"].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } //--End--New Job. //--Start Resume Detail. public string InsResumeDetail(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[7]; ADOprp.ArrayPram[0] = new SqlParameter("@resumeName", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@resumeMobNo", objprp.mobNo); ADOprp.ArrayPram[2] = new SqlParameter("@resumeEmailID", objprp.emailID); ADOprp.ArrayPram[3] = new SqlParameter("@resumeSubject", objprp.title); ADOprp.ArrayPram[4] = new SqlParameter("@resumeDescription", objprp.description); ADOprp.ArrayPram[5] = new SqlParameter("@resumePath", objprp.urlPath); ADOprp.ArrayPram[6] = new SqlParameter("@resumeJobID", objprp.catID); ADOprp.SPName = "insResumeDetail"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdResumeDetail(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[2]; ADOprp.ArrayPram[0] = new SqlParameter("@resumeID", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@isActive", objprp.isActive); ADOprp.SPName = "updResumeDetail"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //public string DeleteCourse(PRPSetup objprp) //{ // ADOprp.ArrayPram = new SqlParameter[1]; // ADOprp.ArrayPram[0] = new SqlParameter("@CourseID", objprp.id); // ADOprp.SPName = "delCourse"; // return ADO.ScalarQueryWithProceduresandParam(ADOprp); //} public string GetMaxFileId() { ADOprp.SPName = "getMaxId"; return ADO.ScalarQueryWithProcedures(ADOprp); } public List ViewResumeDetail(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.SPName = "viewResumeDetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["resumeID"].ToString(); objprp.name = ADOprpDL.Dr["personName"].ToString(); objprp.mobNo = ADOprpDL.Dr["mobileNo"].ToString(); objprp.emailID = ADOprpDL.Dr["emailID"].ToString(); objprp.title = ADOprpDL.Dr["subjects"].ToString(); objprp.description = ADOprpDL.Dr["msg"].ToString(); objprp.urlPath = ADOprpDL.Dr["resumePath"].ToString(); objprp.catID = ADOprpDL.Dr["jobTitle"].ToString(); objprp.DOJ = ADOprpDL.Dr["postedOn"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } //--End Resume Detail //--Start Resume Detail. public string InsBranchRequestDetail(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[5]; ADOprp.ArrayPram[0] = new SqlParameter("@name", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@MobNo", objprp.mobNo); ADOprp.ArrayPram[2] = new SqlParameter("@EmailID", objprp.emailID); ADOprp.ArrayPram[3] = new SqlParameter("@orgName", objprp.title); ADOprp.ArrayPram[4] = new SqlParameter("@address", objprp.description); ADOprp.SPName = "insBranchRequestDetail"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string DelBranchRequestDetail(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@branchId", objprp.id); ADOprp.SPName = "delBranchRequestDetail"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public List ViewBranchRequestDetail(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.SPName = "viewBranchRequestDetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["branchId"].ToString(); objprp.title = ADOprpDL.Dr["orgName"].ToString(); objprp.name = ADOprpDL.Dr["Name"].ToString(); objprp.mobNo = ADOprpDL.Dr["mobileNo"].ToString(); objprp.emailID = ADOprpDL.Dr["emailID"].ToString(); objprp.description = ADOprpDL.Dr["address"].ToString(); objprp.DOJ = ADOprpDL.Dr["postedOn"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } //--End Resume Detail //--Start Text Editor. public string InsText(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[10]; ADOprp.ArrayPram[0] = new SqlParameter("@textUniID", objprp.uniID); ADOprp.ArrayPram[1] = new SqlParameter("@textCatID", objprp.catID); ADOprp.ArrayPram[2] = new SqlParameter("@textTitle", objprp.title); ADOprp.ArrayPram[3] = new SqlParameter("@textDescription", objprp.description); ADOprp.ArrayPram[4] = new SqlParameter("@textImageUrl", objprp.urlPath); ADOprp.ArrayPram[5] = new SqlParameter("@isActive", objprp.isActive); ADOprp.ArrayPram[6] = new SqlParameter("@textsubtitle", objprp.textsubtitle); ADOprp.ArrayPram[7] = new SqlParameter("@textpagetitle", objprp.textpagetitle); ADOprp.ArrayPram[8] = new SqlParameter("@textkeyword", objprp.textkeyword); ADOprp.ArrayPram[9] = new SqlParameter("@textseodescription", objprp.textseodescription); ADOprp.SPName = "insText"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdText(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[11]; ADOprp.ArrayPram[0] = new SqlParameter("@textID", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@textCatID", objprp.catID); ADOprp.ArrayPram[2] = new SqlParameter("@textUniID", objprp.uniID); ADOprp.ArrayPram[3] = new SqlParameter("@textTitle", objprp.title); ADOprp.ArrayPram[4] = new SqlParameter("@textDescription", objprp.description); ADOprp.ArrayPram[5] = new SqlParameter("@textImageUrl", objprp.urlPath); ADOprp.ArrayPram[6] = new SqlParameter("@isActive", objprp.isActive); ADOprp.ArrayPram[7] = new SqlParameter("@textsubtitle", objprp.textsubtitle); ADOprp.ArrayPram[8] = new SqlParameter("@textpagetitle", objprp.textpagetitle); ADOprp.ArrayPram[9] = new SqlParameter("@textkeyword", objprp.textkeyword); ADOprp.ArrayPram[10] = new SqlParameter("@textseodescription", objprp.textseodescription); ADOprp.SPName = "updText"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string DelText(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@textID", objprp.id); ADOprp.SPName = "delText"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelText(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@textID", objprp.id); ADOprpDL.SPName = "selText"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["textID"].ToString(); obj.title = ADOprpDL.Dr["textTitle"].ToString(); obj.urlPath = ADOprpDL.Dr["ImagePath"].ToString(); obj.description = ADOprpDL.Dr["textDescription"].ToString(); obj.catID = ADOprpDL.Dr["textCatID"].ToString(); obj.uniID = ADOprpDL.Dr["textUniID"].ToString(); obj.isActive = ADOprpDL.Dr["isActive"].ToString(); obj.textsubtitle = ADOprpDL.Dr["textsubtitle"].ToString(); obj.textpagetitle = ADOprpDL.Dr["textpagetitle"].ToString(); obj.textkeyword = ADOprpDL.Dr["textkeyword"].ToString(); obj.textseodescription = ADOprpDL.Dr["textseodescription"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } public List SelText1(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[3]; ADOprpDL.ArrayPram[0] = new SqlParameter("@uniId", objprp.uniID); ADOprpDL.ArrayPram[1] = new SqlParameter("@catId", objprp.catID); ADOprpDL.ArrayPram[2] = new SqlParameter("@textid", objprp.id); ADOprpDL.SPName = "selText1"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["textID"].ToString(); obj.title = ADOprpDL.Dr["textTitle"].ToString(); obj.urlPath = ADOprpDL.Dr["ImagePath"].ToString(); obj.description = ADOprpDL.Dr["textDescription"].ToString(); obj.catID = ADOprpDL.Dr["textCatID"].ToString(); obj.uniID = ADOprpDL.Dr["textUniID"].ToString(); obj.isActive = ADOprpDL.Dr["isActive"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List view_TextDetail(PRPSetup objprp) { List lst = new List(); try { ADOprpDL.ArrayPram = new SqlParameter[3]; ADOprpDL.ArrayPram[0] = new SqlParameter("@uniId", objprp.uniID); ADOprpDL.ArrayPram[1] = new SqlParameter("@catId", objprp.catID); ADOprpDL.ArrayPram[2] = new SqlParameter("@textid", objprp.id); ADOprpDL.SPName = "view_TextDetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["textID"].ToString(); obj.title = ADOprpDL.Dr["textTitle"].ToString(); obj.subtitle = ADOprpDL.Dr["textsubtitle"].ToString(); obj.urlPath = ADOprpDL.Dr["ImagePath"].ToString(); obj.description = ADOprpDL.Dr["textDescription"].ToString(); obj.catID = ADOprpDL.Dr["textCatID"].ToString(); obj.urlName = ADOprpDL.Dr["txtCatName"].ToString(); obj.textpagetitle = ADOprpDL.Dr["textpagetitle"].ToString(); obj.isActive = ADOprpDL.Dr["isActive"].ToString(); obj.textsubtitle = ADOprpDL.Dr["textpagetitle"].ToString(); obj.textkeyword = ADOprpDL.Dr["textkeyword"].ToString(); obj.textseodescription = ADOprpDL.Dr["textseodescription"].ToString(); obj.pageurl = ADOprpDL.Dr["pageurl"].ToString(); obj.Isertingdate = ADOprpDL.Dr["Insertdate"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); } catch { } return lst; } //------------------View Full Course type detail----------- public List view_coursetype_new(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@ctypeid", objprp.uniID); ADOprpDL.SPName = "view_coursetype_new"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.uniID = ADOprpDL.Dr["ctypeid"].ToString(); obj.urlName = ADOprpDL.Dr["ctypename"].ToString(); obj.description = ADOprpDL.Dr["ctypedetail"].ToString(); obj.typeurl = ADOprpDL.Dr["typeurl"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } //-------------------------this is Training form------------------------// public DataTable View_facility() { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.SPName = "Bind_Facility"; return ADO.DataTableWithProcedures(ADOprpDL); } public string insertForm(Registration objprp) { ADOprp.ArrayPram = new SqlParameter[34]; ADOprp.ArrayPram[0] = new SqlParameter("@tcName", objprp.Name); ADOprp.ArrayPram[1] = new SqlParameter("@tcGeoLocation", objprp.GeoLocation); ADOprp.ArrayPram[2] = new SqlParameter("@tcOwnership", objprp.OwnerShip); ADOprp.ArrayPram[3] = new SqlParameter("@tcType", objprp.Type); ADOprp.ArrayPram[4] = new SqlParameter("@tcFaculty_Type", objprp.Faculty_Type); ADOprp.ArrayPram[5] = new SqlParameter("@tcDocument", objprp.Document); ADOprp.ArrayPram[6] = new SqlParameter("@tcCreate_date", objprp.CreateDate); ADOprp.ArrayPram[7] = new SqlParameter("@tcArea", objprp.Area); ADOprp.ArrayPram[8] = new SqlParameter("@tcTrainingRooms", objprp.TrainingRoom); ADOprp.ArrayPram[9] = new SqlParameter("@tcLabs", objprp.Labs); ADOprp.ArrayPram[10] = new SqlParameter("@tcMale_WashRoom", objprp.Male_WashRoom); ADOprp.ArrayPram[11] = new SqlParameter("@tcFemale_WashRoom", objprp.Female_WashRoom); ADOprp.ArrayPram[12] = new SqlParameter("@tcUnisex_WashRoom", objprp.Unisex_WashRoom); ADOprp.ArrayPram[13] = new SqlParameter("@tcAddress", objprp.Address); ADOprp.ArrayPram[14] = new SqlParameter("@tcLandMark", objprp.LandMarks); ADOprp.ArrayPram[15] = new SqlParameter("@tcPinCode", objprp.PinCode); ADOprp.ArrayPram[16] = new SqlParameter("@tcState", objprp.State); ADOprp.ArrayPram[17] = new SqlParameter("@tcDistrict", objprp.District); ADOprp.ArrayPram[18] = new SqlParameter("@tcTehsil", objprp.Tehsil); ADOprp.ArrayPram[19] = new SqlParameter("@tcCity", objprp.City); ADOprp.ArrayPram[20] = new SqlParameter("@tcParliamentary_Constituency", objprp.Costituencey); ADOprp.ArrayPram[21] = new SqlParameter("@tcAddress_Prooftype", objprp.Address_Prooftype); ADOprp.ArrayPram[22] = new SqlParameter("@spiName", objprp.SPName); ADOprp.ArrayPram[23] = new SqlParameter("@spiEmail", objprp.SPMail); ADOprp.ArrayPram[24] = new SqlParameter("@spiMobile", objprp.SPMobile); ADOprp.ArrayPram[25] = new SqlParameter("@spiDesignation", objprp.SPDesignation); ADOprp.ArrayPram[26] = new SqlParameter("@spiLandLine", objprp.SPLandLine); ADOprp.ArrayPram[27] = new SqlParameter("@spiPhoto", objprp.SPPhoto); ADOprp.ArrayPram[28] = new SqlParameter("@spiExternal_Photo", objprp.SPExternal_Photo); ADOprp.ArrayPram[29] = new SqlParameter("@spiClassRoom_Photo", objprp.SPClassRoom_Photo); ADOprp.ArrayPram[30] = new SqlParameter("@spiLab_Photo", objprp.SPLab_Photo); ADOprp.ArrayPram[31] = new SqlParameter("@spiFacility_Photo", objprp.SPFacility_Photo); ADOprp.ArrayPram[32] = new SqlParameter("@totalwashroom", objprp.Total_WashRoom); ADOprp.ArrayPram[33] = new SqlParameter("@tcAddress_Proof", objprp.Address_Proof); ADOprp.SPName = "insTrainingCenter"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string insertquery(string st) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@query", st); ADOprp.SPName = "query"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //---------------------------View Full Course Category Detail-------------// public List view_fullcoursecategory_detail(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@catcoursetype", objprp.uniID); ADOprpDL.ArrayPram[1] = new SqlParameter("@catid", objprp.catID); ADOprpDL.SPName = "view_fullcoursecategory_detail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["catid"].ToString(); obj.title = ADOprpDL.Dr["courseName"].ToString(); obj.urlName = ADOprpDL.Dr["CatName"].ToString(); obj.description = ADOprpDL.Dr["ctypedetail"].ToString(); obj.catID = ADOprpDL.Dr["catcoursetype"].ToString(); obj.textsubtitle = ADOprpDL.Dr["catdetail"].ToString(); obj.pageurl = ADOprpDL.Dr["caturl"].ToString(); obj.SideImg = ADOprpDL.Dr["catImage"].ToString(); obj.Coursetypeimage = ADOprpDL.Dr["ctypeImage"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } //----------------------------View Full course Detail-----------------// //public List view_fullcoursedetail(PRPSetup objprp) //{ // ADOprpDL.ArrayPram = new SqlParameter[3]; // ADOprpDL.ArrayPram[0] = new SqlParameter("@catcoursetype", objprp.uniID); // ADOprpDL.ArrayPram[1] = new SqlParameter("@courseCatid", objprp.catID); // ADOprpDL.ArrayPram[2] = new SqlParameter("@feecourseid", objprp.courseId); // ADOprpDL.SPName = "view_fullcoursedetail"; // ADO.ReaderWithProceduresandParam(ADOprpDL); // PRPSetup obj = new PRPSetup(); ; // List lst = new List(); // if (ADOprpDL.Dr.HasRows) // { // while (ADOprpDL.Dr.Read()) // { // obj = new PRPSetup(); // obj.id = ADOprpDL.Dr["feecourseid"].ToString(); // obj.title = ADOprpDL.Dr["coursename"].ToString(); // obj.urlName = ADOprpDL.Dr["ctypename"].ToString(); // obj.description = ADOprpDL.Dr["coursecontent"].ToString(); // obj.urlName = ADOprpDL.Dr["catName"].ToString(); // obj.pageurl = ADOprpDL.Dr["pageurl"].ToString(); // lst.Add(obj); // } // } // ADO.ReaderClose(ADOprpDL); // return lst; //} public List view_fullcoursedetail(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[3]; ADOprpDL.ArrayPram[0] = new SqlParameter("@catcoursetype", objprp.uniID); ADOprpDL.ArrayPram[1] = new SqlParameter("@courseCatid", objprp.catID); ADOprpDL.ArrayPram[2] = new SqlParameter("@feecourseid", objprp.courseId); ADOprpDL.SPName = "view_fullcoursedetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["feecourseid"].ToString(); obj.catID = ADOprpDL.Dr["coursecatid"].ToString(); obj.uniID = ADOprpDL.Dr["catCourseType"].ToString(); obj.title = ADOprpDL.Dr["coursename"].ToString(); obj.mastercoursedetailimage = ADOprpDL.Dr["courseimage"].ToString(); obj.urlName = ADOprpDL.Dr["ctypename"].ToString(); obj.description = ADOprpDL.Dr["coursecontent"].ToString(); obj.urlName = ADOprpDL.Dr["catName"].ToString(); obj.categorydetails = ADOprpDL.Dr["catdetail"].ToString(); obj.pageurl = ADOprpDL.Dr["pageurl"].ToString(); obj.name = ADOprpDL.Dr["feesemname"].ToString(); obj.coursefee = ADOprpDL.Dr["feeTotalFee"].ToString(); obj.courseduraction = ADOprpDL.Dr["courseTime"].ToString(); obj.phoneCode = ADOprpDL.Dr["coursecode"].ToString(); obj.shortdetail = ADOprpDL.Dr["ctypedetail"].ToString(); obj.overviewdetail = ADOprpDL.Dr["overviewdetail"].ToString(); obj.overviewpic = ADOprpDL.Dr["overviewPicture"].ToString(); obj.coursecategoryimage = ADOprpDL.Dr["catImage"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } //---------------Show Course to Web---------------// public List view_fullcoursedetail_ForWeb(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[3]; ADOprpDL.ArrayPram[0] = new SqlParameter("@catcoursetype", objprp.uniID); ADOprpDL.ArrayPram[1] = new SqlParameter("@courseCatid", objprp.catID); ADOprpDL.ArrayPram[2] = new SqlParameter("@feecourseid", objprp.courseId); ADOprpDL.SPName = "view_fullcoursedetail_ForWeb"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["feecourseid"].ToString(); obj.catID = ADOprpDL.Dr["coursecatid"].ToString(); obj.uniID = ADOprpDL.Dr["catCourseType"].ToString(); obj.title = ADOprpDL.Dr["coursename"].ToString(); obj.urlName = ADOprpDL.Dr["ctypename"].ToString(); obj.description = ADOprpDL.Dr["coursecontent"].ToString(); obj.urlName = ADOprpDL.Dr["catName"].ToString(); obj.pageurl = ADOprpDL.Dr["pageurl"].ToString(); obj.name = ADOprpDL.Dr["feesemname"].ToString(); obj.coursefee = ADOprpDL.Dr["feecoursefee"].ToString(); obj.phoneCode = ADOprpDL.Dr["coursecode"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List ViewText(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.SPName = "viewText"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["textID"].ToString(); objprp.title = ADOprpDL.Dr["textTitle"].ToString(); objprp.urlPath = ADOprpDL.Dr["ImagePath"].ToString(); objprp.description = ADOprpDL.Dr["textDescription"].ToString(); objprp.uniID = ADOprpDL.Dr["uniName"].ToString(); objprp.catID = ADOprpDL.Dr["txtCatName"].ToString(); objprp.isActive = ADOprpDL.Dr["isActive"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } //--Start Text Category. //--Start Text Category. public string InsTextCategory(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[3]; ADOprp.ArrayPram[0] = new SqlParameter("@catName", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@uniID", objprp.uniID); ADOprp.ArrayPram[2] = new SqlParameter("@isActive", objprp.isActive); ADOprp.SPName = "insTextCategory"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdTextCategory(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[4]; ADOprp.ArrayPram[0] = new SqlParameter("@catID", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@catName", objprp.name); ADOprp.ArrayPram[2] = new SqlParameter("@uniID", objprp.uniID); ADOprp.ArrayPram[3] = new SqlParameter("@isActive", objprp.isActive); ADOprp.SPName = "updTextCategory"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string DelTextCategory(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@catID", objprp.id); ADOprp.SPName = "delTextCategory"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelTextCategory(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@catID", objprp.id); ADOprpDL.SPName = "selTextCategory"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj.id = ADOprpDL.Dr["txtcatID"].ToString(); obj.name = ADOprpDL.Dr["txtcatName"].ToString(); obj.isActive = ADOprpDL.Dr["isActive"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } public DataTable ViewTextCategory(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@status", objprp.status); ADOprp.SPName = "ViewTextCategory"; return ADO.DataTableWithProcedures(ADOprp); } //--End Text Category. //--Start Image Category. public string InsImageCategory(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[3]; ADOprp.ArrayPram[0] = new SqlParameter("@catName", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@uniID", objprp.uniID); ADOprp.ArrayPram[2] = new SqlParameter("@isActive", objprp.isActive); ADOprp.SPName = "insImageCategory"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdImageCategory(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[4]; ADOprp.ArrayPram[0] = new SqlParameter("@catID", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@catName", objprp.name); ADOprp.ArrayPram[2] = new SqlParameter("@uniID", objprp.uniID); ADOprp.ArrayPram[3] = new SqlParameter("@isActive", objprp.isActive); ADOprp.SPName = "updImageCategory"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string DelImageCategory(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@catID", objprp.id); ADOprp.SPName = "delImageCategory"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelImageCategory(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@catID", objprp.id); ADOprpDL.SPName = "selImageCategory"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj.id = ADOprpDL.Dr["catID"].ToString(); obj.name = ADOprpDL.Dr["catName"].ToString(); obj.isActive = ADOprpDL.Dr["isActive"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } public DataTable viewcatwaisedata(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@id", objprp.catID); ADOprp.SPName = "view_subcategory"; return ADO.DataTableWithProceduresAndParam(ADOprp); } public DataTable ViewImageCategory(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@status", objprp.status); ADOprp.SPName = "ViewImageCategory"; return ADO.DataTableWithProcedures(ADOprp); } //--End Image Category. //--Start Image Gallery public string InsImageGallery(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[7]; ADOprp.ArrayPram[0] = new SqlParameter("@imageTitle", objprp.title); ADOprp.ArrayPram[1] = new SqlParameter("@description", objprp.description); ADOprp.ArrayPram[2] = new SqlParameter("@urlName", objprp.urlName); ADOprp.ArrayPram[3] = new SqlParameter("@uniID", objprp.uniID); ADOprp.ArrayPram[4] = new SqlParameter("@catID", objprp.catID); ADOprp.ArrayPram[5] = new SqlParameter("@urlPath", objprp.urlPath); ADOprp.ArrayPram[6] = new SqlParameter("@isActive", objprp.isActive); ADOprp.SPName = "insImageGallery"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdImageGallery(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[8]; ADOprp.ArrayPram[0] = new SqlParameter("@imageId", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@imageTitle", objprp.title); ADOprp.ArrayPram[2] = new SqlParameter("@description", objprp.description); ADOprp.ArrayPram[3] = new SqlParameter("@urlName", objprp.urlName); ADOprp.ArrayPram[4] = new SqlParameter("@uniID", objprp.uniID); ADOprp.ArrayPram[5] = new SqlParameter("@catID", objprp.catID); ADOprp.ArrayPram[6] = new SqlParameter("@urlPath", objprp.urlPath); ADOprp.ArrayPram[7] = new SqlParameter("@isActive", objprp.isActive); ADOprp.SPName = "updImageGallery"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string DelImageGallery(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@imageId", objprp.id); ADOprp.SPName = "delImageGallery"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public PRPSetup SelImageGallery(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@imageID", objprp.id); ADOprpDL.SPName = "selImageGallery"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; if (ADOprpDL.Dr.HasRows) {//imageId,imageTitle,imagePath,imageSubTitle,imageDescription,uniID,catID,isActive while (ADOprpDL.Dr.Read()) { obj.title = ADOprpDL.Dr["imageTitle"].ToString(); obj.id = ADOprpDL.Dr["imageId"].ToString(); obj.urlPath = ADOprpDL.Dr["imagePath"].ToString(); obj.urlName = ADOprpDL.Dr["imageSubTitle"].ToString(); obj.description = ADOprpDL.Dr["imageDescription"].ToString(); obj.uniID = ADOprpDL.Dr["uniID"].ToString(); obj.catID = ADOprpDL.Dr["catID"].ToString(); obj.isActive = ADOprpDL.Dr["isActive"].ToString(); } } ADO.ReaderClose(ADOprpDL); return obj; } public List ViewImageGallery(PRPSetup obj) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@uniID", obj.uniID); ADOprpDL.ArrayPram[1] = new SqlParameter("@catID", obj.catID); ADOprpDL.SPName = "viewImageGallery"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["imageID"].ToString(); objprp.title = ADOprpDL.Dr["imageTitle"].ToString(); objprp.urlPath = ADOprpDL.Dr["imagePath"].ToString(); objprp.isActive = ADOprpDL.Dr["isActive"].ToString(); objprp.description = ADOprpDL.Dr["imageSubTitle"].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } //--End Image Gallery //--Start Link file Upload. public string InsFile(PRPSetup obj) { ADOprp.ArrayPram = new SqlParameter[4]; ADOprp.ArrayPram[0] = new SqlParameter("@linkUniversity", obj.uniID); ADOprp.ArrayPram[1] = new SqlParameter("@linkName", obj.name); ADOprp.ArrayPram[2] = new SqlParameter("@linkPath", obj.urlPath); ADOprp.ArrayPram[3] = new SqlParameter("@isActive", obj.isActive); ADOprp.SPName = "insFileDetail"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string UpdFile(PRPSetup obj) { ADOprp.ArrayPram = new SqlParameter[5]; ADOprp.ArrayPram[0] = new SqlParameter("@linkID", obj.id); ADOprp.ArrayPram[1] = new SqlParameter("@linkUniversity", obj.uniID); ADOprp.ArrayPram[2] = new SqlParameter("@linkName", obj.name); ADOprp.ArrayPram[3] = new SqlParameter("@linkPath", obj.urlPath); ADOprp.ArrayPram[4] = new SqlParameter("@isActive", obj.isActive); ADOprp.SPName = "updFileDetail"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public List ViewFile(PRPSetup obj) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", obj.id); // ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", obj.pageIndex); // ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", obj.pageSize); ADOprpDL.SPName = "viewFileDetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["id"].ToString(); objprp.name = ADOprpDL.Dr["name"].ToString(); objprp.mobNo = ADOprpDL.Dr["downLinkPath"].ToString(); objprp.emailID = ADOprpDL.Dr["downUniID"].ToString(); objprp.title = ADOprpDL.Dr["isActive"].ToString(); lst.Add(objprp); } //if (ADOprpDL.Dr.NextResult()) //{ // ADOprpDL.Dr.Read(); // objprp = new PRPSetup(); // objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); // lst.Add(objprp); //} } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public PRPSetup SelFile(PRPSetup obj) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@LinkID", obj.id); ADOprpDL.SPName = "selFileDetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp = new PRPSetup(); ; // List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp.id = ADOprpDL.Dr["downID"].ToString(); objprp.name = ADOprpDL.Dr["downLinkName"].ToString(); objprp.urlPath = ADOprpDL.Dr["downLinkPath"].ToString(); objprp.uniID = ADOprpDL.Dr["downUniID"].ToString(); objprp.isActive = ADOprpDL.Dr["isActive"].ToString(); } } ADO.ReaderClose(ADOprpDL); return objprp; } public string DelFile(PRPSetup obj) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@linkID", obj.id); ADOprp.SPName = "delFileDetail"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //--End Link File upload. //--Start Enquiry Detail. public string InsEnquiryRequestDetail(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[4]; ADOprp.ArrayPram[0] = new SqlParameter("@name", objprp.name); ADOprp.ArrayPram[1] = new SqlParameter("@mobile", objprp.mobNo); ADOprp.ArrayPram[2] = new SqlParameter("@Email", objprp.emailID); ADOprp.ArrayPram[3] = new SqlParameter("@Message", objprp.description); //ADOprp.ArrayPram[4] = new SqlParameter("@address", objprp.description); ADOprp.SPName = "Insenquirydetail"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string DelEnquiryRequestDetail(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@enqid", objprp.id); ADOprp.SPName = "delenquirydetail"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public List ViewEnquiryRequestDetail(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.SPName = "viewEnquiryRequestDetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["branchId"].ToString(); // objprp.title = ADOprpDL.Dr["name"].ToString(); objprp.name = ADOprpDL.Dr["Name"].ToString(); objprp.mobNo = ADOprpDL.Dr["mobile"].ToString(); objprp.emailID = ADOprpDL.Dr["email"].ToString(); objprp.description = ADOprpDL.Dr["Message"].ToString(); objprp.DOJ = ADOprpDL.Dr["postedOn"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } //---------------------------Customize Course type Detail--------------- public List view_coursetype(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@CTypeId", objprp.CourseType); ADOprpDL.SPName = "view_coursetype"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["CTypeId"].ToString(); obj.CourseType = ADOprpDL.Dr["cTypeName"].ToString(); obj.description = ADOprpDL.Dr["ctypedetail"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } //-----------------------------------Customize Course Category---------------/ public List view_coursecategory_custom(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@catId", objprp.catID); ADOprpDL.ArrayPram[1] = new SqlParameter("@catCourseType", objprp.CourseType); ADOprpDL.SPName = "view_coursecategory_custom"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["catId"].ToString(); obj.CourseType = ADOprpDL.Dr["cTypeName"].ToString(); obj.title = ADOprpDL.Dr["catName"].ToString(); obj.description = ADOprpDL.Dr["catdetail"].ToString(); obj.catID = ADOprpDL.Dr["catCourseType"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } //--End Enquiry Detail //-----------------Govt Project-----------------// public List viewGoveProject(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@projectid", objprp.uniID); ADOprpDL.SPName = "viewGoveProject"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["projectid"].ToString(); obj.title = ADOprpDL.Dr["projectTitle"].ToString(); obj.urlName = ADOprpDL.Dr["orgName"].ToString(); obj.uniID = ADOprpDL.Dr["projectOrgId"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } //-------------------Select Govt Project----------------// public List SelGovtProject(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@projectid", objprp.id); ADOprpDL.SPName = "SelGovtProject"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["projectid"].ToString(); obj.title = ADOprpDL.Dr["projectTitle"].ToString(); obj.status = ADOprpDL.Dr["projectSubTitle"].ToString(); obj.uniID = ADOprpDL.Dr["projectOrgId"].ToString(); obj.description = ADOprpDL.Dr["projectdescription"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } //-----------insert Govt Project-----------------// public string insGovtProject(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[8]; ADOprp.ArrayPram[0] = new SqlParameter("@projectOrgId", objprp.uniID); ADOprp.ArrayPram[1] = new SqlParameter("@projectTitle", objprp.title); ADOprp.ArrayPram[2] = new SqlParameter("@projectdescription", objprp.description); ADOprp.ArrayPram[3] = new SqlParameter("@projectimagepath", objprp.urlPath); ADOprp.ArrayPram[4] = new SqlParameter("@projectSeotitle", objprp.paymentname); ADOprp.ArrayPram[5] = new SqlParameter("@projectSeokeyword", objprp.paymentstate); ADOprp.ArrayPram[6] = new SqlParameter("@projectSeodescription", objprp.paymentcountry); ADOprp.ArrayPram[7] = new SqlParameter("@projectSubTitle", objprp.status); ADOprp.SPName = "insGovtProject"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //-------------------Update Govt Project--------------------// public string updGovtProject(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[9]; ADOprp.ArrayPram[0] = new SqlParameter("@projectOrgId", objprp.uniID); ADOprp.ArrayPram[1] = new SqlParameter("@projectTitle", objprp.title); ADOprp.ArrayPram[2] = new SqlParameter("@projectdescription", objprp.description); ADOprp.ArrayPram[3] = new SqlParameter("@projectimagepath", objprp.urlPath); ADOprp.ArrayPram[4] = new SqlParameter("@projectSeotitle", objprp.paymentname); ADOprp.ArrayPram[5] = new SqlParameter("@projectSeokeyword", objprp.paymentstate); ADOprp.ArrayPram[6] = new SqlParameter("@projectSeodescription", objprp.paymentcountry); ADOprp.ArrayPram[7] = new SqlParameter("@projectSubTitle", objprp.status); ADOprp.ArrayPram[8] = new SqlParameter("@projectid", objprp.id); ADOprp.SPName = "updGovtProject"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //------------------------View Master Organization-------------// public List view_MasterOrganization(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@orgid", objprp.uniID); ADOprpDL.SPName = "view_MasterOrganization"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["orgid"].ToString(); obj.title = ADOprpDL.Dr["orgName"].ToString(); obj.pageurl = ADOprpDL.Dr["pageurl"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } //========================View Govt Certificate Course-------------// public List view_CertificateCourse(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@projectOrgId", objprp.uniID); ADOprpDL.ArrayPram[1] = new SqlParameter("@projectid", objprp.id); ADOprpDL.SPName = "view_CertificateCourse"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["projectid"].ToString(); obj.uniID = ADOprpDL.Dr["projectOrgId"].ToString(); obj.title = ADOprpDL.Dr["projectTitle"].ToString(); obj.status = ADOprpDL.Dr["projectSubTitle"].ToString(); obj.urlName = ADOprpDL.Dr["orgName"].ToString(); obj.description = ADOprpDL.Dr["projectdescription"].ToString(); obj.pageurl = ADOprpDL.Dr["pageurl"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } //--view Print public List selectPrint(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[4]; ADOprpDL.ArrayPram[0] = new SqlParameter("@pageIndex", prp.pageIndex); ADOprpDL.ArrayPram[1] = new SqlParameter("@pageSize", prp.pageSize); ADOprpDL.ArrayPram[2] = new SqlParameter("@branchId", prp.branchId); ADOprpDL.ArrayPram[3] = new SqlParameter("@status", prp.Type); ADOprpDL.SPName = "spPrintDetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["studentCode"].ToString(); objprp.name = ADOprpDL.Dr["studentName"].ToString(); objprp.DOJ = ADOprpDL.Dr["memberJoiningDate"].ToString(); objprp.branchName = ADOprpDL.Dr["branchName"].ToString(); objprp.courseName = ADOprpDL.Dr["courseName"].ToString(); objprp.branchId = ADOprpDL.Dr["pinBranchId"].ToString(); objprp.DOB = ADOprpDL.Dr["row"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public DataSet viewprintICard(PRPSetup prp) { adoBL.ArrayPram = new SqlParameter[1]; adoBL.ArrayPram[0] = new SqlParameter("@studentId", prp.codeId); adoBL.SPName = "viewPrintICard"; return ADO.DataSetWithProceduresandParam(adoBL); } //------------------------Website Enquiry -----------// public string ins_enquity(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[8]; ADOprp.ArrayPram[0] = new SqlParameter("@enqname", objprp.enqname); ADOprp.ArrayPram[1] = new SqlParameter("@enqmail", objprp.enqmail); ADOprp.ArrayPram[2] = new SqlParameter("@enqmob", objprp.enqmob); ADOprp.ArrayPram[3] = new SqlParameter("@enqmsg", objprp.enqmsg); ADOprp.ArrayPram[4] = new SqlParameter("@enqdepartment", objprp.enqdepartment); ADOprp.ArrayPram[5] = new SqlParameter("@enqaddress", objprp.enqaddress); ADOprp.ArrayPram[6] = new SqlParameter("@enqstate", objprp.Stid); ADOprp.ArrayPram[7] = new SqlParameter("@enqcity", objprp.Cityid); ADOprp.SPName = "ins_enquity"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public string ins_enquity1(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[8]; ADOprp.ArrayPram[0] = new SqlParameter("@enqname", objprp.enqname1); ADOprp.ArrayPram[1] = new SqlParameter("@enqmail", objprp.enqmail1); ADOprp.ArrayPram[2] = new SqlParameter("@enqmob", objprp.enqmob1); ADOprp.ArrayPram[3] = new SqlParameter("@enqmsg", objprp.enqmsg1); ADOprp.ArrayPram[4] = new SqlParameter("@enqdepartment", objprp.enqdepartment1); ADOprp.ArrayPram[5] = new SqlParameter("@enqaddress", objprp.enqaddress1); ADOprp.ArrayPram[6] = new SqlParameter("@enqstate", objprp.Stid1); ADOprp.ArrayPram[7] = new SqlParameter("@enqcity", objprp.Cityid1); ADOprp.SPName = "ins_enquity"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //------------------------Insert Franchise Detail---------------// public string ins_tblfranchise(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[20]; ADOprp.ArrayPram[0] = new SqlParameter("@frnisntitutename", objprp.frnisntitutename); ADOprp.ArrayPram[1] = new SqlParameter("@frnaaplicantname", objprp.frnaaplicantname); ADOprp.ArrayPram[2] = new SqlParameter("@frncrntinstitutename", objprp.frncrntinstitutename); ADOprp.ArrayPram[3] = new SqlParameter("@frncrntauthorisedname", objprp.frncrntauthorisedname); ADOprp.ArrayPram[4] = new SqlParameter("@frncrntaddress", objprp.frncrntaddress); ADOprp.ArrayPram[5] = new SqlParameter("@frncrntstate", objprp.frncrntstate); ADOprp.ArrayPram[6] = new SqlParameter("@frncrntcity", objprp.frncrntcity); ADOprp.ArrayPram[7] = new SqlParameter("@frncrntpincode", objprp.frncrntpincode); ADOprp.ArrayPram[8] = new SqlParameter("frnareaname", objprp.frnareaname); ADOprp.ArrayPram[9] = new SqlParameter("@frninstituterooms", objprp.frninstituterooms); ADOprp.ArrayPram[10] = new SqlParameter("@frninstitutestrenth", objprp.frninstitutestrenth); ADOprp.ArrayPram[11] = new SqlParameter("@frninstitutetoilets", objprp.frninstitutetoilets); ADOprp.ArrayPram[12] = new SqlParameter("@frngovtprojects", objprp.frngovtprojects); ADOprp.ArrayPram[13] = new SqlParameter("@frninstitutearea", objprp.frninstitutearea); ADOprp.ArrayPram[14] = new SqlParameter("@frninstitutemob", objprp.frninstitutemob); ADOprp.ArrayPram[15] = new SqlParameter("@frninstituemail", objprp.frninstituemail); ADOprp.ArrayPram[16] = new SqlParameter("@frninstitutestate", objprp.frninstitutestate); ADOprp.ArrayPram[17] = new SqlParameter("@frninstitutecity", objprp.frninstitutecity); ADOprp.ArrayPram[18] = new SqlParameter("@frnpopulation", objprp.frnpopulation); ADOprp.ArrayPram[19] = new SqlParameter("@frnreciept", objprp.frnreciept); ADOprp.SPName = "ins_tblfranchise"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //---------------------------Insert New Franchise--------------// public string ins_franchiseNew(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[11]; ADOprp.ArrayPram[0] = new SqlParameter("@frnisntitutename", objprp.frnisntitutename); ADOprp.ArrayPram[1] = new SqlParameter("@frnaaplicantname", objprp.frnaaplicantname); ADOprp.ArrayPram[2] = new SqlParameter("@frncrntstate", objprp.frncrntstate); ADOprp.ArrayPram[3] = new SqlParameter("@frncrntcity", objprp.frncrntcity); ADOprp.ArrayPram[4] = new SqlParameter("@frninstitutemob", objprp.frninstitutemob); ADOprp.ArrayPram[5] = new SqlParameter("@frninstituemail", objprp.frninstituemail); ADOprp.ArrayPram[6] = new SqlParameter("@frncrntauthorisedname", objprp.frncrntauthorisedname); ADOprp.ArrayPram[7] = new SqlParameter("@frngovtprojects", objprp.frngovtprojects); ADOprp.ArrayPram[8] = new SqlParameter("@frninstitutetoilets", objprp.frninstitutetoilets); ADOprp.ArrayPram[9] = new SqlParameter("@frninstitutearea", objprp.frninstitutearea); ADOprp.ArrayPram[10] = new SqlParameter("@frninstitutestrenth", objprp.frninstitutestrenth); ADOprp.SPName = "ins_franchiseNew"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //----------------------------Insert Customize Coursetype----------- public string ins_coursetype(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[1]; ADOprp.ArrayPram[0] = new SqlParameter("@ctypedetail", objprp.description); ADOprp.SPName = "ins_coursetype"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //----------------------Update Customize Course Type--------- public string upd_coursetype(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[2]; ADOprp.ArrayPram[0] = new SqlParameter("@CTypeId", objprp.CourseType); ADOprp.ArrayPram[1] = new SqlParameter("@ctypedetail", objprp.description); ADOprp.SPName = "upd_coursetype"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //------------------------Update Customize Course Category-------------- public string upd_coursecategory(PRPSetup objprp) { ADOprp.ArrayPram = new SqlParameter[2]; ADOprp.ArrayPram[0] = new SqlParameter("@catId", objprp.id); ADOprp.ArrayPram[1] = new SqlParameter("@catdetail", objprp.description); ADOprp.SPName = "upd_coursecategory"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } //--Change Password. public string UpdatePassword(PRPSetup objprp) { adoBL.ArrayPram = new SqlParameter[3]; adoBL.ArrayPram[0] = new SqlParameter("@loginUserId", objprp.id); adoBL.ArrayPram[1] = new SqlParameter("@loginPassword", objprp.Password); adoBL.ArrayPram[2] = new SqlParameter("@oldpassword", objprp.uniID); adoBL.SPName = "spUpdatePassword"; return ADO.ScalarQueryWithProceduresandParam(adoBL); } //-- StudentProfile public PRPSetup ViewStudentProfile(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@studentId", prp.id); ADOprpDL.ArrayPram[1] = new SqlParameter("@branchId", prp.branchId); ADOprpDL.SPName = "viewStudentProfile"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp = new PRPSetup(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp.id = ADOprpDL.Dr["studentCode"].ToString(); objprp.DOJ = ADOprpDL.Dr["Joiningdate"].ToString(); objprp.name = ADOprpDL.Dr["studentName"].ToString(); objprp.fatherName = ADOprpDL.Dr["studentFatherName"].ToString(); objprp.DOB = ADOprpDL.Dr["studentDOB"].ToString(); objprp.address = ADOprpDL.Dr["studentAddress"].ToString(); objprp.city = ADOprpDL.Dr["studentCity"].ToString(); objprp.District = ADOprpDL.Dr["studentDistrict"].ToString(); objprp.mobNo = ADOprpDL.Dr["studentMobileNo"].ToString(); objprp.catID = ADOprpDL.Dr["studentCategory"].ToString(); objprp.StartDate = ADOprpDL.Dr["startDate"].ToString(); objprp.Enddate = ADOprpDL.Dr["endDate"].ToString(); objprp.status = ADOprpDL.Dr["Status"].ToString(); objprp.photo = ADOprpDL.Dr["photo"].ToString(); objprp.loginName = ADOprpDL.Dr["loginName"].ToString(); objprp.rollNo = ADOprpDL.Dr["loginSrNo"].ToString(); objprp.Password = ADOprpDL.Dr["password"].ToString(); objprp.courseName = ADOprpDL.Dr["courseName"].ToString(); objprp.branchName = ADOprpDL.Dr["branchName"].ToString(); objprp.Total = ADOprpDL.Dr["fmTotalAmount"].ToString(); objprp.PendingFee = ADOprpDL.Dr["fmPendingAmount"].ToString(); objprp.Paidfee = ADOprpDL.Dr["paidFee"].ToString(); objprp.Concession = ADOprpDL.Dr["fmInsConcession"].ToString(); objprp.duedate = ADOprpDL.Dr["DueDate"].ToString(); } } else { objprp.srNo = "Result Not Find"; } ADO.ReaderClose(ADOprpDL); return objprp; } public List viewStudentFeeDetail(PRPSetup prp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@studentCode", prp.id); ADOprpDL.ArrayPram[1] = new SqlParameter("@branchId", prp.branchId); ADOprpDL.SPName = "viewStudentFeeDetail"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup objprp; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { objprp = new PRPSetup(); objprp.id = ADOprpDL.Dr["studentCode"].ToString(); objprp.codeId = ADOprpDL.Dr["receiptNo"].ToString(); objprp.Total = ADOprpDL.Dr["ftAmount"].ToString(); objprp.Latefee = ADOprpDL.Dr["ftLateFee"].ToString(); objprp.Otherfee = ADOprpDL.Dr["ftOtherCharges"].ToString(); objprp.RAmount = ADOprpDL.Dr["ftNetAmount"].ToString(); objprp.srNo = ADOprpDL.Dr["ftNo"].ToString(); objprp.duedate = ADOprpDL.Dr["dueDate"].ToString(); objprp.StartDate = ADOprpDL.Dr["payDate"].ToString(); objprp.pageIndex = ADOprpDL.Dr["ftFeeInWord"].ToString(); lst.Add(objprp); } if (ADOprpDL.Dr.NextResult()) { ADOprpDL.Dr.Read(); objprp = new PRPSetup(); objprp.noOfRecord = ADOprpDL.Dr[0].ToString(); lst.Add(objprp); } } else { objprp = new PRPSetup(); objprp.srNo = "Result Not Find"; lst.Add(objprp); } ADO.ReaderClose(ADOprpDL); return lst; } public List viewState3(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@name", objprp.urlName); ADOprpDL.SPName = "viewState3"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["Id"].ToString(); obj.title = ADOprpDL.Dr["name"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List view_enquiry(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@enqid", objprp.id); ADOprpDL.SPName = "view_enquiry"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.noOfRecord = ADOprpDL.Dr["nwrow"].ToString(); obj.id = ADOprpDL.Dr["enqid"].ToString(); obj.enqname = ADOprpDL.Dr["enqname"].ToString(); obj.enqmail = ADOprpDL.Dr["enqmail"].ToString(); obj.enqmob = ADOprpDL.Dr["enqmob"].ToString(); obj.enqmsg = ADOprpDL.Dr["enqmsg"].ToString(); obj.DOB = ADOprpDL.Dr["enqdate"].ToString(); obj.enqdepartment = ADOprpDL.Dr["enqdepartment"].ToString(); obj.address = ADOprpDL.Dr["address"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } //-------------------View Full Franchise Detail-----------// public List view_tblfranchise(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@frnid", objprp.id); ADOprpDL.SPName = "view_tblfranchise"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.noOfRecord = ADOprpDL.Dr["nw_row"].ToString(); obj.id = ADOprpDL.Dr["frnid"].ToString(); obj.frnisntitutename = ADOprpDL.Dr["frnisntitutename"].ToString(); obj.frnaaplicantname = ADOprpDL.Dr["frnaaplicantname"].ToString(); obj.frncrntinstitutename = ADOprpDL.Dr["frncrntinstitutename"].ToString(); obj.frncrntauthorisedname = ADOprpDL.Dr["frncrntauthorisedname"].ToString(); obj.frncrntaddress = ADOprpDL.Dr["frncrntaddress"].ToString(); obj.frncrntcity = ADOprpDL.Dr["crnstatecity"].ToString(); obj.frncrntpincode = ADOprpDL.Dr["frncrntpincode"].ToString(); obj.frnareaname = ADOprpDL.Dr["frnareaname"].ToString(); obj.frninstituterooms = ADOprpDL.Dr["frninstituterooms"].ToString(); obj.frninstitutestrenth = ADOprpDL.Dr["frninstitutestrenth"].ToString(); obj.frninstitutetoilets = ADOprpDL.Dr["frninstitutetoilets"].ToString(); obj.frngovtprojects = ADOprpDL.Dr["frngovtprojects"].ToString(); obj.frntotalsystems = ADOprpDL.Dr["frntotalsystems"].ToString(); obj.frninstitutearea = ADOprpDL.Dr["frninstitutearea"].ToString(); obj.frninstitutemob = ADOprpDL.Dr["frninstitutemob"].ToString(); obj.frninstituemail = ADOprpDL.Dr["frninstituemail"].ToString(); obj.frninstitutecity = ADOprpDL.Dr["insstatecity"].ToString(); obj.frnpopulation = ADOprpDL.Dr["frnpopulation"].ToString(); obj.frnreciept = ADOprpDL.Dr["frnreciept"].ToString(); obj.DOB = ADOprpDL.Dr["frninstituteinsdate"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } //--------------------View All Student-----------------// public List view_AllStudents(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@flag", objprp.id); ADOprpDL.SPName = "view_AllStudents"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["getme"].ToString(); obj.title = ADOprpDL.Dr["metype"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List View_Universities(PRPSetup objprp) { ADOprpDL.SPName = "View_jackOrgMasterDetail"; ADO.ReaderWithProcedures(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["orgId"].ToString(); obj.title = ADOprpDL.Dr["orgName"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List View_CourseTypeBY_UniId(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@UniId", objprp.id); if(objprp.Type !=null && objprp.Type!="") ADOprpDL.ArrayPram[1] = new SqlParameter("@type", objprp.Type); else ADOprpDL.ArrayPram[1] = new SqlParameter("@type", "1"); ADOprpDL.SPName = "BInd_CourseTYpebyUniId"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["id"].ToString(); obj.title = ADOprpDL.Dr["name"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List View_CourseName_Catid(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", objprp.id); ADOprpDL.SPName = "Bind_courseName"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["id"].ToString(); obj.title = ADOprpDL.Dr["name"].ToString(); obj.SideImg = ADOprpDL.Dr["catImage"].ToString(); obj.catID = ADOprpDL.Dr["catid"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List View_CourseName_TypeWise(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", objprp.id); ADOprpDL.SPName = "Bind_courseNamenew"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["id"].ToString(); obj.title = ADOprpDL.Dr["name"].ToString(); obj.catID = ADOprpDL.Dr["catid"].ToString(); obj.CateWaiseImage = ADOprpDL.Dr["catImage"].ToString(); obj.pageurl = ADOprpDL.Dr["caturl"].ToString(); obj.urlName = ADOprpDL.Dr["CatName"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List View_CourseNameTitleShort(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", objprp.id); ADOprpDL.SPName = "Bind_courseTitle_ShortValue"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.title = ADOprpDL.Dr["name"].ToString(); obj.description = ADOprpDL.Dr["description"].ToString(); obj.durationMaxTime = ADOprpDL.Dr["Duration"].ToString(); obj.coursefeetitle = ADOprpDL.Dr["feeTotalFee"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List View_Course_Fee(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", objprp.id); ADOprpDL.SPName = "Bind_CourseFee"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.title = ADOprpDL.Dr["feeSemName"].ToString(); obj.coursefee= ADOprpDL.Dr["feeCourseFee"].ToString(); obj.examfee= ADOprpDL.Dr["feeCourseFee"].ToString(); obj.regFees= ADOprpDL.Dr["feeregFee"].ToString(); obj.otherFees= ADOprpDL.Dr["feeOtherFee"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List View_Course_Subject(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", objprp.id); ADOprpDL.SPName = "Bind_Subject_CourseWise"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.codeId = ADOprpDL.Dr["subCode"].ToString(); obj.subName= ADOprpDL.Dr["subName"].ToString(); obj.minmark= ADOprpDL.Dr["subMinMarks"].ToString(); obj.maxmark= ADOprpDL.Dr["subMaxMarks"].ToString(); obj.semMode = ADOprpDL.Dr["Semester"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List Bind_HighlightCourses(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; // ADOprpDL.ArrayPram[0] = new SqlParameter("@id", objprp.id); ADOprpDL.SPName = "Bind_HighlightCourses"; ADO.ReaderWithProcedures(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["id"].ToString(); obj.title = ADOprpDL.Dr["name"].ToString(); obj.coursedetail = ADOprpDL.Dr["description"].ToString(); obj.courseimage = ADOprpDL.Dr["img"].ToString(); obj.catID = ADOprpDL.Dr["courseCatId"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public List Bind_CoursesDetail(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[2]; ADOprpDL.ArrayPram[0] = new SqlParameter("@type", objprp.Type); ADOprpDL.ArrayPram[1] = new SqlParameter("@courseid", objprp.courseId); ADOprpDL.SPName = "View_coursecareer"; ADO.ReaderWithProcedures(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.srNo = ADOprpDL.Dr["Srno"].ToString(); obj.title = ADOprpDL.Dr["ccname"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } public DataSet viewPrintMarksSheet(PRPSetup prp) { adoBL.ArrayPram = new SqlParameter[1]; adoBL.ArrayPram[0] = new SqlParameter("@studentId", prp.id); adoBL.SPName = "viewPrintMarksSheet"; return ADO.DataSetWithProceduresandParam(adoBL); } public DataSet viewResultVarify(PRPSetup prp) { adoBL.ArrayPram = new SqlParameter[1]; adoBL.ArrayPram[0] = new SqlParameter("@enrolno", prp.id); adoBL.SPName = "viewresultvarify"; return ADO.DataSetWithProceduresandParam(adoBL); } public DataTable View_HomeStudentDetail() { ADOprpDL.ArrayPram = new SqlParameter[0]; ADOprpDL.SPName = "viewstudentTrainingdetail"; return ADO.DataTableWithProcedures(ADOprpDL); } public string insertInPartner(IndustryPartner objprp) { ADOprp.ArrayPram = new SqlParameter[11]; ADOprp.ArrayPram[0] = new SqlParameter("@ipName", objprp.ipName); ADOprp.ArrayPram[1] = new SqlParameter("@ipJobTitle", objprp.ipJobTitle); ADOprp.ArrayPram[2] = new SqlParameter("@ipCompanyName", objprp.ipCompanyName); ADOprp.ArrayPram[3] = new SqlParameter("@ipCompanyWebsite", objprp.ipCompanyWebsite); ADOprp.ArrayPram[4] = new SqlParameter("@ipbsId", objprp.ipbsId); ADOprp.ArrayPram[5] = new SqlParameter("@ipceid", objprp.ipceid); ADOprp.ArrayPram[6] = new SqlParameter("@iperid", objprp.iperid); ADOprp.ArrayPram[7] = new SqlParameter("@ipMobile", objprp.ipMobile); ADOprp.ArrayPram[8] = new SqlParameter("@ipEmail", objprp.ipEmail); ADOprp.ArrayPram[9] = new SqlParameter("@ipState", objprp.ipState); ADOprp.ArrayPram[10] = new SqlParameter("@ipComment", objprp.ipComment); ADOprp.SPName = "ins_IPartner"; return ADO.ScalarQueryWithProceduresandParam(ADOprp); } public DataTable SearchTCenter(Registration prp) { adoBL.ArrayPram = new SqlParameter[3]; adoBL.ArrayPram[0] = new SqlParameter("@stateid", prp.State); adoBL.ArrayPram[1] = new SqlParameter("@tcname", prp.Name); adoBL.ArrayPram[2] = new SqlParameter("@districtid", prp.District); adoBL.SPName = "SearchTC"; return ADO.DataTableWithProceduresAndParam(adoBL); } public List ViewAllCategory(PRPSetup objprp) { ADOprpDL.ArrayPram = new SqlParameter[1]; ADOprpDL.ArrayPram[0] = new SqlParameter("@id", objprp.id); ADOprpDL.SPName = "view_category_by_sanjay"; ADO.ReaderWithProceduresandParam(ADOprpDL); PRPSetup obj = new PRPSetup(); ; List lst = new List(); if (ADOprpDL.Dr.HasRows) { while (ADOprpDL.Dr.Read()) { obj = new PRPSetup(); obj.id = ADOprpDL.Dr["id"].ToString(); obj.title = ADOprpDL.Dr["title"].ToString(); obj.description = ADOprpDL.Dr["description"].ToString(); obj.SideImg = ADOprpDL.Dr["SideImg"].ToString(); obj.SideImg2 = ADOprpDL.Dr["SideImg2"].ToString(); obj.pageurlcourse = ADOprpDL.Dr["pageurl"].ToString(); lst.Add(obj); } } ADO.ReaderClose(ADOprpDL); return lst; } } }