public JsonResult Save(Tbl_AttandanceMid record)
{
Tbl_AttandanceMid entity;
using (DIUBDatabaseEntities8 context = new DIUBDatabaseEntities8())
{
if (record.AttandanceID > 0)
{
entity = context.Tbl_AttandanceMid.First(p => p.AttandanceID == record.AttandanceID);
entity.StudentID = record.StudentID;
entity.StudentName = record.StudentName;
entity.Day1 = record.Day1;
entity.Day2 = record.Day2;
entity.Day3 = record.Day3;
entity.Day4 = record.Day4;
entity.Day5 = record.Day5;
entity.Day6 = record.Day6;
entity.Day7 = record.Day7;
entity.Day8 = record.Day8;
entity.Day9 = record.Day9;
entity.Day10 = record.Day10;
entity.Day11 = record.Day11;
entity.Day12 = record.Day12;
entity.TotalAttandanceMid = record.TotalAttandanceMid;
}
context.SaveChanges();
}
return(Json(new { result = true }));
}
public ActionResult Attandance(Tbl_AttandanceMid tbl)
{
return(View());
}
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"));
}
