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