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);
}
