private CLO FindCLO(int id, string currentUsername) { CLO CLO = new CLO(); CLO = CLOService.FindById(id, currentUsername); return(CLO); }
public ActionResult EditCLO(int id) { if (id > 0) { CLO CLO = CLOService.FindById(id, User.Identity.Name); return(View(CLO)); } return(View()); }
// -------------- CLO ---------- public ActionResult DetailsCLO(int id) { if (id > 0) { CLO CLO = CLOService.FindById(id, User.Identity.Name); return(PartialView("Partial/CLODetails", CLO)); } return(View()); }
public string Delete(int Id, string CurrentUsername) { CLO CLO = FindById(Id, CurrentUsername); if (CLO != null) { return(CLORepository.Delete(Id) ? null : Messages.IssueInDatabase); } else { return(Messages.NotFound); } }
public JsonResult FindByCLO(int id) { List <AcademicEvaluation> AcademicEvaluations = new List <AcademicEvaluation>(); List <AcademicEvaluation> AcademicEvaluationLists = AcademicEvaluationService.FindAll(User.Identity.Name); CLO CLO = CLOService.FindById(id, User.Identity.Name); AcademicEvaluationLists = AcademicEvaluationLists.FindAll(ae => ae.Course.Id == CLO.Course.Id); foreach (var item in AcademicEvaluationLists) { if (item.Marks > 0) { AcademicEvaluations.Add(item); } } return(Json(AcademicEvaluations)); }
public string Update(CLO CLO, string CurrentUsername) { if (FindById(CLO.Id, CurrentUsername) != null) { if (CourseService.FindById(CLO.Course.Id, CurrentUsername) != null) { return(CLORepository.Update(CLO) ? null : Messages.IssueInDatabase); } else { return(Messages.CourseNotFound); } } else { return(Messages.NotFound); } }
public ActionResult CreateCLO(CLO CLO) { if (ModelState.IsValid) { string message = CLOService.Save(CLO, User.Identity.Name); if (string.IsNullOrEmpty(message)) { TempData["Success"] = Messages.Created; return(RedirectToAction("Index")); } else { ViewData["Warning"] = message; } } else { ViewData["Error"] = Messages.InvalidField; } return(View()); }
public IActionResult CreateCLO([FromBody] CLO clo) { var isCourse = cloasisdbRef.Query("SELECT * FROM dbo.COURSE WHERE COURSE_ID = @COURSE_ID", clo); if (isCourse.Count() == 0) { return(BadRequest("Please pass a valid Course ID")); } if (clo.REPORT_ID != null) { var isReport = cloasisdbRef.Query("SELECT * FROM dbo.REPORT WHERE REPORT_ID = @REPORT_ID", clo); if (isReport.Count() == 0) { return(BadRequest("Please pass a valid Report")); } var reportUsed = cloasisdbRef.Query("SELECT * FROM dbo.CLO WHERE REPORT_ID = @REPORT_ID", clo); if (reportUsed.Count() > 0) { return(BadRequest("This Report is already used in another CLO please pass a novel Report_ID")); } } cloasisdbRef.Execute(@"INSERT INTO dbo.CLO (COURSE_ID, REPORT_ID, DESCRIPTION) VALUES (@COURSE_ID, @REPORT_ID, @DESCRIPTION)", clo); if (clo.REPORT_ID != null) { var data = cloasisdbRef.Query("SELECT * FROM dbo.CLO WHERE COURSE_ID = @COURSE_ID AND REPORT_ID = @REPORT_ID AND DESCRIPTION = @DESCRIPTION", clo); return(Ok(data)); } var data2 = cloasisdbRef.Query("SELECT * FROM dbo.CLO WHERE COURSE_ID = @COURSE_ID AND DESCRIPTION = @DESCRIPTION", clo); return(Ok(data2)); }
public IActionResult EditCLO([FromBody] CLO clo, int CLO_ID) { var p = new DynamicParameters(); p.Add(@"cloId", CLO_ID); var IsCLO = cloasisdbRef.Query("SELECT * FROM dbo.CLO WHERE CLO_ID = @cloId", p); if (IsCLO.Count() == 0) { return(BadRequest("Please pass an existant CLO ID")); } var isCourse = cloasisdbRef.Query("SELECT * FROM dbo.COURSE WHERE COURSE_ID = @COURSE_ID", clo); if (isCourse.Count() == 0) { return(BadRequest("Please pass a valid Course ID")); } if (clo.REPORT_ID != null) { var isReport = cloasisdbRef.Query("SELECT * FROM dbo.REPORT WHERE REPORT_ID = @REPORT_ID", clo); if (isReport.Count() == 0) { return(BadRequest("Please pass a valid Report")); } } cloasisdbRef.Execute(@"UPDATE dbo.CLO SET COURSE_ID = @COURSE_ID, REPORT_ID = @REPORT_ID, DESCRIPTION = @DESCRIPTION WHERE CLO_ID = @cloId", p); var data = cloasisdbRef.Query("SELECT * FROM dbo.CLO WHERE CLO_ID = @cloId", p); return(Ok(data)); }
public CLO FindById(int id, string CurrentUsername) { CLO FoundedCLO = FindAll(CurrentUsername).Find(CLO => CLO.Id == id); return(FoundedCLO); }
public DataTable GetCustomLedger(DtoCustomLedger CLdr) { DataTable DT = new DataTable(); DT = (from Main in ((from MainLDR in ((from AVOO in ((from AVO in ((from AV in _db.AccVouchers where (( from AAV in _db.AccVouchers where AAV.AccString == CLdr.AccString select new { AAV.VNo } ).Distinct()).Contains(new { VNo = AV.VNo }) select new { AV.VDate, AV.VNo, AV.AccString, AV.Debit, AV.Credit, AV.HeadCode, AV.SubHeadCode, AV.AccCode } )) where ( (AVO.HeadCode == 41 || AVO.HeadCode == 44 || AVO.HeadCode == 43 || AVO.HeadCode == 14) //|| //AVO.HeadCode == 13 ) select new { AVO.VDate, AVO.AccString, AVO.Debit, AVO.Credit, AVO.HeadCode, AVO.SubHeadCode, AVO.AccCode }) //AVO ) join AA in _db.AccAccounts on AVOO.AccString equals AA.AccString join AH in _db.AccHead on AVOO.HeadCode equals AH.HeadCode join AT in _db.AccTypes on AH.TypeCode equals AT.TypeCode group new { AA, AVOO, AT } by new { AVOO.VDate, AVOO.AccString, AA.AccName, AT.TypeCode } into g where (g.Key.VDate >= CLdr.StartDate && g.Key.VDate <= CLdr.EndDate) select new { VDate = (DateTime?)g.Key.VDate, g.Key.AccString, g.Key.AccName, SDebit = (decimal?)g.Sum(p => p.AVOO.Debit), SCredit = (decimal?)g.Sum(p => p.AVOO.Credit), SBalance = g.Key.TypeCode == 1 || g.Key.TypeCode == 5 ? (g.Sum(p => ((Decimal?)p.AVOO.Debit ?? (Decimal?)0)) - g.Sum(p => ((Decimal?)p.AVOO.Credit ?? (Decimal?)0))) : (g.Sum(p => ((Decimal?)p.AVOO.Credit ?? (Decimal?)0)) - g.Sum(p => ((Decimal?)p.AVOO.Debit ?? (Decimal?)0))) } )) select new { MainLDR.VDate, MainLDR.AccString, MainLDR.AccName, MainLDR.SDebit, MainLDR.SCredit, MainLDR.SBalance } )) join Opening in (from O in ( (from AV in _db.AccVouchers where AV.AccString == CLdr.AccString group AV by new { AV.VDate } into g select new { VVDate = g.Key.VDate, Balance = (decimal?)(g.Sum(p => p.Debit) - g.Sum(p => p.Credit)) })) select new { O.VVDate, O.Balance, OBalance = (decimal?) (from OC in ( (from AV in _db.AccVouchers where AV.AccString == CLdr.AccString group AV by new { AV.VDate } into g select new { VVDate = g.Key.VDate, Balance = (decimal?)(g.Sum(p => p.Debit) - g.Sum(p => p.Credit)) })) where OC.VVDate <= (DateTime)O.VVDate select new { OC.Balance }).Sum(p => p.Balance) - O.Balance }) on Main.VDate equals Opening.VVDate into Opn from Op in Opn.DefaultIfEmpty() join Closing in (from C in ( (from AV in _db.AccVouchers where AV.AccString == CLdr.AccString group AV by new { AV.VDate } into g select new { VVDate = g.Key.VDate, Balance = (decimal?)(g.Sum(p => p.Debit) - g.Sum(p => p.Credit)) })) select new { C.VVDate, C.Balance, CBalance = (decimal?) (from CC in ( (from AV in _db.AccVouchers where AV.AccString == CLdr.AccString group AV by new { AV.VDate } into g select new { VVDate = g.Key.VDate, Balance = (decimal?)(g.Sum(p => p.Debit) - g.Sum(p => p.Credit)) })) where CC.VVDate <= (DateTime)C.VVDate select new { CC.Balance }).Sum(p => p.Balance) }) on Main.VDate equals Closing.VVDate into CLO from CL in CLO.DefaultIfEmpty() select new { Main.VDate, Main.AccString, Main.AccName, Main.SDebit, Main.SCredit, Main.SBalance, Op.OBalance, CL.CBalance }).ToList().ToDataTable(); return(DT); }