public void UpdateTCDetails(int StudentId)
{
Hashtable parameterlist = new Hashtable();
parameterlist.Add("@StudentId", StudentId);
CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_UpdateStudentTCStatus", parameterlist);
}
public IQueryable <Class> GetAll()
{
try
{
List <Class> entites = new List <Class>();
DataTable dataTable = CommanMethodsForSQL.GetDataTable("SELECT ClassId, ClassDetails.Class, "
+ " ClassDetails.Status, ClassDetails.Remark FROM ClassDetails;");
if (dataTable != null && dataTable.Rows.Count > 0)
{
foreach (DataRow dr in dataTable.Rows)
{
if (dr != null)
{
Class entity = new Class();
entity.ClassId = Convert.ToInt32(dr["ClassId"]);
entity.ClassName = dr["Class"].ToString();
entity.Status = Convert.ToBoolean(dr["Status"].ToString());
entity.Remark = dr["Remark"].ToString();
entites.Add(entity);
}
}
}
return(entites.AsQueryable());
}
catch (Exception ex)
{
throw;
}
}
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 <AcademicYear> GetAll()
{
try
{
List <AcademicYear> entites = new List <AcademicYear>();
DataTable dataTable = CommanMethodsForSQL.GetDataTable("SELECT AcademicYearId, LTRIM(RTRIM(AcademicYear)) AS AcademicYear, StartDate, EndDate, Status, Remark "
+ " FROM AcademicYearDetails;");
if (dataTable != null && dataTable.Rows.Count > 0)
{
foreach (DataRow dr in dataTable.Rows)
{
if (dr != null)
{
AcademicYear entity = new AcademicYear();
entity.AcademicYearId = Convert.ToInt32(dr["AcademicYearId"]);
entity.AcademicYearName = dr["AcademicYear"].ToString();
entity.StartDate = Convert.ToDateTime(dr["StartDate"]);
entity.EndDate = Convert.ToDateTime(dr["EndDate"]);
entity.Status = Convert.ToBoolean(dr["Status"].ToString());
entity.Remark = dr["Remark"].ToString();
entites.Add(entity);
}
}
}
return(entites.AsQueryable());
}
catch (Exception ex)
{
throw;
}
}
public void Edit(FeeClassDivision entity)
{
try
{
// string queryString = string.Format(" UPDATE [FeeClassDivisionDetails] " +
//" SET [AcademicYearId] = {0}" +
// ",[FeeHeadId] = {1}" +
// ",[ClassDivisionId] = {2}" +
// ",[PeriodInMonthly] ={3}" +
// ",[AmountInMonthly] = {4}" +
// ",[AmountInYearly] = {5}" +
// ",[Status] = {6}" +
// ",[Remark] = '{7}'" +
//" WHERE FeeClassDivisionId = {8};"
//,entity.AcademicYearId, entity.FeeHeadId, entity.ClassDivisionId, entity.PeriodInMonthly,
//entity.AmountInMonthly, entity.AmountInYearly, entity.Status == true ? 1 : 0, entity.Remark, entity.FeeClassDivisionId);
// int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString);
Hashtable parameterlist = new Hashtable();
parameterlist.Add("@FeeHeadId", entity.FeeHeadId);
parameterlist.Add("@ClassDivisionId", entity.ClassDivisionId);
parameterlist.Add("@PeriodInMonthly", entity.PeriodInMonthly);
parameterlist.Add("@AmountInMonthly", entity.AmountInMonthly);
parameterlist.Add("@AmountInYearly", entity.AmountInYearly);
parameterlist.Add("@Status", entity.Status);
parameterlist.Add("@Remark", entity.Remark);
parameterlist.Add("@FeeClassDivisionId", entity.FeeClassDivisionId);
int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_FeeClassDivisionUpdate", parameterlist);
}
catch (Exception ex)
{
throw;
}
}
public void AddStudentAttendance(List <StudentAttendance> entities)
{
try
{
Hashtable parameterlist;
foreach (var entity in entities)
{
parameterlist = new Hashtable();
parameterlist.Add("@ClassId", entity.ClassId);
parameterlist.Add("@DivisionId", entity.DivisionId);
parameterlist.Add("@DateOfAttendance", entity.DateOfAttendance);
parameterlist.Add("@StudentId", entity.StudentId);
parameterlist.Add("@AttendanceInDays", entity.AttendanceInDays);
parameterlist.Add("@AbsentRemark", entity.AbsentRemark);
Hashtable outparameterlist = new Hashtable();
int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentAttendanceInsert", parameterlist);
}
}
catch (Exception ex)
{
throw;
}
}
public IQueryable <Religion> GetAll()
{
try
{
List <Religion> entites = new List <Religion>();
DataTable dataTable = CommanMethodsForSQL.GetDataTable("SELECT ReligionDetails.ReligionId, LTRIM(RTRIM(ReligionDetails.Religion)) AS Religion, "
+ " ReligionDetails.Status, ReligionDetails.Remark"
+ " FROM ReligionDetails;");
if (dataTable != null && dataTable.Rows.Count > 0)
{
foreach (DataRow dr in dataTable.Rows)
{
if (dr != null)
{
Religion entity = new Religion();
entity.ReligionId = Convert.ToInt32(dr["ReligionId"]);
entity.ReligionName = Convert.ToString(dr["Religion"]);
entity.Status = Convert.ToBoolean(dr["Status"].ToString());
entity.Remark = dr["Remark"].ToString();
entites.Add(entity);
}
}
}
return(entites.AsQueryable());
}
catch (Exception ex)
{
throw;
}
}
public IQueryable <Country> GetAll()
{
try
{
List <Country> entites = new List <Country>();
DataTable dataTable = CommanMethodsForSQL.GetDataTable("SELECT CountryDetails.CountryId, RTRIM(LTRIM(CountryDetails.Country)) AS Country, CountryDetails.[Status], CountryDetails.Remark "
+ " FROM CountryDetails ;");
if (dataTable != null && dataTable.Rows.Count > 0)
{
foreach (DataRow dr in dataTable.Rows)
{
if (dr != null)
{
Country entity = new Country();
entity.CountryId = Convert.ToInt32(dr["CountryId"]);
entity.CountryName = dr["Country"].ToString();
entity.Status = Convert.ToBoolean(dr["Status"].ToString());
entity.Remark = dr["Remark"].ToString();
entites.Add(entity);
}
}
}
return(entites.AsQueryable());
}
catch (Exception ex)
{
throw;
}
}
public void Add(Asset entity, int schoolId)
{
try
{
Hashtable parameterlist = new Hashtable();
parameterlist.Add("@SchoolId", schoolId);
parameterlist.Add("@TypeofAsset", entity.TypeofAsset);
parameterlist.Add("@AssetName", entity.AssetName);
parameterlist.Add("@Quantity", entity.Quantity);
parameterlist.Add("@PricePerItem", entity.PricePerItem);
parameterlist.Add("@Total", entity.Quantity * entity.PricePerItem);// entity.Total);
parameterlist.Add("@PurchaseDate", entity.PurchaseDate);
parameterlist.Add("@Condition", entity.Condition);
parameterlist.Add("@AssesmentYear", entity.AssesmentYear);
parameterlist.Add("@Status", entity.Status == true ? 1 : 0);
parameterlist.Add("@Remark", entity.Remark);
int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_InsertAssetDetails", parameterlist);
}
catch (Exception ex)
{
throw;
}
}
public void Edit(Account entity)
{
try
{
string queryString = string.Format(" UPDATE [Account] " +
" SET [NarrationDetails] = N'{0}'" +
",[TransactionType] = N'{1}'" +
",[PaymentMode] = N'{2}'" +
",[Amount] = '{3}'" +
//",[Balance] = '{4}'" +
",[TransactionDate]= GETDATE()" +
",[Remark]='{4}'" +
",[CustomerName]=N'{5}'" +
",[BankName]=N'{6}'" +
",[ChqDDNumber]=N'{7}'" +
",[ContactNo]=N'{8}'" +
" WHERE SrNo = {9};", entity.NarrationDetails, entity.TransactionType, entity.PaymentMode, entity.Amount,
entity.Remark, entity.CustomerName, entity.BankName, entity.ChqDDNumber,
entity.ContactNo, entity.SrNo);
string s = queryString;
int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString);
}
catch (Exception ex)
{
throw;
}
}
public void Edit(AcademicYear entity)
{
try
{
// string queryString = string.Format(" UPDATE [AcademicYearDetails] " +
//" SET [AcademicYear] = '{0}'" +
// ",[StartDate] = '{1}'" +
// ",[EndDate] = '{2}'" +
// ",[Status] = '{3}'" +
// ",[Remark] = '{4}'" +
//" WHERE AcademicYearId = {5};", entity.AcademicYearName, entity.StartDate, entity.EndDate, entity.Status, entity.Remark, entity.AcademicYearId);
// int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString);
Hashtable parameterlist = new Hashtable();
parameterlist.Add("@AcademicYearName", entity.AcademicYearName);
parameterlist.Add("@StartDate", entity.StartDate);
parameterlist.Add("@EndDate", entity.EndDate);
parameterlist.Add("@Status", entity.Status);
parameterlist.Add("@Remark", entity.Remark);
parameterlist.Add("@AcademicYearId", entity.AcademicYearId);
int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_AcademicYearUpdate", parameterlist);
}
catch (Exception ex)
{
throw;
}
}
public void Edit(Religion entity)
{
try
{
// string queryString = string.Format(" UPDATE [ReligionDetails] " +
//" SET [AcademicYearId] = {0}" +
// ",[Religion] = '{1}'" +
// ",[Status] = '{2}'" +
// ",[Remark] = '{3}'" +
//" WHERE [ReligionId] = {4};", entity.AcademicYearId, entity.ReligionName, entity.Status, entity.Remark, entity.ReligionId);
// int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString);
Hashtable parameterlist = new Hashtable();
parameterlist.Add("@Religion", entity.ReligionName);
parameterlist.Add("@Status", entity.Status);
parameterlist.Add("@Remark", entity.Remark);
parameterlist.Add("@ReligionId", entity.ReligionId);
int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_ReligionDetailsUpdate", parameterlist);
}
catch (Exception ex)
{
throw;
}
}
public IQueryable <Role> GetAll()
{
try
{
List <Role> entites = new List <Role>();
DataTable dataTable = CommanMethodsForSQL.GetDataTable("SELECT RoleDetails.* FROM RoleDetails;");
if (dataTable != null && dataTable.Rows.Count > 0)
{
foreach (DataRow dr in dataTable.Rows)
{
if (dr != null)
{
Role entity = new Role();
entity.Id = Convert.ToInt32(dr["RoleId"]);
entity.RoleName = dr["Role"].ToString();
entity.Status = Convert.ToBoolean(dr["Status"].ToString());
entity.Remark = dr["Remark"].ToString();
entites.Add(entity);
}
}
}
return(entites.AsQueryable());
}
catch (Exception ex)
{
throw;
}
}
public IQueryable <Cast> GetAll()
{
try
{
List <Cast> entites = new List <Cast>();
DataTable dataTable = CommanMethodsForSQL.GetDataTable("SELECT CastId, LTRIM(RTRIM([Cast])) as CastName, Status, Remark FROM CastDetails;");
if (dataTable != null && dataTable.Rows.Count > 0)
{
foreach (DataRow dr in dataTable.Rows)
{
if (dr != null)
{
Cast entity = new Cast();
entity.CastId = Convert.ToInt32(dr["CastId"]);
entity.CastName = Convert.ToString(dr["CastName"]);
entity.Status = Convert.ToBoolean(dr["Status"].ToString());
entity.Remark = dr["Remark"].ToString();
entites.Add(entity);
}
}
}
return(entites.AsQueryable());
}
catch (Exception ex)
{
throw;
}
}
public IQueryable <State> GetAll()
{
try
{
List <State> entites = new List <State>();
DataTable dataTable = CommanMethodsForSQL.GetDataTable("SELECT StateDetails.StateId, StateDetails.CountryId, RTRIM(LTRIM(StateDetails.[State])) AS [State], StateDetails.[Status], StateDetails.Remark, "
+ " RTRIM(LTRIM(CountryDetails.Country)) AS Country "
+ " FROM StateDetails INNER JOIN "
+ " CountryDetails ON StateDetails.CountryId = CountryDetails.CountryId;");
if (dataTable != null && dataTable.Rows.Count > 0)
{
foreach (DataRow dr in dataTable.Rows)
{
if (dr != null)
{
State entity = new State();
entity.StateId = Convert.ToInt32(dr["StateId"]);
entity.CountryId = Convert.ToInt32(dr["CountryId"]);
entity.CountryName = dr["Country"].ToString();
entity.StateName = dr["State"].ToString();
entity.Status = Convert.ToBoolean(dr["Status"].ToString());
entity.Remark = dr["Remark"].ToString();
entites.Add(entity);
}
}
}
return(entites.AsQueryable());
}
catch (Exception ex)
{
throw;
}
}
public void Edit(City entity)
{
try
{
// string queryString = string.Format(" UPDATE [CityDetails] " +
//" SET [DistrictId] = {0}" +
// ",[City] = '{1}'" +
// ",[Status] = '{2}'" +
// ",[Remark] = '{3}'" +
//" WHERE CityId = {4};", entity.DistrictId, entity.CityName, entity.Status, entity.Remark, entity.CityId);
// int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString);
Hashtable parameterlist = new Hashtable();
parameterlist.Add("@CityId", entity.CityId);
parameterlist.Add("@DistrictId", entity.DistrictId);
parameterlist.Add("@City", entity.CityName);
parameterlist.Add("@Status", entity.Status);
parameterlist.Add("@Remark", entity.Remark);
int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_CityDetailsUpdate", parameterlist);
}
catch (Exception ex)
{
throw;
}
}
public IQueryable <City> GetAll()
{
try
{
List <City> entites = new List <City>();
DataTable dataTable = CommanMethodsForSQL.GetDataTable("SELECT CityDetails.CityId, CityDetails.City, CityDetails.DistrictId, DistrictDetails.District,DistrictDetails.District, CityDetails.Status, CityDetails.Remark"
+ " FROM CityDetails INNER JOIN DistrictDetails ON CityDetails.DistrictId = DistrictDetails.DistrictId;");
if (dataTable != null && dataTable.Rows.Count > 0)
{
foreach (DataRow dr in dataTable.Rows)
{
if (dr != null)
{
City entity = new City();
entity.CityId = Convert.ToInt32(dr["CityId"]);
entity.CityName = dr["City"].ToString();
entity.DistrictId = Convert.ToInt32(dr["DistrictId"]);
entity.DistrictName = dr["District"].ToString();
entity.Status = Convert.ToBoolean(dr["Status"].ToString());
entity.Remark = dr["Remark"].ToString();
entites.Add(entity);
}
}
}
return(entites.AsQueryable());
}
catch (Exception ex)
{
throw;
}
}
public void Add(StudentLedger entity)
{
try
{
//string queryString = string.Format(" INSERT INTO [StudentLedger]([AcademicYearId],[StudentId],[TransactionDate],[FeeHeadId],[Cr],[Dr],[HeadBalance],[Balance],[ReceiptNo],[BankName],[ChequeNumber],[Status],[Remark],[CreatedBy],[CreatedDate],[ModifiedBy],[ModifiedDate]) VALUES({0}, '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}','{14}','{15}','{16}');"
// , entity.AcademicYearId, entity.StudentId, entity.TransactionDate, entity.FeeHeadId, entity.Cr, entity.Dr, entity.HeadBalance, entity.Balance, entity.Status == true ? 1 : 0, entity.Remark, entity.CreatedBy, entity.CreatedDate, entity.ModifiedBy, entity.ModifiedDate);
//int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString);
Hashtable parameterlist = new Hashtable();
parameterlist.Add("@StudentId", entity.StudentId);
parameterlist.Add("@TransactionDate", entity.TransactionDate);
parameterlist.Add("@FeeHeadId", entity.FeeHeadId);
parameterlist.Add("@Cr", entity.Cr);
parameterlist.Add("@Dr", entity.Dr);
parameterlist.Add("@HeadBalance", entity.HeadBalance);
parameterlist.Add("@Balance", entity.Balance);
parameterlist.Add("@ReceiptNo", entity.ReceiptNo);
parameterlist.Add("@BankName", entity.BankName);
parameterlist.Add("@ChequeNumber", entity.ChequeNumber);
parameterlist.Add("@Status", entity.Status);
parameterlist.Add("@Remark", entity.Remark);
parameterlist.Add("@CreatedBy", entity.CreatedBy);
parameterlist.Add("@CreatedDate", entity.CreatedDate);
parameterlist.Add("@ModifiedBy", entity.ModifiedBy);
parameterlist.Add("@ModifiedDate", entity.ModifiedDate);
int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentLedgerInsert", parameterlist);
}
catch (Exception ex)
{
throw;
}
}
public decimal getLeaveBalance(int employeeId)
{
try
{
decimal leaveBalance = 0;
String SqlQuery = "SELECT BalanceLeaves from EmployeeLeaveTransaction where EmployeeId=" + employeeId + ";";
DataTable dataTable = CommanMethodsForSQL.GetDataTable(SqlQuery);
if (dataTable != null && dataTable.Rows.Count > 0)
{
foreach (DataRow dr in dataTable.Rows)
{
if (dr != null)
{
leaveBalance = Convert.ToDecimal(dr["BalanceLeaves"]);
}
}
}
return(leaveBalance);
}
catch (Exception ex)
{
throw;
}
}
public void ChangePassword(User entity)
{
Hashtable parameterlist = new Hashtable();
parameterlist.Add("@UserId", entity.UserId);
parameterlist.Add("@Password", entity.Password);
CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_ChangePassword", parameterlist);
}
/// <summary>
/// Add new student record
/// </summary>
/// <param name="entity">Student entity</param>
/// <returns>Student Id</returns>
public int AddStudent(Student entity, int SchoolId)
{
try
{
Hashtable parameterlist = new Hashtable();
parameterlist.Add("@StudentId", entity.StudentId);
parameterlist.Add("@SchoolId", SchoolId);
parameterlist.Add("@RegisterId", entity.RegisterId);
parameterlist.Add("@ClassDivisionId", entity.ClassDivisionId);
parameterlist.Add("@Title", entity.Title);
parameterlist.Add("@FirstName", entity.FirstName);
parameterlist.Add("@MiddleName", entity.MiddleName);
parameterlist.Add("@LastName", entity.LastName);
parameterlist.Add("@MotherName", entity.MotherName);
parameterlist.Add("@Gender", entity.Gender);
parameterlist.Add("@Nationality", entity.Nationality);
parameterlist.Add("@ReligionCastId", entity.ReligionCastId);
parameterlist.Add("@DateOfBirth", entity.DateOfBirth);
parameterlist.Add("@PlaceOfBirth", entity.PlaceOfBirth);
parameterlist.Add("@AdharcardNo", entity.AdharcardNo);
parameterlist.Add("@DateOfAdmission", entity.DateOfAdmission);
parameterlist.Add("@MotherTounge", entity.MotherTounge);
parameterlist.Add("@UStudentId", entity.UStudentId);
parameterlist.Add("@LastSchoolAttended", entity.LastSchoolAttended);
parameterlist.Add("@Progress", entity.Progress);
parameterlist.Add("@Conduct", entity.Conduct);
parameterlist.Add("@DateOfLeavingSchool", entity.DateOfLeavingSchool);
parameterlist.Add("@LastSchoolClass", entity.LastSchoolClass);
parameterlist.Add("@LastSchoolTCNo", entity.LastSchoolTCNo);
parameterlist.Add("@ClassInWhichStudingAndSinceWhen", entity.ClassInWhichStudingAndSinceWhen);
parameterlist.Add("@ReasonForLeavingSchool", entity.ReasonForLeavingSchool);
parameterlist.Add("@RemarkOnTC", entity.RemarkOnTC);
parameterlist.Add("@Status", entity.Status == true ? 1 : 0);
parameterlist.Add("@Remark", entity.Remark);
parameterlist.Add("@PrevSchoolDateofLiving", entity.PrevSchoolDateofLiving);
parameterlist.Add("@OUT_StudentId", null);
Hashtable outparameterlist = new Hashtable();
int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentInsert", parameterlist, ref outparameterlist);
int studentId = 0;
if (outparameterlist != null && outparameterlist.Count > 0)
{
foreach (string parametername in outparameterlist.Keys)
{
if (parametername.StartsWith("@OUT_"))
{
studentId = Convert.ToInt32(outparameterlist[parametername]);
}
}
}
return(studentId);
}
catch (Exception ex)
{
throw;
}
}
public IQueryable <Employee> GetAll(int schoolId)
{
try
{
List <Employee> entites = new List <Employee>();
String SqlQuery = "select * from Employee";
if (schoolId != 0)
{
SqlQuery = SqlQuery + " where SchoolId=" + schoolId + ";";
}
DataTable dataTable = CommanMethodsForSQL.GetDataTable(SqlQuery);
if (dataTable != null && dataTable.Rows.Count > 0)
{
foreach (DataRow dr in dataTable.Rows)
{
if (dr != null)
{
Employee entity = new Employee();
entity.EmployeeId = Convert.ToInt32(dr["EmployeeId"]);
entity.EmployeeCode = Convert.ToString(dr["EmployeeCode"]);
entity.Password = Convert.ToString(dr["Password"]);
entity.FirstName = Convert.ToString(dr["FirstName"]);
entity.MiddleName = Convert.ToString(dr["MiddleName"]);
entity.LastName = Convert.ToString(dr["LastName"]);
entity.Category = Convert.ToString(dr["Category"]);
entity.Address = Convert.ToString(dr["Address"]);
entity.ContactNo = Convert.ToString(dr["ContactNo"]);
if (dr["DOB"] != DBNull.Value)
{
entity.DOB = Convert.ToDateTime(dr["DOB"]);
}
if (dr["JoiningDate"] != DBNull.Value)
{
entity.JoiningDate = Convert.ToDateTime(dr["JoiningDate"].ToString());
}
entites.Add(entity);
}
}
}
return(entites.AsQueryable());
}
catch (Exception ex)
{
throw;
}
}
public void Delete(int Id)
{
try
{
string queryString = string.Format(" DELETE FROM [StudentLedger] WHERE StudentLedgerId = {0};", Id);
int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString);
}
catch (Exception ex)
{
throw;
}
}
public void Delete(int Id)
{
try
{
string queryString = string.Format(" DELETE FROM [ReligionDetails] WHERE ReligionId = {0};", Id);
int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString);
}
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 void Edit(StudentAddress entity)
{
try
{
//string queryString = string.Format(" UPDATE [StudentAddressDetails] " +
// " SET [CurrentAddress] ='{0}'"
// +", [CurrentCountryId]='{1}'"
// +", [CurrentStateId]='{2}'"
// +", [CurrentDistrictId]='{3}'"
// +", [CurrentCityId]='{4}'"
// +", [CurrentPinCode]='{5}'"
// +", [PermentAddress]='{6}'"
// +", [PermentCountryId]='{7}'"
// +", [PermentStateId]='{8}'"
// +", [PermentDistrictId]='{9}'"
// +", [PermentCityId]='{10}'"
// +", [PermentPinCode]='{11}'"
// + ",[Status] = '{12}'"
// + ",[Remark] = '{13}'"
// + " WHERE StudentId = {14};"
// , entity.CurrentAddress, entity.CurrentCountryId, entity.CurrentStateId, entity.CurrentDistrictId, entity.CurrentCityId, entity.CurrentPinCode
// , entity.PermentAddress, entity.PermentCountryId, entity.PermentStateId, entity.PermentDistrictId, entity.PermentCityId, entity.PermentPinCode
// , entity.Status, entity.Remark, entity.StudentId);
//int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString);
Hashtable parameterlist = new Hashtable();
parameterlist.Add("@StudentId", entity.StudentId);
parameterlist.Add("@CurrentAddress", entity.CurrentAddress);
parameterlist.Add("@CurrentCountryId", entity.CurrentCountryId);
parameterlist.Add("@CurrentStateId", entity.CurrentStateId);
parameterlist.Add("@CurrentDistrictId", entity.CurrentDistrictId);
parameterlist.Add("@CurrentCityId", entity.CurrentCityId);
parameterlist.Add("@CurrentPinCode", entity.CurrentPinCode);
parameterlist.Add("@PermentAddress", entity.PermentAddress);
parameterlist.Add("@PermentCountryId", entity.PermentCountryId);
parameterlist.Add("@PermentStateId", entity.PermentStateId);
parameterlist.Add("@PermentDistrictId", entity.PermentDistrictId);
parameterlist.Add("@PermentCityId", entity.PermentCityId);
parameterlist.Add("@PermentPinCode", entity.PermentPinCode);
parameterlist.Add("@Status", entity.Status);
parameterlist.Add("@Remark", entity.Remark);
int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentAddressDetailsUpdate", parameterlist);
}
catch (Exception ex)
{
throw;
}
}
public void Add(Employee entity, int schoolId)
{
try
{
string queryString = string.Format("INSERT INTO [Employee]([SchoolId],[EmployeeCode],[Password],[FirstName],[MiddleName],[LastName],[Category],[Address],[ContactNo],[DOB],[JoiningDate])" +
" VALUES( N'{0}', N'{1}',N'{2}',N'{3}', N'{4}', N'{5}', N'{6}',N'{7}', N'{8}', convert(date,'{9}',105), convert(date,'{10}',105)) ;", schoolId, entity.EmployeeCode, entity.Password, entity.FirstName, entity.MiddleName, entity.LastName, entity.Category, entity.Address, entity.ContactNo, entity.DOB, entity.JoiningDate);
string s = queryString;
int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString);
}
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 void Add(StudentAddress entity)
{
try
{
//string queryString = string.Format(" INSERT INTO [StudentAddressDetails]("
// +" [StudentId]"
// +", [CurrentAddress]"
// +", [CurrentCountryId]"
// +", [CurrentStateId]"
// +", [CurrentDistrictId]"
// +", [CurrentCityId]"
// +", [CurrentPinCode]"
// +", [PermentAddress]"
// +", [PermentCountryId]"
// +", [PermentStateId]"
// +", [PermentDistrictId]"
// +", [PermentCityId]"
// +", [PermentPinCode]"
// +", [Status]"
// +", [Remark]"
// + ") VALUES({0}, '{1}','{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}');"
// , entity.StudentId, entity.CurrentAddress, entity.CurrentCountryId, entity.CurrentStateId, entity.CurrentDistrictId, entity.CurrentCityId, entity.CurrentPinCode
// , entity.PermentAddress, entity.PermentCountryId, entity.PermentStateId, entity.PermentDistrictId, entity.PermentCityId, entity.PermentPinCode
// ,entity.Status, entity.Remark);
//int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString);
Hashtable parameterlist = new Hashtable();
parameterlist.Add("@StudentId", entity.StudentId);
parameterlist.Add("@CurrentAddress", entity.CurrentAddress);
parameterlist.Add("@CurrentCountryId", entity.CurrentCountryId);
parameterlist.Add("@CurrentStateId", entity.CurrentStateId);
parameterlist.Add("@CurrentDistrictId", entity.CurrentDistrictId);
parameterlist.Add("@CurrentCityId", entity.CurrentCityId);
parameterlist.Add("@CurrentPinCode", entity.CurrentPinCode);
parameterlist.Add("@PermentAddress", entity.PermentAddress);
parameterlist.Add("@PermentCountryId", entity.PermentCountryId);
parameterlist.Add("@PermentStateId", entity.PermentStateId);
parameterlist.Add("@PermentDistrictId", entity.PermentDistrictId);
parameterlist.Add("@PermentCityId", entity.PermentCityId);
parameterlist.Add("@PermentPinCode", entity.PermentPinCode);
parameterlist.Add("@Status", entity.Status);
parameterlist.Add("@Remark", entity.Remark);
int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentAddressDetailsInsert", parameterlist);
}
catch (Exception ex)
{
throw;
}
}
public IQueryable <HomePage> getClasswiseMaleFemaleList(int schoolId)
{
HomePage entity = new HomePage();
entity.classList = new List <String>();
entity.classwiseBoysList = new List <int>();
entity.classwiseGirlsList = new List <int>();
List <HomePage> entites = new List <HomePage>();
try
{
String SqlQuery = "select class, countMale, CountFemale from view_ClassWiseMaleFemale";
if (schoolId != 0)
{
SqlQuery = SqlQuery + " where SchoolId=" + schoolId;
}
SqlQuery = SqlQuery + " order by LEN(Class), Class;";
DataTable dataTable = CommanMethodsForSQL.GetDataTable(SqlQuery);
if (dataTable != null && dataTable.Rows.Count > 0)
{
foreach (DataRow dr in dataTable.Rows)
{
if (dr != null)
{
entity.classList.Add(Convert.ToString((dr["Class"])));
entity.classwiseBoysList.Add(Convert.ToInt32((dr["CountMale"])));
entity.classwiseGirlsList.Add(Convert.ToInt32((dr["CountFemale"])));
entites.Add(entity);
}
}
}
else
{
entity.classList.Add("");
entity.classwiseBoysList.Add(0);
entity.classwiseGirlsList.Add(0);
entites.Add(entity);
}
}
catch (Exception ex)
{
throw ex;
}
return(entites.AsQueryable());
}
