public ActionResult saveGoalTitle(string goalTitle, string goalDesc)
{
tblGoalTitle gt = new tblGoalTitle();
gt.varTitleName = goalTitle;
gt.varTitleDesc = goalDesc;
gt.dtCreatedOn = DateTime.Now;
db.tblGoalTitles.Add(gt);
db.SaveChanges();
return View();
}
public ActionResult AddGoals()
{
//================================== Employee Goal Title Binding =======================================//
List<tblGoalTitle> tgt = (from data in db.tblGoalTitles
orderby data.varTitleName ascending
select data).ToList();
tblGoalTitle gt = new tblGoalTitle();
gt.intTilteID = 0;
gt.varTitleName = "-- Select --";
tgt.Insert(0, gt);
SelectList objGoalList = new SelectList (tgt, "intTilteID", "varTitleName", 0);
objEmpViewModel.GoalTitleModel = objGoalList;
//=================================== End Employee Goal title binding =================================//
//=================================== Status Binding ==================================================//
List<tblStatus> tc = (from data in db.tblStatus
orderby data.varStatus ascending
select data).ToList();
tblStatus tc1 = new tblStatus();
tc1.intStatusID = 0;
tc1.varStatus = "-- Select --";
tc.Insert(0, tc1);
SelectList objStatusList = new SelectList(tc, "intStatusID", "varStatus", 0);
objEmpViewModel.StatusModel = objStatusList;
//=================================== End Status Binding ==============================================//
return View(objEmpViewModel);
}
public ActionResult ReviewGoals()
{
int empID = 0;
int titleID = 0;
if (Request.Form.Count > 0)
{
empID = Convert.ToInt32(Request.Form["objEmpGoals.intEmployeeID"]);
titleID = Convert.ToInt32(Request.Form["objEmpGoals.intTitle"]);
}
//=================================== Employee Binding ==================================================//
List<tblEmployee> empList = (from data in db.tblEmployees
orderby data.varFirstName ascending
select data).ToList();
tblEmployee empList1 = new tblEmployee();
empList1.intEmployeeID = 0;
empList1.varFirstName = "-- Select --";
empList.Insert(0, empList1);
SelectList objEmployeeList = new SelectList(empList, "intEmployeeID", "varFirstName", empID);
objEmpViewModel.EmployeeModel = objEmployeeList;
//=================================== End Employee Binding ==============================================//
if (empID == 0)
{
//================================== Employee Goal Title Binding =======================================//
List<tblGoalTitle> tgt = new List<tblGoalTitle>();
tblGoalTitle gt = new tblGoalTitle();
gt.intTilteID = 0;
gt.varTitleName = "-- Select --";
tgt.Insert(0, gt);
SelectList objGoalList = new SelectList(tgt, "intTilteID", "varTitleName", 0);
objEmpViewModel.GoalTitleModel = objGoalList;
//================================== End Employee Goal Title Binding =======================================//
//=================================== Status Binding ==================================================//
List<tblStatus> tc = new List<tblStatus>();
tblStatus tc1 = new tblStatus();
tc1.intStatusID = 0;
tc1.varStatus = "-- Select --";
tc.Insert(0, tc1);
SelectList objStatusList = new SelectList(tc, "intStatusID", "varStatus", 0);
objEmpViewModel.StatusModel = objStatusList;
//=================================== End Status Binding ==============================================//
}
else
{
List<tblGoalTitle> gt = (from data in db.tblGoalTitles
join data1 in db.tblEmployeeGoals on data.intTilteID equals data1.intTitle
where (data1.intEmployeeID == empID)
select data).ToList();
tblGoalTitle gt1 = new tblGoalTitle();
gt1.intTilteID = 0;
gt1.varTitleName = "-- Select --";
gt.Insert(0, gt1);
SelectList objGoalList = new SelectList(gt, "intTilteID", "varTitleName", titleID);
objEmpViewModel.GoalTitleModel = objGoalList;
List<tblStatus> tc = (from data in db.tblStatus
orderby data.varStatus ascending
select data).ToList();
tblStatus tc1 = new tblStatus();
tc1.intStatusID = 0;
tc1.varStatus = "-- Select --";
tc.Insert(0, tc1);
SelectList objStatusList = new SelectList(tc, "intStatusID", "varStatus", 0);
objEmpViewModel.StatusModel = objStatusList;
var query = (from data in db.tblEmployeeGoals
where (data.intTitle == titleID && data.intEmployeeID == empID)
select new { data.intStatus, data.varGoalDescription, data.varCompletion,data.varManagerComment }).Distinct();
foreach (var i in query)
{
objEmpViewModel.varGoalDescription = i.varGoalDescription;
objEmpViewModel.varCompletion = i.varCompletion + "%";
objEmpViewModel.intStatus = i.intStatus;
objEmpViewModel.varManagerComment = i.varManagerComment;
}
}
//=================================== End Employee Goal title binding =================================//
return View(objEmpViewModel);
}
