public bool Put(int AdmissionId, AdmissionForm student)
{
ClassController _class = new ClassController();
if (!ModelState.IsValid)
{
return(false);
}
if (AdmissionId != student.AdmissionId)
{
return(false);
}
try
{
Convert.ToInt32(student.Class);
}
catch (Exception ex)
{
student.Class = _class.GetClassID(student.Class).ToString();
}
SchoolDB.Entry(student).State = EntityState.Modified;
try
{
SchoolDB.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return(false);
}
return(true);
}
public bool UpdateFeeHead(int FID, NewFeeHeading newFeeHeading)
{
ClassController _class = new ClassController();
if (!ModelState.IsValid)
{
return(false);
}
if (FID != newFeeHeading.FID)
{
return(false);
}
newFeeHeading.Class = Convert.ToString(_class.GetClassID(newFeeHeading.Class));
SchoolDB.Entry(newFeeHeading).State = EntityState.Modified;
try
{
SchoolDB.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return(false);
}
return(true);
}
public IEnumerable <MonthAttendanceReport> GetMonthlyAttendance(string ClassVal)
{
var ReturnVal = from bs in SchoolDB.StAttendances.Where(x => x.Session == SchoolSession).ToList()
where Convert.ToDateTime(bs.Date).Month == DateTime.Now.Month
group bs by new
{
bs.StAdmNo,
bs.StName,
bs.StClass
}
into g
select new MonthAttendanceReport
{
AdmissionNo = g.Key.StAdmNo,
Name = g.Key.StName,
Class = g.Key.StClass,
Present = g.Sum(x => x.Attendance.ToUpper() == "PRESENT" ? 1 : 0),
Absent = g.Sum(x => x.Attendance.ToUpper() == "ABSENT" ? 1 : 0),
Leave = g.Sum(x => x.Attendance.ToUpper() == "LEAVE" ? 1 : 0),
TotalDays = DateTime.Now.Day
};
ClassController _class = new ClassController();
List <MonthAttendanceReport> ReportList = new List <MonthAttendanceReport>();
foreach (var item in ReturnVal)
{
item.Class = _class.GetClassName(item.Class);
ReportList.Add(item);
}
return(ReportList);
}
// GET api/school/5
public List <AdmissionForm> GetStudentDetails()
{
ClassController _class = new ClassController();
var studentDetails = SchoolDB.AdmissionForms.Where(x => x.ESession.Contains(SchoolSession)).OrderBy(x => x.Class).ThenBy(z => z.StFirstName).ToList();
studentDetails.ForEach(cc => cc.Class = _class.GetClassName(cc.Class));
return(studentDetails);
}
public List <tbl_homework> GetHomeworks()
{
ClassController _class = new ClassController();
var Homeworks = unitOfWork.HomeworkRepository.Get(orderBy: q => q.OrderBy(s => s.id));
Homeworks.ForEach(cc => cc.@class = _class.GetClassName(cc.@class));
return(Homeworks);
}
public List <StAttendance> GetAttendanceCharge()
{
var AttendanceCharge = SchoolDB.StAttendances.Where(x => x.Session == SchoolSession).OrderByDescending(x => x.ID).ToList();
ClassController _class = new ClassController();
AttendanceCharge.ForEach(x => x.StClass = _class.GetClassName(x.StClass));
return(AttendanceCharge);
}
public List <NewFeeHeading> GetFeeHeads()
{
ClassController _class = new ClassController();
var NewFeeHeadings = SchoolDB.NewFeeHeadings.OrderBy(x => x.FID).ToList();
NewFeeHeadings.ForEach(x => x.Class = _class.GetClassName(x.Class));
return(NewFeeHeadings);
}
public List <NewFeeHeading> GetAllNewFeeHeading()
{
var classFeeDetail = (from x in SchoolDB.NewFeeHeadings
select x);
ClassController _class = new ClassController();
classFeeDetail.ToList().ForEach(x => x.Class = _class.GetClassName(x.Class));
List <NewFeeHeading> FeeHeading = classFeeDetail.ToList();
return(FeeHeading);
}
public List <NewFeeHeading> GetNewFeeHeading(string SelectedClass)
{
ClassController _class = new ClassController();
string Selected = _class.GetClassID(SelectedClass).ToString();
var classFeeDetail = (from x in SchoolDB.NewFeeHeadings
where x.Class.Equals(Selected)
select x);
var classFeeDetails = classFeeDetail.ToList();
return(classFeeDetails);
}
public bool IsAttendanceMarked(List <StAttendance> Attendance)
{
ClassController _class = new ClassController();
Attendance.ForEach(x => x.StClass = _class.GetClassID(x.StClass).ToString());
var SelectedClass = Attendance.GroupBy(
p => p.StClass,
(key, g) => new { stClass = key }).FirstOrDefault();
var list = SchoolDB.StAttendances.ToList().Where(x => x.StClass == SelectedClass.stClass && x.Session == SchoolSession && x.Date.Value.ToString("MM-dd-yyyy") == DateTime.Now.ToString("MM-dd-yyyy")).ToList();
return(list.Any());
}
public List <AdmissionForm> GetMultiChildParent()
{
ClassController _class = new ClassController();
var studentDetails = SchoolDB.AdmissionForms.Where(x => x.ESession.Contains(SchoolSession)).OrderBy(x => x.Class).ToList();
studentDetails.ForEach(cc => cc.Class = _class.GetClassName(cc.Class));
studentDetails = studentDetails.GroupBy(item => item.FatherName)
.Where(group => group.Count() > 1)
.SelectMany(group => group)
.ToList();
return(studentDetails);
}
public List <StudentFeeDetail> GetAllSubmitedFeeDetail(string Session)
{
var StFeeDetail = (from x in SchoolDB.StudentFeeDetails
where x.Session.Equals(Session)
orderby x.Id descending
select x);
var StFeeDetails = StFeeDetail.ToList();
ClassController _class = new ClassController();
StFeeDetails.ForEach(x => x.Class = _class.GetClassName(x.Class));
return(StFeeDetails);
}
// GET api/school/5
public List <StudentFeeDetail> GetStudentFeeDetail(string AdmNo, string Session)
{
string admissionNo = AdmNo.ToString();
ClassController _class = new ClassController();
var StFeeDetail = (from x in SchoolDB.StudentFeeDetails
where x.AdmissionNo.Equals(admissionNo) && x.Session.Equals(Session)
orderby x.Id descending
select x);
var StFeeDetails = StFeeDetail.ToList();
StFeeDetails.ForEach(x => x.Class = _class.GetClassName(x.Class));
return(StFeeDetails);
}
public List <AdmissionForm> GetStudentDetailByClass(string ClassID)
{
ClassController _class = new ClassController();
List <AdmissionForm> studentDetails;
if (ClassID != "0")
{
studentDetails = SchoolDB.AdmissionForms.Where(x => x.ESession.Contains(SchoolSession) && x.Class == ClassID).OrderBy(x => x.Class).ThenBy(z => z.StFirstName).ToList();
}
else
{
studentDetails = SchoolDB.AdmissionForms.Where(x => x.ESession.Contains(SchoolSession)).OrderBy(x => x.Class).ThenBy(z => z.StFirstName).ToList();
}
studentDetails.ForEach(cc => cc.Class = _class.GetClassName(cc.Class));
return(studentDetails);
}
// GET api/school/5
public List <ChartData> GetClassFeeBalance()
{
List <ChartData> objList = new List <ChartData>();
objList = SchoolDB.StudentFeeDetails.Where(x => x.Session.Contains(SchoolSession)).ToList()
.GroupBy(n => n.Class)
.Select(n => new ChartData
{
Label = n.Key.ToString(),
Data = n.Sum(x => Convert.ToDecimal(x.Balance)).ToString()
}
).ToList();
ClassController _class = new ClassController();
objList.ToList().ForEach(x => x.Label = _class.GetClassName(x.Label));
return(objList);
}
// GET api/school/5
public List <ChartData> GetTotalClassStudent()
{
List <ChartData> objList = new List <ChartData>();
objList = SchoolDB.AdmissionForms.Where(x => x.ESession.Contains(SchoolSession)).ToList()
.GroupBy(n => n.Class)
.Select(n => new ChartData
{
Label = n.Key.ToString(),
Data = n.Count().ToString()
}
).ToList();
ClassController _class = new ClassController();
objList.ToList().ForEach(x => x.Label = _class.GetClassName(x.Label));
return(objList);
}
//insert stFeeDetail
public HttpResponseMessage AddFeeHead(NewFeeHeading newFeeHeading)
{
HttpRequestMessage Request = new HttpRequestMessage();
Request.Properties.Add(HttpPropertyKeys.HttpConfigurationKey, new HttpConfiguration());
if (ModelState.IsValid)
{
ClassController _class = new ClassController();
newFeeHeading.Class = Convert.ToString(_class.GetClassID(newFeeHeading.Class));
SchoolDB.NewFeeHeadings.Add(newFeeHeading);
SchoolDB.SaveChanges();
newFeeHeading.Class = Convert.ToString(_class.GetClassName(newFeeHeading.Class));
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, newFeeHeading);
return(response);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
//insert stFeeDetail
public HttpResponseMessage Post(StudentFeeDetail stFeeDetail)
{
HttpRequestMessage Request = new HttpRequestMessage();
Request.Properties.Add(HttpPropertyKeys.HttpConfigurationKey, new HttpConfiguration());
if (ModelState.IsValid)
{
ClassController _class = new ClassController();
stFeeDetail.Class = Convert.ToString(_class.GetClassID(stFeeDetail.Class));
SchoolDB.StudentFeeDetails.Add(stFeeDetail);
SchoolDB.SaveChanges();
stFeeDetail.Class = Convert.ToString(_class.GetClassName(stFeeDetail.Class));
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, stFeeDetail);
return(response);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
// GET api/school/5
public List <ChartData> GetMonthBirthday()
{
List <ChartData> objList = new List <ChartData>();
try
{
objList = SchoolDB.AdmissionForms.Where(x => x.ESession.Contains(SchoolSession)).ToList()
.GroupBy(n => Convert.ToDateTime(n.DOB).ToString("MMMM", CultureInfo.InvariantCulture).ToString())
.Select(n => new ChartData
{
Label = n.Key,
Data = n.Count().ToString()
}
).ToList();
ClassController _class = new ClassController();
objList.ToList().ForEach(x => x.Label = _class.GetClassName(x.Label));
}
catch (Exception ex)
{
}
return(objList);
}
public HttpResponseMessage Post(List <StAttendance> Attendance)
{
HttpRequestMessage Request = new HttpRequestMessage();
Request.Properties.Add(HttpPropertyKeys.HttpConfigurationKey, new HttpConfiguration());
ClassController _class = new ClassController();
if (ModelState.IsValid)
{
foreach (var item in Attendance)
{
item.Session = SchoolSession;
SchoolDB.StAttendances.Add(item);
SchoolDB.SaveChanges();
}
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, Attendance);
return(response);
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
}
public List <StudentFeeDetail> GetTopFeeDetail(string Session, string Class = "1")
{
var stFeeDetailList = from r in SchoolDB.AdmissionForms
join sfd in SchoolDB.StudentFeeDetails on r.AdmissionNo equals sfd.AdmissionNo into edept
where r.Class == Class && r.ESession.Equals(Session)
from p in edept.DefaultIfEmpty()
select new
{
AdmissionNo = r.AdmissionNo == null ? "" : r.AdmissionNo,
AdmissionFee = p.AdmissionFee == null ? "" : p.AdmissionFee,
Balance = p.Balance == null ? "" : p.Balance,
BalancedShow = p.BalancedShow == null ? "" : p.BalancedShow,
BankName = p.BankName == null ? "" : p.BankName,
CardPaymentRecieptNo = p.CardPaymentRecieptNo == null ? "" : p.CardPaymentRecieptNo,
Category = r.Category == null ? "" : r.Category,
ChequeDate = p.ChequeDate == null ? "" : p.ChequeDate,
ChequeNo = p.ChequeNo == null ? "" : p.ChequeNo,
Class = r.Class == null ? "" : r.Class,
Concession = p.Concession == null ? "" : p.Concession,
Date = p.Date == null ? "" : p.Date,
Father = r.FatherName == null ? "" : r.FatherName,
Fine = p.Fine == null ? "" : p.Fine,
GrandTotal = p.GrandTotal == null ? 0 : p.GrandTotal,
Id = p.Id == null ? 0 : p.Id,
Months = p.Months == null ? "" : p.Months,
Name = r.StFirstName == null ? "" : r.StFirstName,
OldBalanced = p.OldBalanced == null ? "" : p.OldBalanced,
PaidAmount = p.PaidAmount == null ? 0 : p.PaidAmount,
PaymentMode = p.PaymentMode == null ? "" : p.PaymentMode,
Phone = r.Contact == null ? "" : r.Contact,
PreviousDue = p.PreviousDue == null ? "" : p.PreviousDue,
ReciptNo = p.ReciptNo == null ? "" : p.ReciptNo,
Remark = p.Remark == null ? "" : p.Remark,
Section = r.Section == null ? "" : r.Section,
Session = r.ESession == null ? "" : r.ESession,
Status = r.Status == null ? "" : r.Status,
TotalAmount = p.TotalAmount == null ? "" : p.TotalAmount,
TransportFee = p.TransportFee == null ? "" : p.TransportFee
};
var stFeeDetails = stFeeDetailList.Distinct().ToList();
List <StudentFeeDetail> StFeeDetails = stFeeDetails.Select(a => new StudentFeeDetail()
{
AdmissionFee = a.AdmissionFee,
AdmissionNo = a.AdmissionNo,
Balance = (Convert.ToInt32(string.IsNullOrEmpty(a.Balance) ? "0" : a.Balance) + GetBalanceAmount(a.AdmissionNo, a.Class, a.Months)).ToString(),
BalancedShow = a.BalancedShow,
BankName = a.BankName,
CardPaymentRecieptNo = a.CardPaymentRecieptNo,
Category = a.Category,
ChequeDate = a.ChequeDate,
ChequeNo = a.ChequeNo,
Class = a.Class,
Concession = a.Concession,
Date = a.Date,
Father = a.Father,
Fine = a.Fine,
GrandTotal = a.GrandTotal,
Id = a.Id,
Months = a.Months,
Name = a.Name,
OldBalanced = a.OldBalanced,
PaidAmount = a.PaidAmount,
PaymentMode = a.PaymentMode,
Phone = a.Phone,
PreviousDue = a.PreviousDue,
ReciptNo = a.ReciptNo,
Remark = a.Remark,
Section = a.Section,
Session = a.Section,
Status = a.Status,
TotalAmount = a.TotalAmount,
TransportFee = a.TransportFee
}).ToList();
ClassController _class = new ClassController();
StFeeDetails.ForEach(cc => cc.Class = _class.GetClassName(cc.Class));
var Sortlist = StFeeDetails.OrderBy(a => a.Id).GroupBy(a => a.AdmissionNo).Select(g => g.Last()).ToList();
return(Sortlist);
}