public IHttpActionResult GetFinencialCostByStudent([FromUri] string id)
{
var list = context.Tbl_SemesterCost.Where(p => p.StudentID == id);
if (list.FirstOrDefault() == null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
else
{
List <Tbl_SemesterCost> comments = new List <Tbl_SemesterCost>();
foreach (var item in list)
{
Tbl_SemesterCost pro = new Tbl_SemesterCost();
pro.SemesterCostID = item.SemesterCostID;
pro.SemesterIID = item.SemesterIID;
pro.StudentID = id;
pro.Activity = item.Activity;
pro.AdmissionFee = item.AdmissionFee;
pro.ComputerLab = item.ComputerLab;
pro.CreditTaken = item.CreditTaken;
pro.Development = item.Development;
pro.LanguageLab = item.LanguageLab;
pro.Studio = item.Studio;
pro.Miscellaneous = item.Miscellaneous;
pro.ScienceLab = item.ScienceLab;
pro.PreviousDue = item.PreviousDue;
pro.AmountPaid = item.AmountPaid;
pro.Total = item.Total;
pro.links.Add(new Links()
{
HRef = "http://localhost:57254/api/Students/" + id + "/FinencialCosts", Method = "GET", Rel = "Self"
});
pro.links.Add(new Links()
{
HRef = "http://localhost:57254/api/Students/" + id + "/FinencialCosts/" + pro.SemesterCostID, Method = "GET", Rel = "Specific Resource"
});
comments.Add(pro);
}
return(Ok(comments));
}
}
public IHttpActionResult PostRegistration([FromUri] string id, [FromBody] Tbl_SectionDistribution sec)
{
var kl = context.Tbl_SectionDistribution.Where(x => x.SectionID == sec.SectionID).FirstOrDefault();
var sectiondouble = context.Tbl_Registration.Where(x => x.StudentID == id && x.SectionID == sec.SectionID).FirstOrDefault();
var cradit = context.Tbl_Registration.Where(x => x.StudentID == id && x.SemesterID == kl.SemesterID).Sum(x => x.Credit);
var take = context.Tbl_SectionDistribution.Where(x => x.SectionID == sec.SectionID).FirstOrDefault();
var l = context.Tbl_SubjectDetails.Where(x => x.SubjectID == take.SubjectID).FirstOrDefault();
// var sid = _unitOfWork.GetRepositoryInstance<Tbl_SectionDistribution>().GetAllRecordsIQueryable().Where(x => x.SectionID == id).FirstOrDefault();
var subj = context.Tbl_SubjectDetails.Where(x => x.SubjectID == take.SubjectID).FirstOrDefault();
var m = context.Tbl_Student.Where(x => x.StudentID == id).FirstOrDefault();
var kal = context.Tbl_Registration.Where(p => p.StudentID == id && p.SubjectName == take.Tbl_SubjectDetails.SubjectName).FirstOrDefault();
var cost = context.Tbl_SemesterCost.Where(p => p.StudentID == id && p.SemesterIID == take.SemesterID).FirstOrDefault();
var semestercount = context.Tbl_SemesterCost.Where(p => p.StudentID == id).Count();
if (sectiondouble != null && cradit.Value > 16 && kal != null)
{
return(StatusCode(HttpStatusCode.NotFound));
}
else
{
Tbl_Registration tbl = new Tbl_Registration();
tbl.StudentID = id;
tbl.SectionID = take.SectionID;
tbl.SemesterID = take.SemesterID;
tbl.Available = take.Available;
tbl.Capacity = take.Capacity;
tbl.ClassStart = take.ClassStart;
tbl.ClassEnd = take.ClassEnd;
tbl.Day1 = take.Day1;
tbl.Day2 = take.Day2;
tbl.IsValid = false;
tbl.SubjectName = l.SubjectName;
tbl.Credit = take.Credit;
tbl.ClassStart2 = take.ClassStart2;
tbl.ClassEnd2 = take.ClassEnd2;
tbl.SectionName = take.SectionName;
tbl.TeacherID = take.TeacherID;
Tbl_MidResult mid = new Tbl_MidResult();
mid.TeacherID = take.TeacherID;
// mid.TeacherName = take.Tbl_Teacher1.FirstName + " " + take.Tbl_Teacher1.LastName;
mid.StudentID = id;
//mid.StudentName = m.FirstName + " " + m.LastName;
mid.SectionID = take.SectionID;
mid.SubjectID = take.SubjectID;
mid.SemesterID = take.SemesterID;
Tbl_SemesterCost scost = new Tbl_SemesterCost();
decimal lab = 0;
if (cost != null)
{
if (semestercount % 3 == 0)
{
var kk = context.Tbl_Expense.Where(x => x.ExpenseName == "DevelopmentFee").FirstOrDefault();
var ll = context.Tbl_Expense.Where(x => x.ExpenseName == "Activity").FirstOrDefault();
scost.Development = kk.Cost;
scost.Activity = ll.Cost;
}
else
{
scost.Development = 0;
scost.Activity = 0;
}
if (subj.IsLabExist == "yes")
{
var kla = context.Tbl_Expense.Where(x => x.ExpenseName == "ComputerLab").FirstOrDefault();
lab = (decimal)cost.ComputerLab;
scost.ComputerLab = lab + kla.Cost;
}
else
{
scost.ComputerLab = 0;
}
var jl = context.Tbl_Expense.Where(x => x.ExpenseName == "Credit").FirstOrDefault();
var jj = context.Tbl_Expense.Where(x => x.ExpenseName == "Miscellaneous").FirstOrDefault();
int credit = (int)cost.CreditTaken;
scost.CreditTaken = credit + take.Credit;
scost.StudentID = id;
scost.SemesterIID = take.SemesterID;
scost.LanguageLab = 0;
scost.Miscellaneous = jj.Cost;
scost.PreviousDue = 0;
scost.ScienceLab = 0;
scost.AdmissionFee = cost.AdmissionFee;
scost.Studio = 0;
scost.AmountPaid = 0;
decimal prev = (decimal)cost.Total;
scost.Total = prev + (scost.CreditTaken - credit) * jl.Cost + scost.Development + scost.Activity + lab;
scost.Due = scost.Total - scost.AmountPaid;
var seme = context.Tbl_SemesterCost.Where(x => x.StudentID == id && x.SemesterIID == take.SemesterID).FirstOrDefault();
context.Tbl_SemesterCost.Remove(seme);
context.Tbl_SemesterCost.Add(scost);
context.SaveChanges();
}
else
{
var jj = context.Tbl_Expense.Where(x => x.ExpenseName == "Miscellaneous").FirstOrDefault();
var uj = context.Tbl_Expense.Where(x => x.ExpenseName == "Admission").FirstOrDefault();
var kk = context.Tbl_Expense.Where(x => x.ExpenseID == 7).FirstOrDefault();
var ll = context.Tbl_Expense.Where(x => x.ExpenseName == "Activity").FirstOrDefault();
scost.SemesterIID = take.SemesterID;
scost.StudentID = id;
scost.LanguageLab = 0;
scost.Miscellaneous = jj.Cost;
scost.PreviousDue = 0;
scost.ScienceLab = 0;
scost.Studio = 0;
scost.AmountPaid = 0;
scost.AdmissionFee = uj.Cost;
scost.CreditTaken = take.Credit;
if (semestercount % 3 == 0)
{
scost.Development = kk.Cost;
scost.Activity = ll.Cost;
}
else
{
scost.Development = 0;
scost.Activity = 0;
}
if (subj.IsLabExist == "yes")
{
var kla = context.Tbl_Expense.Where(x => x.ExpenseName == "ComputerLab").FirstOrDefault();
lab = (decimal)cost.ComputerLab;
scost.ComputerLab = kla.Cost;
}
else
{
scost.ComputerLab = 0;
}
var jl = context.Tbl_Expense.Where(x => x.ExpenseName == "Credit").FirstOrDefault();
scost.Total = (scost.CreditTaken) * jl.Cost + scost.Development + scost.Activity + lab;
context.Tbl_SemesterCost.Add(scost);
context.SaveChanges();
}
context.Tbl_Registration.Add(tbl);
context.Tbl_MidResult.Add(mid);
context.SaveChanges();
return(Created(Url.Link("GetRegistrationByStudentID", new { id = tbl.StudentID, id1 = tbl.RegID }), tbl));
}
}
public ActionResult RegistrationConfirm(Tbl_Registration tbl, int id, int did, Tbl_SectionDistribution tbl1, Tbl_AttandanceMid atm, Tbl_AttandanceFinal atm1, Tbl_MidResult mid, Tbl_SemesterCost scost)
{
string a = Session["UserID"].ToString();
var sectiondouble = _unitOfWork.GetRepositoryInstance <Tbl_Registration>().GetAllRecordsIQueryable().Where(x => x.StudentID == a && x.SectionID == id).FirstOrDefault();
var cradit = _unitOfWork.GetRepositoryInstance <Tbl_Registration>().GetListParameter(x => x.StudentID == a && x.SemesterID == did).Sum(x => x.Credit);
var take = _unitOfWork.GetRepositoryInstance <Tbl_SectionDistribution>().GetAllRecordsIQueryable().Where(x => x.SectionID == id).FirstOrDefault();
var l = _unitOfWork.GetRepositoryInstance <Tbl_SubjectDetails>().GetAllRecordsIQueryable().Where(x => x.SubjectID == take.SubjectID).FirstOrDefault();
// var sid = _unitOfWork.GetRepositoryInstance<Tbl_SectionDistribution>().GetAllRecordsIQueryable().Where(x => x.SectionID == id).FirstOrDefault();
var subj = _unitOfWork.GetRepositoryInstance <Tbl_SubjectDetails>().GetAllRecordsIQueryable().Where(x => x.SubjectID == take.SubjectID).FirstOrDefault();
var m = _unitOfWork.GetRepositoryInstance <Tbl_Student>().GetAllRecordsIQueryable().Where(x => x.StudentID == a).FirstOrDefault();
var kal = _unitOfWork.GetRepositoryInstance <Tbl_Registration>().GetAllRecordsIQueryable().Where(p => p.StudentID == a && p.SubjectName == take.Tbl_SubjectDetails.SubjectName).FirstOrDefault();
var cost = _unitOfWork.GetRepositoryInstance <Tbl_SemesterCost>().GetAllRecordsIQueryable().Where(p => p.StudentID == a && p.SemesterIID == take.SemesterID).FirstOrDefault();
var semestercount = _unitOfWork.GetRepositoryInstance <Tbl_SemesterCost>().GetAllRecordsIQueryable().Where(p => p.StudentID == a).Count();
if (sectiondouble != null && cradit.Value > 16 && kal != null)
{
Response.Write("<script>alert('Sorry! u have already taken this subject')</script>");
}
else
{
tbl.StudentID = a;
tbl.SectionID = id;
tbl.SemesterID = did;
tbl.Available = take.Available;
tbl.Capacity = take.Capacity;
tbl.ClassStart = take.ClassStart;
tbl.ClassEnd = take.ClassEnd;
tbl.Day1 = take.Day1;
tbl.Day2 = take.Day2;
tbl.IsValid = false;
tbl.SubjectName = l.SubjectName;
tbl.Credit = take.Credit;
tbl.ClassStart2 = take.ClassStart2;
tbl.ClassEnd2 = take.ClassEnd2;
tbl.SectionName = take.SectionName;
tbl.TeacherID = take.TeacherID;
atm.TeacherID = take.TeacherID;
atm.SectionID = take.SectionID;
atm.SectionName = take.SectionName;
atm.SubjectID = take.SubjectID;
atm.TeacherName = take.Tbl_Teacher1.FirstName + " " + take.Tbl_Teacher1.LastName;
atm.StudentID = a;
atm.StudentName = m.FirstName + " " + m.LastName;
atm1.TeacherID = take.TeacherID;
atm1.SectionID = take.SectionID;
atm1.SectionName = take.SectionName;
atm1.SubjectID = take.SubjectID;
atm1.TeacherName = take.Tbl_Teacher1.FirstName + " " + take.Tbl_Teacher1.LastName;
atm1.StudentID = a;
atm1.StudentName = m.FirstName + " " + m.LastName;
mid.TeacherID = take.TeacherID;
// mid.TeacherName = take.Tbl_Teacher1.FirstName + " " + take.Tbl_Teacher1.LastName;
mid.StudentID = a;
//mid.StudentName = m.FirstName + " " + m.LastName;
mid.SectionID = take.SectionID;
mid.SubjectID = take.SubjectID;
mid.SemesterID = take.SemesterID;
decimal lab = 0;
if (cost != null)
{
if (semestercount % 3 == 0)
{
var kk = _unitOfWork.GetRepositoryInstance <Tbl_Expense>().GetAllRecordsIQueryable().Where(x => x.ExpenseName == "DevelopmentFee").FirstOrDefault();
var ll = _unitOfWork.GetRepositoryInstance <Tbl_Expense>().GetAllRecordsIQueryable().Where(x => x.ExpenseName == "Activity").FirstOrDefault();
scost.Development = kk.Cost;
scost.Activity = ll.Cost;
}
else
{
scost.Development = 0;
scost.Activity = 0;
}
if (subj.IsLabExist == "yes")
{
var kl = _unitOfWork.GetRepositoryInstance <Tbl_Expense>().GetAllRecordsIQueryable().Where(x => x.ExpenseName == "ComputerLab").FirstOrDefault();
lab = (decimal)cost.ComputerLab;
scost.ComputerLab = lab + kl.Cost;
}
else
{
scost.ComputerLab = 0;
}
var jl = _unitOfWork.GetRepositoryInstance <Tbl_Expense>().GetAllRecordsIQueryable().Where(x => x.ExpenseName == "Credit").FirstOrDefault();
var jj = _unitOfWork.GetRepositoryInstance <Tbl_Expense>().GetAllRecordsIQueryable().Where(x => x.ExpenseName == "Miscellaneous").FirstOrDefault();
int credit = (int)cost.CreditTaken;
scost.CreditTaken = credit + take.Credit;
scost.StudentID = a;
scost.SemesterIID = take.SemesterID;
scost.LanguageLab = 0;
scost.Miscellaneous = jj.Cost;
scost.PreviousDue = 0;
scost.ScienceLab = 0;
scost.AdmissionFee = cost.AdmissionFee;
scost.Studio = 0;
scost.AmountPaid = 0;
decimal prev = (decimal)cost.Total;
scost.Total = prev + (scost.CreditTaken - credit) * jl.Cost + scost.Development + scost.Activity + lab;
scost.Due = scost.Total - scost.AmountPaid;
_unitOfWork.GetRepositoryInstance <Tbl_SemesterCost>().RemovebyWhereClause(x => x.StudentID == a && x.SemesterIID == take.SemesterID);
_unitOfWork.GetRepositoryInstance <Tbl_SemesterCost>().Add(scost);
}
else
{
var jj = _unitOfWork.GetRepositoryInstance <Tbl_Expense>().GetAllRecordsIQueryable().Where(x => x.ExpenseName == "Miscellaneous").FirstOrDefault();
var uj = _unitOfWork.GetRepositoryInstance <Tbl_Expense>().GetAllRecordsIQueryable().Where(x => x.ExpenseName == "Admission").FirstOrDefault();
var kk = _unitOfWork.GetRepositoryInstance <Tbl_Expense>().GetAllRecordsIQueryable().Where(x => x.ExpenseID == 7).FirstOrDefault();
var ll = _unitOfWork.GetRepositoryInstance <Tbl_Expense>().GetAllRecordsIQueryable().Where(x => x.ExpenseName == "Activity").FirstOrDefault();
scost.SemesterIID = take.SemesterID;
scost.StudentID = a;
scost.LanguageLab = 0;
scost.Miscellaneous = jj.Cost;
scost.PreviousDue = 0;
scost.ScienceLab = 0;
scost.Studio = 0;
scost.AmountPaid = 0;
scost.AdmissionFee = uj.Cost;
scost.CreditTaken = take.Credit;
if (semestercount % 3 == 0)
{
scost.Development = kk.Cost;
scost.Activity = ll.Cost;
}
else
{
scost.Development = 0;
scost.Activity = 0;
}
if (subj.IsLabExist == "yes")
{
var kl = _unitOfWork.GetRepositoryInstance <Tbl_Expense>().GetAllRecordsIQueryable().Where(x => x.ExpenseName == "ComputerLab").FirstOrDefault();
lab = (decimal)cost.ComputerLab;
scost.ComputerLab = kl.Cost;
}
else
{
scost.ComputerLab = 0;
}
var jl = _unitOfWork.GetRepositoryInstance <Tbl_Expense>().GetAllRecordsIQueryable().Where(x => x.ExpenseName == "Credit").FirstOrDefault();
scost.Total = (scost.CreditTaken) * jl.Cost + scost.Development + scost.Activity + lab;
_unitOfWork.GetRepositoryInstance <Tbl_SemesterCost>().Add(scost);
}
_unitOfWork.GetRepositoryInstance <Tbl_Registration>().Add(tbl);
_unitOfWork.GetRepositoryInstance <Tbl_AttandanceMid>().Add(atm);
_unitOfWork.GetRepositoryInstance <Tbl_AttandanceFinal>().Add(atm1);
_unitOfWork.GetRepositoryInstance <Tbl_MidResult>().Add(mid);
}
return(RedirectToAction("Registration", "Student"));
}
