private void loadStatus()
{
List <tblStatus> statusList = new List <tblStatus>();
tblStatus status = new tblStatus();
status.id = 0;
status.status = "";
statusList.Add(status);
status = new tblStatus();
status.id = 1;
status.status = "doing";
statusList.Add(status);
status = new tblStatus();
status.id = 9;
status.status = "done";
statusList.Add(status);
BindingSource bs = new BindingSource();
bs.DataSource = statusList;
cboStatus.DataSource = bs;
cboStatus.DisplayMember = "status";
cboStatus.ValueMember = "id";
}
public ActionResult DeleteConfirmed(int id)
{
tblStatus tblStatus = db.tblStatus.Find(id);
db.tblStatus.Remove(tblStatus);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID,Status,Color")] tblStatus tblStatus)
{
if (ModelState.IsValid)
{
db.Entry(tblStatus).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblStatus));
}
public ActionResult Edit([Bind(Include = "iStatusID,dtAdded,iAddedBy,dtEdited,iEditedBy,strStatus,bIsDeleted")] tblStatus tblStatus)
{
if (ModelState.IsValid)
{
db.Entry(tblStatus).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblStatus));
}
public ActionResult Create([Bind(Include = "ID,Status,Color")] tblStatus tblStatus)
{
if (ModelState.IsValid)
{
db.tblStatus.Add(tblStatus);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblStatus));
}
// GET: Status/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblStatus tblStatus = db.tblStatus.Find(id);
if (tblStatus == null)
{
return(HttpNotFound());
}
return(View(tblStatus));
}
public void DeleteTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
Guid statusGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblStatus status = dc.tblStatuses.FirstOrDefault(s => s.Id == statusGuid);
dc.tblStatuses.Remove(status);
dc.SaveChanges();
tblStatus deletedStatus = dc.tblStatuses.FirstOrDefault(s => s.Id == statusGuid);
Assert.IsNull(deletedStatus);
}
}
public void UpdateTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Retrieve test status based on ID and update it
Guid statusGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblStatus status = dc.tblStatuses.FirstOrDefault(s => s.Id == statusGuid);
status.Description = "UpdatedDescription";
//Save changes and get it back out
dc.SaveChanges();
tblStatus updatedStatus = dc.tblStatuses.FirstOrDefault(s => s.Description == "UpdatedDescription");
//Make sure the Ids match
Assert.AreEqual(status.Id, updatedStatus.Id);
}
}
public ActionResult Create([Bind(Include = "iStatusID,dtAdded,iAddedBy,dtEdited,iEditedBy,strStatus,bIsDeleted")] tblStatus tblStatus)
{
if (ModelState.IsValid)
{
// standard SU creation properties
tblStatus.iAddedBy = 0;
tblStatus.dtAdded = DateTime.Now;
tblStatus.iEditedBy = 0;
tblStatus.dtEdited = DateTime.Now;
tblStatus.bIsDeleted = false;
db.tblStatuses.Add(tblStatus);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblStatus));
}
public void LoadById(Guid id)
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblStatus status = dc.tblStatuses.Where(s => s.Id == id).FirstOrDefault();
if (status != null)
{
Id = status.Id;
Description = status.Description;
}
else
{
throw new Exception("Status not found");
}
}
}
catch (Exception ex) { throw ex; }
}
public int Update()
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblStatus status = dc.tblStatuses.Where(s => s.Id == Id).FirstOrDefault();
if (status != null)
{
status.Description = Description;
return(dc.SaveChanges());
}
else
{
throw new Exception("Status not found");
}
}
}
catch (Exception ex) { throw ex; }
}
public int Insert()
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblStatus status = new tblStatus()
{
Id = Guid.NewGuid(),
Description = Description
};
//Save the Id
this.Id = status.Id;
dc.tblStatuses.Add(status);
return(dc.SaveChanges());
}
}
catch (Exception ex) { throw ex; }
}
public void InsertTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Create a status
tblStatus status = new tblStatus
{
//Status a GUID for testing purposes
Id = Guid.Parse("11112222-3333-4444-5555-666677778888"),
Description = "Test"
};
//Add the status to the database
dc.tblStatuses.Add(status);
//Commit changes
int rowsInserted = dc.SaveChanges();
Assert.IsTrue(rowsInserted == 1);
}
}
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);
}
public ActionResult AddProject()
{
//============================= Employee binding entity =======================================//
List <tblEmployee> empList = (from data in db.tblEmployees
orderby data.varFirstName ascending
select data).ToList();
tblEmployee tm = new tblEmployee();
tm.intEmployeeID = 0;
tm.varFirstName = "-- Select --";
empList.Insert(0, tm);
SelectList objModelEmp = new SelectList(empList, "intEmployeeID", "varFirstName", 0);
ProjectViewModel objPrjModel = new ProjectViewModel();
objPrjModel.EmployeeModel = objModelEmp;
//============================= End Employee Binding Entity ===================================//
//============================= Project Status entity =========================================//
List <tblStatus> stList = (from data in db.tblStatus
orderby data.varStatus ascending
select data).ToList();
tblStatus ts = new tblStatus();
ts.intStatusID = 0;
ts.varStatus = "-- Select --";
stList.Insert(0, ts);
SelectList objModelStatus = new SelectList(stList, "intStatusID", "varStatus", 0);
objPrjModel.ProjectStatusList = objModelStatus;
//============================= End Project Status entity ======================================//
//============================= Client entity =================================================//
List <tblClientDetail> clientList = (from data in db.tblClientDetails
orderby data.varClientName ascending
select data).ToList();
tblClientDetail tcd = new tblClientDetail();
tcd.intClientID = 0;
tcd.varClientName = "-- Select--";
clientList.Insert(0, tcd);
SelectList objClientList = new SelectList(clientList, "intClientID", "varClientName", 0);
objPrjModel.ClientModel = objClientList;
//============================= End Client entity =============================================//
//============================= Internal Team entity ==========================================//
List <tblEmployee> internTeamList = (from data in db.tblEmployees
orderby data.varFirstName ascending
select data).ToList();
SelectList objInternList = new SelectList(internTeamList, "intEmployeeID", "varFirstName", 0);
objPrjModel.InternalTeam = objInternList;
//============================= End Internal Team entity ======================================//
//============================ Completion entity =============================================//
List <tblCompletion> complList = (from data in db.tblCompletions
orderby data.varComplition ascending
select data).ToList();
tblCompletion tcm = new tblCompletion();
tcm.intCompletionId = 0;
tcm.varComplition = "-- Select --";
complList.Insert(0, tcm);
SelectList objCompletionlist = new SelectList(complList, "intCompletionId", "varComplition", 0);
objPrjModel.CompletionModel = objCompletionlist;
//=========================== End Completion entity ========================================//
return(View(objPrjModel));
}
