//public static List<GradeModel> Grades = new List<GradeModel>();
public IActionResult Index()
{
var model = GradeManager.GetAll().Select(g => g.ToModelG())
.ToList();
return(View(model));
}
public JsonResult EmployeeGradeById(Int64 id)
{
var empInfo = employeeManager.GetAll();
var gradeInfo = gradeManager.GetAll();
return(Json(new
{
Data = (from e in empInfo where e.Id.Equals(id)
join g in gradeInfo on e.GradeId equals g.Id
select new GradeVM
{
Id = e.Id,
GradeId = g.Id,
GradeName = g.Grades
}),
status = true
}, JsonRequestBehavior.AllowGet));
}
public ActionResult Save()
{
ViewBag.Students = studentManager.GetStudentRegNoId();
ViewBag.Grades = gradeManager.GetAll();
return(View());
}
public JsonResult GetDetails(Int64 id)
{
var res = advanceManager.GetAll();
var exist = advanceManager.GetById(id);
var emp = employeeManager.GetAll();
var dis = districtManager.GetAll();
var sub = subDistrictManager.GetAll();
var advd = advanceDetailsManager.GetAll();
var pur = purposeManager.GetAll();
var grd = gradeManager.GetAll();
if (exist.AdvanceType == "Travelling")
{
var query = (from a in res
where a.Id.Equals(id)
join e in emp on a.EmployeeId equals e.Id
join g in grd on e.GradeId equals g.Id
join d in dis on a.DistrictId equals d.Id
join s in sub on a.SubDistrictId equals s.Id
select new AdvanceVM
{
Id = a.Id,
MemoNo = a.MemoNo,
AdvanceType = a.AdvanceType,
AdvanceStatus = a.AdvanceStatus,
EmployeeId = a.EmployeeId,
EmployeeName = e.Name,
EmployeeCode = e.Code,
GradeId = g.Id,
EmployeeGrade = g.Grades,
FromDate = a.FromDate,
ToDate = a.ToDate,
DistrictId = a.DistrictId,
SubDistrictId = a.SubDistrictId,
Location = a.Location,
Description = a.Description
}).ToList();
return(Json(new { Data = query, status = res == null ? false : true }, JsonRequestBehavior.AllowGet));
}
else
{
var query = (from a in res
where a.Id.Equals(id)
join e in emp on a.EmployeeId equals e.Id
join g in grd on e.GradeId equals g.Id
select new AdvanceVM
{
Id = a.Id,
MemoNo = a.MemoNo,
AdvanceType = a.AdvanceType,
AdvanceStatus = a.AdvanceStatus,
EmployeeId = a.EmployeeId,
EmployeeName = e.Name,
EmployeeCode = e.Code,
EmployeeGrade = g.Grades,
FromDate = a.FromDate,
ToDate = a.ToDate,
Location = a.Location,
Description = a.Description,
Trainer = a.Trainer,
Topic = a.Topic
}).ToList();
return(Json(new { Data = query, status = res == null ? false : true }, JsonRequestBehavior.AllowGet));
}
}
private void PopulateGradeComboBox()
{
gradeComboBox.DataSource = aGradeManager.GetAll();
}
private void PopulateComboBoxes()
{
selectDeptComboBox.DataSource = aDepartmentManager.GetAll();
selectGradeLevelComboBox.DataSource = aGradeManager.GetAll();
}
public JsonResult GetDetails(Int64 id)
{
var res = advanceManager.GetAll();
var employeeExist = advanceManager.GetAll().Where(x => x.EmployeeId == id).FirstOrDefault();
var exist = advanceManager.GetById(employeeExist.Id);
var emp = employeeManager.GetAll();
var dis = districtManager.GetAll();
var sub = subDistrictManager.GetAll();
var advd = advanceDetailsManager.GetAll();
var pur = purposeManager.GetAll();
var grd = gradeManager.GetAll();
var bill = billManager.GetAll();
var adjustInfo = adjustManager.GetAll();
if (exist.AdvanceType == "Travelling")
{
var query = (from e in emp
where e.Id.Equals(id)
join a in res on e.Id equals a.EmployeeId
where a.AdvanceStatus.Equals("Confirmed")
join b in bill on a.Id equals b.AdvanceId
where b.BillStatus.Equals("Confirmed")
join adj in adjustInfo on b.Id equals adj.BillingId
join g in grd on e.GradeId equals g.Id
join d in dis on a.DistrictId equals d.Id
join s in sub on a.SubDistrictId equals s.Id
select new AdvanceVM
{
Id = a.Id,
MemoNo = a.MemoNo,
AdvanceType = a.AdvanceType,
AdvanceStatus = a.AdvanceStatus,
EmployeeId = a.EmployeeId,
EmployeeName = e.Name,
EmployeeCode = e.Code,
GradeId = g.Id,
EmployeeGrade = g.Grades,
FromDate = a.FromDate,
ToDate = a.ToDate,
DistrictId = a.DistrictId,
DistrictName = d.Name,
SubDistrictName = s.Name,
SubDistrictId = a.SubDistrictId,
Location = a.Location,
Description = a.Description,
GrandTotal = a.GrandTotal,
BillId = b.Id,
BillMemo = b.MemoNo,
BillDate = b.BillDate,
BillDescription = b.Description,
BillVendor = b.Vendor,
BillGrandTotal = adj.BillTotal
}).ToList();
return(Json(new { Data = query, status = res == null ? false : true }, JsonRequestBehavior.AllowGet));
}
else
{
var query = (from e in emp
where e.Id.Equals(id)
join a in res on e.Id equals a.EmployeeId
where a.AdvanceStatus.Equals("Confirmed")
join g in grd on e.GradeId equals g.Id
join b in bill on a.Id equals b.AdvanceId
where b.BillStatus.Equals("Confirmed")
join adj in adjustInfo on b.Id equals adj.BillingId
select new AdvanceVM
{
Id = a.Id,
MemoNo = a.MemoNo,
AdvanceType = a.AdvanceType,
AdvanceStatus = a.AdvanceStatus,
EmployeeId = a.EmployeeId,
EmployeeName = e.Name,
EmployeeCode = e.Code,
EmployeeGrade = g.Grades,
FromDate = a.FromDate,
ToDate = a.ToDate,
Location = a.Location,
Description = a.Description,
Trainer = a.Trainer,
Topic = a.Topic,
GrandTotal = a.GrandTotal,
BillId = b.Id,
BillMemo = b.MemoNo,
BillDate = b.BillDate,
BillDescription = b.Description,
BillVendor = b.Vendor,
BillGrandTotal = adj.BillTotal
}).ToList();
return(Json(new { Data = query, status = res == null ? false : true }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetAdvanceDetails(string memoCode)
{
var res = advanceManager.GetAll();
var exist = (Advance)null;
var memoExist = advanceManager.GetAll().Where(x => x.MemoNo == memoCode).FirstOrDefault();
if (memoExist != null)
{
exist = advanceManager.GetById(memoExist.Id);
}
var emp = employeeManager.GetAll();
var dis = districtManager.GetAll();
var sub = subDistrictManager.GetAll();
var advd = advanceDetailsManager.GetAll();
var pur = purposeManager.GetAll();
var grd = gradeManager.GetAll();
List <AdvanceVM> query = null;
if (exist != null)
{
if (exist.AdvanceType == "Travelling")
{
query = (from a in res
where a.MemoNo.Equals(memoCode)
where a.AdvanceStatus.Equals("Confirmed")
join e in emp on a.EmployeeId equals e.Id
join g in grd on e.GradeId equals g.Id
join d in dis on a.DistrictId equals d.Id
join s in sub on a.SubDistrictId equals s.Id
select new AdvanceVM
{
Id = a.Id,
MemoNo = a.MemoNo,
AdvanceType = a.AdvanceType,
AdvanceStatus = a.AdvanceStatus,
EmployeeId = a.EmployeeId,
EmployeeName = e.Name,
EmployeeCode = e.Code,
EmployeeGrade = g.Grades,
FromDate = a.FromDate,
ToDate = a.ToDate,
DistrictId = a.DistrictId,
DistrictName = d.Name,
SubDistrictId = a.SubDistrictId,
SubDistrictName = s.Name,
Location = a.Location,
Description = a.Description
}).ToList();
return(Json(new { Data = query, status = query == null ? false : true }, JsonRequestBehavior.AllowGet));
}
else
{
query = (from a in res
where a.MemoNo.Equals(memoCode)
where a.AdvanceStatus.Equals("Confirmed")
join e in emp on a.EmployeeId equals e.Id
join g in grd on e.GradeId equals g.Id
select new AdvanceVM
{
Id = a.Id,
MemoNo = a.MemoNo,
AdvanceType = a.AdvanceType,
AdvanceStatus = a.AdvanceStatus,
EmployeeId = a.EmployeeId,
EmployeeName = e.Name,
EmployeeCode = e.Code,
EmployeeGrade = g.Grades,
FromDate = a.FromDate,
ToDate = a.ToDate,
Location = a.Location,
Description = a.Description,
Trainer = a.Trainer,
Topic = a.Topic
}).ToList();
return(Json(new { Data = query, status = query == null ? false : true }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { Data = query, status = query == null ? false : true }, JsonRequestBehavior.AllowGet));
}
}
