public IQueryable <StudentClassChange> GetStudentClassChange(int ClassDivisionId, int schoolId) { try { List <StudentClassChange> entities = new List <StudentClassChange>(); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@ClassDivisionId", ClassDivisionId); parameterlist.Add("@SchoolId", schoolId); //ExecuteProcedureReader DataSet ds = CommanMethodsForSQL.ExecuteProcedureReader("sp_GetStudentByClassDivision", parameterlist); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { if (dr != null) { StudentClassChange entity = new StudentClassChange(); entity.StudentId = Convert.ToInt32(dr["StudentId"]); entity.StudentFullNameWithTitle = Convert.ToString(dr["StudentName"]); entity.RegisterId = Convert.ToInt32(dr["RegisterId"]); entities.Add(entity); } } } return(entities.AsQueryable()); } catch (Exception ex) { throw; } }
public IQueryable <StudentParent> GetAll() { try { List <StudentParent> entites = new List <StudentParent>(); //DataTable dataTable = CommanMethodsForSQL.GetDataTable("SELECT StudentParentDetails.* FROM StudentParentDetails;"); Hashtable parameterlist = new Hashtable(); DataSet dataSet = CommanMethodsForSQL.ExecuteProcedureReader("sp_GetAllStudentParentDetails", parameterlist); if (dataSet != null && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dataSet.Tables[0].Rows) { if (dr != null) { StudentParent entity = new StudentParent(); entity.StudentId = Convert.ToInt32(dr["StudentId"]); entity.Title = Convert.ToString(dr["Title"]); entity.FirstName = Convert.ToString(dr["FirstName"]); entity.MiddleName = Convert.ToString(dr["MiddleName"]); entity.LastName = Convert.ToString(dr["LastName"]); entity.Gender = Convert.ToString(dr["Gender"]); entity.Address = Convert.ToString(dr["Address"]); entity.CountryId = Convert.ToInt32(dr["CountryId"]); entity.StateId = Convert.ToInt32(dr["StateId"]); entity.DistrictId = Convert.ToInt32(dr["DistrictId"]); entity.CityId = Convert.ToInt32(dr["CityId"]); entity.PinCode = Convert.ToInt32(dr["PinCode"]); entity.MobileNumber = Convert.ToInt64(dr["MobileNumber"]); entity.ContactNo = Convert.ToString(dr["ContactNo"]); entity.Occupation = Convert.ToString(dr["Occupation"]); entity.CompanyName = Convert.ToString(dr["CompanyName"]); entity.CompanyAddress = Convert.ToString(dr["CompanyAddress"]); entity.CompanyContactNo = Convert.ToString(dr["CompanyContactNo"]); entity.BankName = Convert.ToString(dr["BankName"]); entity.AccountNo = Convert.ToString(dr["AccountNo"]); entity.Branch = Convert.ToString(dr["Branch"]); entity.IFSCCode = Convert.ToString(dr["IFSCCode"]); entity.StudentFullName = Convert.ToString(dr["StudentFullName"]); entity.Status = Convert.ToBoolean(dr["Status"].ToString()); entity.Remark = dr["Remark"].ToString(); entites.Add(entity); } } } return(entites.AsQueryable()); } catch (Exception ex) { throw; } }
public IQueryable <StudentAttendance> GetAllStudentAttendance(int ClassId, int DivisionId, DateTime DateOfAttendance) { try { List <StudentAttendance> entites = new List <StudentAttendance>(); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@ClassId", ClassId); parameterlist.Add("@DivisionId", DivisionId); parameterlist.Add("@DateOfAttendance", DateOfAttendance); DataSet dataSet = CommanMethodsForSQL.ExecuteProcedureReader("sp_StudentAttendanceGet", parameterlist); if (dataSet != null && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dataSet.Tables[0].Rows) { if (dr != null) { StudentAttendance entity = new StudentAttendance(); entity.Id = Convert.ToInt32(dr["Id"]); entity.ClassDivisionId = Convert.ToInt32(dr["ClassDivisionId"]); entity.ClassId = ClassId; entity.DivisionId = DivisionId; entity.StudentId = Convert.ToInt32(dr["StudentId"]); entity.RegisterId = Convert.ToInt32(dr["RegisterId"]); entity.StudentFullNameWithTitle = Convert.ToString(dr["StudentFullName"]); if (dr["DateOfAttendance"] != DBNull.Value) { entity.DateOfAttendance = Convert.ToDateTime(dr["DateOfAttendance"]); } entity.AttendanceInDays = Convert.ToDecimal(dr["AttendanceInDays"]); entity.AbsentRemark = Convert.ToString(dr["AbsentRemark"]).Trim(); entity.Status = Convert.ToBoolean(dr["Status"]); entites.Add(entity); } } } return(entites.AsQueryable()); } catch (Exception ex) { throw; } }
public int GetClassDivisionId(string ClassName, string DivisionName) { int classDivisionId = 0; Hashtable parameterlist = new Hashtable(); parameterlist.Add("@Class", ClassName); parameterlist.Add("@Division", DivisionName); DataSet dataSet = CommanMethodsForSQL.ExecuteProcedureReader("sp_GetClassDivisionIdByClassAndDivision", parameterlist); if (dataSet != null && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0) { classDivisionId = Convert.ToInt32(dataSet.Tables[0].Rows[0]["ClassDivisionId"]); } return(classDivisionId); }
public IQueryable <StudentLedger> getStudentLedger(int RegisterId, int ClassId, int DivisionId, int ReligionId, int CastId, int schoolId) { try { List <StudentLedger> entites = new List <StudentLedger>(); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@SchoolId", schoolId); parameterlist.Add("@RegisterId", RegisterId); parameterlist.Add("@ClassId", ClassId); parameterlist.Add("@DivisionId", DivisionId); parameterlist.Add("@ReligionId", ReligionId); parameterlist.Add("@CastId", CastId); DataSet dataSet = CommanMethodsForSQL.ExecuteProcedureReader("sp_StudentLedger", parameterlist); if (dataSet != null && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dataSet.Tables[0].Rows) { if (dr != null) { StudentLedger entity = new StudentLedger(); entity.StudentLedgerId = Convert.ToInt32(dr["StudentLedgerId"]); entity.StudentId = Convert.ToInt32(dr["StudentId"]); entity.TransactionDate = Convert.ToDateTime(dr["TransactionDate"]); entity.FeeHeadId = Convert.ToInt32(dr["FeeHeadId"]); entity.Cr = Convert.ToDecimal(dr["Cr"]); entity.Dr = Convert.ToDecimal(dr["Dr"]); entity.HeadBalance = Convert.ToDecimal(dr["HeadBalance"]); entity.Balance = Convert.ToDecimal(dr["Balance"]); entity.ReceiptNo = Convert.ToInt32(dr["ReceiptNo"]); entity.BankName = Convert.ToString(dr["BankName"]); entity.ChequeNumber = Convert.ToString(dr["ChequeNumber"]); entity.Status = Convert.ToBoolean(dr["Status"].ToString()); entity.Remark = Convert.ToString(dr["Remark"]); entity.StudentFullNameWithTitle = string.Concat(Convert.ToString(dr["Title"]).Trim(), " ", Convert.ToString(dr["FirstName"]).Trim(), " ", Convert.ToString(dr["MiddleName"]).Trim(), " ", Convert.ToString(dr["LastName"]).Trim()).Trim(); entity.FeeHeadName = Convert.ToString(dr["FeeHead"]); entites.Add(entity); } } } return(entites.AsQueryable()); } catch (Exception ex) { throw; } }
public long GetMaxTCNo() { Hashtable parameterlist = new Hashtable(); long returnValue = 0; DataSet dataSet = CommanMethodsForSQL.ExecuteProcedureReader("sp_GetStudentMaxTCNo", parameterlist); if (dataSet != null && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0) { DataRow dr = dataSet.Tables[0].Rows[0]; if (dr != null) { returnValue = Convert.ToInt32(dr[0]); } } return(returnValue); }
public IQueryable <StudentAddress> GetAll(Int64 StudentId) { try { List <StudentAddress> entites = new List <StudentAddress>(); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@StudentId", StudentId); DataSet dataSet = CommanMethodsForSQL.ExecuteProcedureReader("sp_GetAllStudentAddressDetails", parameterlist); if (dataSet != null && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dataSet.Tables[0].Rows) { if (dr != null) { StudentAddress entity = new StudentAddress(); entity.StudentId = Convert.ToInt32(dr["StudentId"]); entity.CurrentAddress = dr["CurrentAddress"].ToString(); entity.CurrentCountryId = Convert.ToInt32(dr["CurrentCountryId"]); entity.CurrentStateId = Convert.ToInt32(dr["CurrentStateId"]); entity.CurrentDistrictId = Convert.ToInt32(dr["CurrentDistrictId"]); entity.CurrentCityId = Convert.ToInt32(dr["CurrentCityId"]); entity.CurrentPinCode = Convert.ToInt32(dr["CurrentPinCode"]); entity.PermentAddress = dr["PermentAddress"].ToString(); entity.PermentCountryId = Convert.ToInt32(dr["PermentCountryId"]); entity.PermentStateId = Convert.ToInt32(dr["PermentStateId"]); entity.PermentDistrictId = Convert.ToInt32(dr["PermentDistrictId"]); entity.PermentCityId = Convert.ToInt32(dr["PermentCityId"]); entity.PermentPinCode = Convert.ToInt32(dr["PermentPinCode"]); entity.Status = Convert.ToBoolean(dr["Status"].ToString()); entity.Remark = dr["Remark"].ToString(); entity.StudentFullName = dr["StudentFullName"].ToString(); entites.Add(entity); } } } return(entites.AsQueryable()); } catch (Exception ex) { throw; } }
public IQueryable <StudentTransactionSub> GetAllStudentTransactionSubByTransactionId(long StudentTransactionId) { try { List <StudentTransactionSub> entites = new List <StudentTransactionSub>(); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@StudentTransactionId", StudentTransactionId); DataSet dataSet = CommanMethodsForSQL.ExecuteProcedureReader("sp_GetAllStudentTransactionSub", parameterlist); if (dataSet != null && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dataSet.Tables[0].Rows) { if (dr != null) { StudentTransactionSub entity = new StudentTransactionSub(); entity.StudentTransactionId = Convert.ToInt32(dr["StudentTransactionId"]); entity.StudentTransactionSubId = Convert.ToInt32(dr["StudentTransactionSubId"]); entity.FeeHeadId = Convert.ToInt32(dr["FeeHead"]); entity.FeeHeadName = Convert.ToString(dr["FeeHeadName"]); entity.Cr = Convert.ToDecimal(dr["Cr"]); entity.Dr = Convert.ToDecimal(dr["Dr"]); entity.Balance = Convert.ToDecimal(dr["Balance"]); entity.Remark = dr["Remark"].ToString(); entites.Add(entity); } } } return(entites.AsQueryable()); } catch (Exception ex) { throw; } }
public IQueryable <Student> getStudentsWithBalance(int ClassId, int DivisionId, int ReligionId, int CastId) { try { List <Student> entites = new List <Student>(); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@ClassId", ClassId); parameterlist.Add("@DivisionId", DivisionId); parameterlist.Add("@ReligionId", ReligionId); parameterlist.Add("@CastId", CastId); DataSet dataSet = CommanMethodsForSQL.ExecuteProcedureReader("sp_StudentLedgerBalance", parameterlist); if (dataSet != null && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dataSet.Tables[0].Rows) { if (dr != null) { Student entity = new Student(); //entity.StudentFullNameWithTitle = string.Concat(Convert.ToString(dr["Title"]).Trim(), " ", Convert.ToString(dr["FirstName"]).Trim(), " ", Convert.ToString(dr["MiddleName"]).Trim(), " ", Convert.ToString(dr["LastName"]).Trim()).Trim(); entity.StudentId = Convert.ToInt32(dr["StudentId"]); entity.RegisterId = Convert.ToInt32(dr["RegisterId"]); entity.ClassDivisionId = Convert.ToInt32(dr["ClassDivisionId"]); entity.ClassId = Convert.ToInt32(dr["ClassId"]); entity.DivisionId = Convert.ToInt32(dr["DivisionId"]); entity.ClassName = Convert.ToString(dr["Class"]).Trim(); entity.DivisionName = Convert.ToString(dr["Division"]).Trim(); entity.Title = Convert.ToString(dr["Title"]).Trim(); entity.FirstName = Convert.ToString(dr["FirstName"]).Trim(); entity.MiddleName = Convert.ToString(dr["MiddleName"]).Trim(); entity.LastName = Convert.ToString(dr["LastName"]).Trim(); entity.MotherName = Convert.ToString(dr["MotherName"]).Trim(); entity.Gender = Convert.ToString(dr["Gender"]).Trim(); entity.Nationality = Convert.ToString(dr["Nationality"]).Trim(); entity.ReligionCastId = Convert.ToInt32(dr["ReligionCastId"]); entity.ReligionId = Convert.ToInt32(dr["ReligionId"]); entity.CastId = Convert.ToInt32(dr["CastId"]); entity.ReligionName = Convert.ToString(dr["Religion"]).Trim(); entity.CastName = Convert.ToString(dr["Cast"]).Trim(); entity.ReserveCategory = Convert.ToString(dr["ReserveCategory"]).Trim(); entity.DateOfBirth = Convert.ToDateTime(dr["DateOfBirth"]); entity.PlaceOfBirth = Convert.ToString(dr["PlaceOfBirth"]).Trim(); entity.AdharcardNo = Convert.ToString(dr["AdharcardNo"]).Trim(); entity.DateOfAdmission = Convert.ToDateTime(dr["DateOfAdmission"]); entity.LastSchoolAttended = Convert.ToString(dr["LastSchoolAttended"]).Trim(); entity.Progress = Convert.ToString(dr["Progress"]).Trim(); entity.Conduct = Convert.ToString(dr["Conduct"]).Trim(); if (dr["DateOfLeavingSchool"] != DBNull.Value) { entity.DateOfLeavingSchool = Convert.ToDateTime(dr["DateOfLeavingSchool"]); } entity.ClassInWhichStudingAndSinceWhen = Convert.ToString(dr["ClassInWhichStudingAndSinceWhen"]).Trim(); entity.ReasonForLeavingSchool = Convert.ToString(dr["ReasonForLeavingSchool"]).Trim(); entity.RemarkOnTC = Convert.ToString(dr["RemarkOnTC"]).Trim(); if (dr["balance"] != DBNull.Value) { entity.Balance = Convert.ToDecimal(dr["balance"].ToString()); } if (dr["MobileNumber"] != DBNull.Value) { entity.MobileNumber = Convert.ToInt64(dr["MobileNumber"].ToString()); } entites.Add(entity); } } } return(entites.AsQueryable()); } catch (Exception ex) { throw; } }