public Response Update_tbAttendance(AttendanceCustomModel objModel)
{
DateTime DateCheck = objModel.AttendanceDate.Add(new TimeSpan(5, 30, 0));
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
tblAttendance cmd = dbcontext.tblAttendances.FirstOrDefault(x =>
x.IsDeleted == false && x.AdmissionId == objModel.AdmissionId &&
x.AttendanceDate.Year == DateCheck.Year &&
x.AttendanceDate.Month == DateCheck.Month &&
x.AttendanceDate.Day == DateCheck.Day &&
x.SectionId == objModel.SectionId
);
if (cmd != null)
{
cmd.Attendance = objModel.Attendance;
dbcontext.SaveChanges();
response.message = "Record Updated Successfully!!";
}
return(response);
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
return(response);
}
}
}
}
public Response GetAttendanceListing(AttendanceCustomModel objModel)
{
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
var rs = dbcontext.USP_GetAttendanceDetail(objModel.SectionId, objModel.AttendanceDate).ToList();
if (rs.Count > 0)
{
//return rs;
response.message = "Update";
response.responseData = rs;
}
else
{
var rs2 = dbcontext.USP_BindStudentWithClassAndSection(objModel.SessionId, objModel.ClassId, objModel.SectionId, "").ToList();
//return rs2;
response.message = "Insert";
response.responseData = rs2;
}
return(response);
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
return(response);
}
}
//return response;
}
}
public object BindSessionClassEnquiry(int?SessionId, int?ClassId, int?SectionId, string StudentName)
{
List <EnquiryDetailCustomModel> objListModel = new List <EnquiryDetailCustomModel>();
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
// -------------- Main -----------------
objListModel = (from P in dbcontext.tblPromoteToClasses
join A in dbcontext.tblAdmissions on P.AdmissionId equals A.AdmissionId
join E in dbcontext.tblEnquiryDetails on A.EnquiryId equals E.EnquiryId
where E.IsDeleted == false && E.Status == "Registered" &&
P.IsActive == true &&
(SessionId == null || SessionId == 0 || P.SessionId == SessionId) &&
(ClassId == null || ClassId == 0 || P.ClassId == ClassId) &&
(SectionId == null || SectionId == 0 || P.SectionId == SectionId)
select new EnquiryDetailCustomModel
{
SessionId = P.SessionId,
SessionName = P.SessionId != null ? P.tblSession.Session : "",
ClassId = P.ClassId,
ClassName = P.ClassId != null ? P.tblClass.Title : "",
SectionId = P.SectionId,
SectionName = P.SectionId != null ? P.tblSection.Title : "",
//AdmissionId = P.AdmissionId,
AdmissionModel = dbcontext.tblAdmissions.Where(a => a.EnquiryId == E.EnquiryId).Select(s => new AdmissionCustomModel
{
AdmissionId = s.AdmissionId,
AdmissionDate = s.AdmissionDate,
TotalFees = s.TotalFees,
RegistrationFees = s.RegistrationFees,
DiscountType = s.DiscountType,
DiscountAmount = s.DiscountAmount,
FeeIncharge = s.FeeIncharge,
BalanceAmountDue = s.BalanceAmountDue,
PaymentMode = s.PaymentMode
}).FirstOrDefault(),
FName = E.FName,
LName = E.LName,
MobileNo = E.MobileNo,
EmailId = E.EmailId,
}).ToList();
// -------------- Main End -----------------
return(objListModel);
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
return(response);
}
}
}
}
public object GetEnquiryId(int AdmissionId)
{
StudentCommonDetail objResult = new StudentCommonDetail();
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
objResult = dbcontext.GetEnquiryIdFromAdmissionId(AdmissionId)
.Select(x => new StudentCommonDetail
{
EnquiryId = x.EnquiryId,
SessionId = x.SessionId,
ClassId = x.ClassId,
SectionId = x.SectionId
}).FirstOrDefault();
}
catch (Exception ex)
{
dbcontext.Dispose();
throw ex;
}
}
return(objResult);
}
}
public int GetTotalStudentInSection(int?SessionId, int?ClassId, int?SectionId)
{
int TotalStudent = 0;
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
TotalStudent = dbcontext.tblPromoteToClasses.Where(x => x.IsDeleted == false &&
(SessionId == null || SessionId == 0 || x.SessionId == SessionId) &&
(ClassId == null || ClassId == 0 || x.ClassId == ClassId) &&
(SectionId == null || SectionId == 0 || x.SectionId == SectionId)
).Count();
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
TotalStudent = 0;
}
}
}
return(TotalStudent);
}
public int CancelAllocatedStudentSection(int Id)
{
int Result = 0;
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
var rs = dbcontext.tblPromoteToClasses.FirstOrDefault(x => x.PromoteToClassId == Id);
if (rs != null)
{
rs.SectionId = null;
rs.RollNo = null;
rs.Status = null;
}
dbcontext.SaveChanges();
Result = 1;
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
Result = 0;
}
}
}
return(Result);
}
public EmployeeMasterCustomModel GetById(int Id)
{
EmployeeMasterCustomModel objListModel = new EmployeeMasterCustomModel();
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
objListModel = dbcontext.tblEmployees.Where(x => x.IsDeleted == false && x.EmployeeId == Id)
.Select(x => new EmployeeMasterCustomModel
{
EmployeeId = x.EmployeeId,
FName = x.FName,
LName = x.LName,
EmailId = x.EmailId,
MobileNo = x.MobileNo,
City = x.City,
State = x.State,
Country = x.Country,
Address = x.Address,
Address2 = x.Address2,
BloodGroup = x.BloodGroup,
DateOfBirth = x.DateOfBirth,
DateOfJoining = x.DateOfJoining,
Designation = x.Designation,
Experience = x.Experience,
Qualification = x.Qualification,
SchoolId = x.SchoolId,
DDate = x.DDate,
Image = x.Image,
IsActive = x.IsActive,
IsDeleted = x.IsDeleted,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate
}).SingleOrDefault();
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
objListModel = null;
}
}
}
return(objListModel);
}
public List <EmployeeMasterModel> GetEmployeeMaster()
{
using (dbcontext = new SchoolManagementEntities())
{
var rs = dbcontext.tblEmployees.Where(x => x.IsActive == true &&
x.IsDeleted == false).OrderBy(y => y.FName)
.Select(x => new EmployeeMasterModel
{
EmployeeId = x.EmployeeId,
EmployeeName = x.FName + " " + x.LName,
}).ToList();
return(rs);
}
}
public object GetFeeCollectionListing(FeeCollectionCustomModel objModel)
{
IList <FeeCollectionCustomModel> FeeListModel = new List <FeeCollectionCustomModel>();
IQueryable <FeeCollectionCustomModel> FeeListDetail = null;
int TotalRec = 0;
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
FeeListDetail = dbcontext.tblFeeCollections.Where(x => x.IsDeleted == false)
.Select(x => new FeeCollectionCustomModel
{
FeeCollectionId = x.FeeCollectionId,
SchoolId = x.SchoolId,
EnquiryId = x.EnquiryId,
AdmissionId = x.AdmissionId,
AmountPaid = x.AmountPaid,
FeeMode = x.FeeMode,
FeeDate = x.FeeDate,
FeeInCharge = x.FeeInCharge,
FeeType = x.FeeType,
IsActive = x.IsActive,
IsDeleted = x.IsDeleted,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate
}).OrderByDescending(x => x.FeeCollectionId);
TotalRec = FeeListDetail.Count();
FeeListModel = FeeListDetail.ToList() as IList <FeeCollectionCustomModel>;
return(FeeListModel);
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
return(response);
}
}
}
}
public int InsertStudentSectionAllocation(int SessionId, int ClassId, int EnquiryId, int AdmissionId, int SectionId, bool isactive, string status)
{
int TotalStudent = 0;
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
tblPromoteToClass obj = new tblPromoteToClass();
if (obj != null)
{
obj.AdmissionId = AdmissionId;
obj.SectionId = SectionId;
obj.IsActive = isactive;
obj.Status = status;
dbcontext.tblPromoteToClasses.Add(obj);
dbcontext.SaveChanges();
tblEnquiryDetail obj1 = dbcontext.tblEnquiryDetails.Where(x => x.EnquiryId == EnquiryId).FirstOrDefault();
if (obj1 != null)
{
obj1.SectionId = SectionId;
dbcontext.SaveChanges();
}
tblAdmission obj2 = dbcontext.tblAdmissions.Where(x => x.AdmissionId == AdmissionId).FirstOrDefault();
if (obj2 != null)
{
obj2.InSectionStatus = status;
dbcontext.SaveChanges();
}
}
TotalStudent = 1;
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
TotalStudent = 0;
}
}
}
return(TotalStudent);
}
public List <ClassMasterModel> BindSessionClass(int SessionId)
{
using (dbcontext = new SchoolManagementEntities())
{
var rs = dbcontext.tblClasses.Where(x => x.IsActive == true &&
x.IsDeleted == false &&
(SessionId == 0 || x.SessionId == SessionId)).OrderBy(y => y.Title)
.Select(x => new ClassMasterModel
{
ClassId = x.ClassId,
Title = x.Title,
}).ToList();
return(rs);
}
}
public List <SectionMasterModel> BindClassSection(int ClassId)
{
using (dbcontext = new SchoolManagementEntities())
{
var rs = dbcontext.tblSections.Where(x => x.IsActive == true &&
x.IsDeleted == false &&
(ClassId == 0 || x.ClassId == ClassId)).OrderBy(y => y.Title)
.Select(x => new SectionMasterModel
{
SectionId = x.SectionId,
Title = x.Title,
}).ToList();
return(rs);
}
}
public Response UpdatePassword(ChangePasswordCustomModel objModel)
{
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
var rs = dbcontext.tblUserLogins.FirstOrDefault(x => x.IsDeleted == false && x.UserName == objModel.UserName);
if (rs != null)
{
var objUpdate = dbcontext.tblUserLogins.FirstOrDefault(m => m.IsDeleted == false && m.Password == objModel.Password);
if (objUpdate != null)
{
objUpdate.Password = objModel.NewPassword;
objUpdate.ModifiedBy = objModel.ModifiedBy;
objUpdate.ModifiedDate = DateTime.Now;
dbcontext.SaveChanges();
response.responseData = new { SectionId = objUpdate.Id };
response.success = true;
response.message = "1";
}
else
{
response.success = false;
response.message = "2";
}
}
else
{
response.success = false;
response.message = "3";
}
return(response);
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
return(response);
}
}
}
}
public int?GetSessionID()
{
int?intSessionId = null;
using (dbcontext = new SchoolManagementEntities())
{
try
{
intSessionId = (from obj in dbcontext.tblSessions.Where(x => x.IsActive == true && x.IsDefault == true)
select obj.SessionId).Take(1).SingleOrDefault();
}
catch (Exception ex)
{
}
return(intSessionId);
}
}
public object GetFeeCollectionReceiptDetail(int ReceiptId, int?AdmissionId)
{
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
return(dbcontext.USP_FeeCollectionReceipt(ReceiptId, AdmissionId).FirstOrDefault());
}
catch (Exception ex)
{
dbcontext.Dispose();
throw ex;
}
}
}
}
public object GetStudentFeeDetail(int AdmissionId, int?ClassId, int?SectionId)
{
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
return(dbcontext.USP_GetFeeCollectionDetail(AdmissionId, ClassId, SectionId).ToList());
}
catch (Exception ex)
{
dbcontext.Dispose();
throw ex;
}
}
}
}
public FeeCollectionCustomModel GetById(int Id)
{
FeeCollectionCustomModel objListModel = new FeeCollectionCustomModel();
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
objListModel = dbcontext.tblFeeCollections.Where(x => x.IsDeleted == false && x.FeeCollectionId == Id)
.Select(x => new FeeCollectionCustomModel
{
FeeCollectionId = x.FeeCollectionId,
SchoolId = x.SchoolId,
EnquiryId = x.EnquiryId,
AdmissionId = x.AdmissionId,
ClassId = x.ClassId,
SectionId = x.SectionId,
AmountPaid = x.AmountPaid,
FeeMode = x.FeeMode,
FeeDate = x.FeeDate,
FeeInCharge = x.FeeInCharge,
FeeType = x.FeeType,
IsActive = x.IsActive,
IsDeleted = x.IsDeleted,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate
}).SingleOrDefault();
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
objListModel = null;
}
}
}
return(objListModel);
}
/// <summary>
/// Authenticate the Login User
/// </summary>
/// <param name="_userName"></param>
/// <param name="password"></param>
/// <returns></returns>
public UserLoginCustomModel Authenticate(string UserName, string Password)
{
UserLoginCustomModel objModel = new UserLoginCustomModel();
string IsSuccess = "false";
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
{
if (UserName.Contains("@"))
{
var UserDetails = dbcontext.tblUserLogins.Where(x => x.UserName == UserName && x.Password == Password).FirstOrDefault();
if (UserDetails != null)
{
objModel.Id = UserDetails.Id;
objModel.FName = UserDetails.FName;
objModel.LName = UserDetails.LName;
objModel.EmailId = UserDetails.EmailId;
objModel.UserName = UserDetails.UserName;
objModel.Password = UserDetails.Password;
IsSuccess = "true";
}
else
{
IsSuccess = "false";
}
}
}
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
objModel = null;
}
}
}
return(objModel);
}
public object SetDefaultSessionRegistrationDetail(SessionMasterCustomModel objModel)
{
object objClassResult = new object();
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
var CheckActive = dbcontext.tblSessions.FirstOrDefault(x => x.IsDefault == true && x.SessionId != objModel.SessionId);
if (CheckActive == null)
{
var rs = dbcontext.tblSessions.FirstOrDefault(x => x.SessionId == objModel.SessionId);
if (rs != null)
{
rs.IsDefault = rs.IsDefault == true ? false : true;
rs.ModifiedDate = DateTime.Now;
rs.ModifiedBy = objModel.ModifiedBy;
dbcontext.SaveChanges();
objClassResult = true;
}
else
{
objClassResult = false;
}
}
else
{
objClassResult = false;
}
}
catch (Exception ex)
{
dbcontext.Dispose();
objClassResult = null;
throw ex;
}
}
return(objClassResult);
}
}
public AdmissionFeeMasterCustomModel GetById(int Id)
{
AdmissionFeeMasterCustomModel objListModel = new AdmissionFeeMasterCustomModel();
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
objListModel = dbcontext.tblAdmissionFees.Where(x => x.IsDeleted == false && x.AdmissionFeeId == Id)
.Select(x => new AdmissionFeeMasterCustomModel
{
AdmissionFeeId = x.AdmissionFeeId,
SchoolId = x.SchoolId,
SchoolName = x.SchoolId != null ? x.tblSchool.Name : "",
ClassId = x.ClassId,
ClassName = x.ClassId != null ? x.tblClass.Title : "",
SessionId = x.SessionId,
SessionName = x.SessionId != null ? x.tblSession.Session : "",
AdmissionFee = x.AdmissionFee,
Discount = x.Discount,
NetAdmissionFee = x.NetAdmissionFee,
IsActive = x.IsActive,
IsDeleted = x.IsDeleted,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate
}).SingleOrDefault();
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
objListModel = null;
}
}
}
return(objListModel);
}
public SectionMasterCustomModel GetById(int Id)
{
SectionMasterCustomModel SectionListModel = new SectionMasterCustomModel();
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
SectionListModel = dbcontext.tblSections.Where(x => x.IsDeleted == false && x.SectionId == Id)
.Select(x => new SectionMasterCustomModel
{
SectionId = x.SectionId,
SchoolId = x.SchoolId,
SchoolName = x.SchoolId != null ? x.tblSchool.Name : "",
SessionId = x.ClassId != null ? x.tblClass.SessionId : 0,
ClassId = x.ClassId,
ClassName = x.ClassId != null ? x.tblClass.Title : "",
Title = x.Title,
Image = x.Image,
DDate = x.DDate,
ShortDescription = x.ShortDescription,
IsActive = x.IsActive,
IsDeleted = x.IsDeleted,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate
}).SingleOrDefault();
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
SectionListModel = null;
}
}
}
return(SectionListModel);
}
// ****************************** Start Reporting Section Code **********************************
public object BindEnquiryReport(DateTime?FromDate, DateTime?ToDate, int?SessionId, int?ClassId, int?SectionId, string EnquiryStatus, string StudentName)
{
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
var rs = dbcontext.USP_BindEnquiryReport(FromDate, ToDate, SessionId, ClassId, SectionId, EnquiryStatus, StudentName)
.Select(x => new EnquiryDetailCustomModel
{
EnquiryId = x.EnquiryId,
SessionId = x.SessionId,
SessionName = x.Session,
ClassId = x.ClassId,
ClassName = x.Title,
SectionId = x.SectionId,
FName = x.StudentName,
MobileNo = x.MobileNo,
EmailId = x.EmailId,
FatherName = x.FatherName,
MotherName = x.MotherName,
Village = x.Village,
Address = x.Address,
AadharNumber = x.AadharNumber,
EnquiryDate = x.EnquiryDate,
Status = x.Status,
}).ToList();
return(rs);
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
return(response);
}
}
}
}
public ProfileCustomModel GetById(int Id)
{
ProfileCustomModel objListModel = new ProfileCustomModel();
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
objListModel = dbcontext.tblUserLogins.Where(x => x.IsDeleted == false && x.Id == Id)
.Select(x => new ProfileCustomModel
{
Id = x.Id,
UserTypeId = x.UserTypeId,
EmployeeId = x.EmployeeId,
FName = x.FName,
LName = x.LName,
EmailId = x.EmailId,
Mobile = x.Mobile,
UserName = x.UserName,
Password = x.Password,
IsActive = x.IsActive,
IsDeleted = x.IsDeleted,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate
}).SingleOrDefault();
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
objListModel = null;
}
}
}
return(objListModel);
}
public dynamic login(string email, string pwd)
{
string emailID = email;
string password = pwd;
using (SchoolManagementEntities db = new SchoolManagementEntities())
{
var user = db.Logins.Where(i => i.EmailID == emailID && i.Password == password).FirstOrDefault();
if (user != null)
{
string token = Convert.ToBase64String(Guid.NewGuid().ToByteArray());
MemoryCache mc = MemoryCache.Default;
mc.Add("token", token, DateTimeOffset.UtcNow.AddDays(1));
return(token);
}
return("Please enter correct email and password");
}
}
public List <SessionMasterModel> GetSessionMaster()
{
List <SessionMasterModel> SessionListModel = new List <SessionMasterModel>();
IQueryable <SessionMasterModel> SessionListDetail = null;
using (dbcontext = new SchoolManagementEntities())
{
SessionListDetail = dbcontext.tblSessions.Where(x => x.IsActive == true &&
x.IsDeleted == false).OrderBy(y => y.Session)
.Select(x => new SessionMasterModel
{
SessionId = x.SessionId,
Title = x.Session,
});
SessionListModel = SessionListDetail.ToList();
return(SessionListModel);
}
}
public BusChargesMasterCustomModel GetById(int Id)
{
BusChargesMasterCustomModel objListModel = new BusChargesMasterCustomModel();
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
objListModel = dbcontext.tblBusChargesMasters.Where(x => x.IsDeleted == false && x.BusChargesMasterId == Id)
.Select(x => new BusChargesMasterCustomModel
{
BusChargesMasterId = x.BusChargesMasterId,
SchoolId = x.SchoolId,
SchoolName = x.tblSchool != null ? x.tblSchool.Name : "",
SessionId = x.SessionId,
SessionName = x.SessionId != null ? x.tblSession.Session : "",
StartPoint = x.StartPoint,
EndPoint = x.EndPoint,
Amount = x.Amount,
IsActive = x.IsActive,
IsDeleted = x.IsDeleted,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate
}).SingleOrDefault();
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
objListModel = null;
}
}
}
return(objListModel);
}
public bool FindById(int Id)
{
bool ActiveResult = false;
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
ActiveResult = dbcontext.tblEnquiryDetails.FirstOrDefault(x => x.EnquiryId == Id).IsActive ?? false;
}
catch (Exception ex)
{
dbcontext.Dispose();
throw ex;
}
}
return(ActiveResult);
}
}
public object GetDashboardEnquiryCount(int?SessionId, int?ClassId)
{
List <USP_GetSchoolEnquiryAdmissionCount_Result> objListDashboard = new List <USP_GetSchoolEnquiryAdmissionCount_Result>();
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
objListDashboard = dbcontext.USP_GetSchoolEnquiryAdmissionCount(SessionId, ClassId).ToList();
return(objListDashboard);
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
return(response);
}
}
}
}
public List <ClassMasterModel> GetClassMaster(int?SessionId)
{
List <ClassMasterModel> ClassListModel = new List <ClassMasterModel>();
IQueryable <ClassMasterModel> ClassListDetail = null;
using (dbcontext = new SchoolManagementEntities())
{
ClassListDetail = dbcontext.tblClasses.Where(x => x.IsActive == true &&
x.IsDeleted == false &&
(SessionId == 0 || SessionId == null || x.SessionId == SessionId)
).OrderBy(y => y.Title)
.Select(x => new ClassMasterModel
{
ClassId = x.ClassId,
Title = x.Title,
});
ClassListModel = ClassListDetail.ToList();
return(ClassListModel);
}
}
public SessionMasterCustomModel GetById(int Id)
{
SessionMasterCustomModel objListModel = new SessionMasterCustomModel();
using (response = new Response())
{
using (dbcontext = new SchoolManagementEntities())
{
try
{
response.success = true;
objListModel = dbcontext.tblSessions.Where(x => x.IsDeleted == false && x.SessionId == Id)
.Select(x => new SessionMasterCustomModel
{
SessionId = x.SessionId,
Session = x.Session,
Description = x.Description,
DDate = x.DDate,
IsDefault = x.IsDefault,
IsActive = x.IsActive,
IsDeleted = x.IsDeleted,
CreatedBy = x.CreatedBy,
CreatedDate = x.CreatedDate,
ModifiedBy = x.ModifiedBy,
ModifiedDate = x.ModifiedDate
}).SingleOrDefault();
}
catch (Exception ex)
{
response.success = false;
response.message = ex.Message;
objListModel = null;
}
}
}
return(objListModel);
}