public string DeleteTask(CompetencyTask compTask)
{
// var result = (int?)null;
string result = "";
try
{
// CompetencyTask cTask = new CompetencyTask();
using (var context = new SSITrainingEntities())
{
context.sp_CACompetency_DeleteTask(compTask.CompDefTaskID, compTask.CompDefHeaderID, Convert.ToInt32(Session["UserID"]));
//compTask.Active = false;
//compTask.ModifiedDateTime = DateTime.Now;
//compTask.ModifiedUserID = Convert.ToInt32(Session["USERID"]);
//context.CompetencyTasks.Attach(compTask);
//var entry = context.Entry(compTask);
//entry.Property(t => t.Active).IsModified = true;
//entry.Property(t => t.ModifiedUserID).IsModified = true;
//entry.Property(t => t.ModifiedDateTime).IsModified = true;
//context.SaveChanges();
}
}
catch (Exception ex)
{
result = "Task Update Failed";
Console.WriteLine(result);
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["compHeaderID"] != null)
{
Session["compHeaderID"] = Request.QueryString["compHeaderID"];
}
using (SSIRentEntities context = new SSIRentEntities())
{
Jobroles.DataSource = context.EmployeeJobRoles.ToList().OrderBy(x => x.JobRole);
Jobroles.DataBind();
RadComboBoxJobResp.DataSource = context.EmployeeQualifications.ToList().OrderBy(x => x.Qualification);
RadComboBoxJobTitles.DataSource = context.EmployeeJobTitles.ToList().OrderBy(x => x.JobTitle);
RadComboBoxUOM.DataSource = context.SchedulingRecurrenceUOMs.Where(b => b.SchedulingNotAvailable == true).ToList();
RadComboBoxFUOM.DataSource = context.SchedulingRecurrenceUOMs.Where(b => b.SchedulingNotAvailable == true).ToList();
RadComboBoxJobTitles.DataBind();
RadComboBoxJobResp.DataBind();
RadComboBoxUOM.DataBind();
RadComboBoxFUOM.DataBind();
}
using (SSITrainingEntities context = new SSITrainingEntities())
{
var allGroups = context.CompetencyGroups.OrderBy(i => i.GroupName);
RadComboBoxTrainingTypes.DataSource = context.TrainingTypes.ToList().OrderBy(x => x.TrainingType);
RadComboBoxTrainingTypes.DataBind();
rptTabs.DataSource = allGroups.ToList();
rptTabs.DataBind();
}
}
protected void RadComboBoxGroups_ItemsRequested(object sender, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
using (SSITrainingEntities context = new SSITrainingEntities())
{
//var allGroups = context.CompetencyGroups.OrderBy(i => i.GroupName);
//RadComboBoxGroups.DataSource = allGroups.ToList();
//RadComboBoxGroups.DataBind();
}
}
protected void RadComboBoxType_ItemsRequested(object sender, Telerik.Web.UI.RadComboBoxItemsRequestedEventArgs e)
{
RadComboBox RadComboBoxType = (RadComboBox)sender;
using (SSITrainingEntities context = new SSITrainingEntities())
{
var allTypes = context.CompetencyTypes.OrderBy(i => i.CompetencyTypeName);
RadComboBoxType.DataSource = allTypes.ToList();
RadComboBoxType.DataBind();
}
}
public string GetAssessors()
{
var jsonSerialiser = new JavaScriptSerializer();
using (var db = new SSITrainingEntities())
{
var assessors = db.sp_CACompetency_GetAllAssessors().ToList();
var json = jsonSerialiser.Serialize(assessors);
return(json);
}
}
// GET: EmployeeSnapshot
public string GetSnapshotEmployees()
{
var jsonSerialiser = new JavaScriptSerializer();
using (var db = new SSITrainingEntities())
{
var snapshotEmployees = db.sp_CACompetency_GetSnapshotEmployees().ToList();
var json = jsonSerialiser.Serialize(snapshotEmployees);
return(json);
}
}
// GET: Group
public JsonResult AddGroup(CompetencyGroup Group)
{
using (var context = new SSITrainingEntities())
{
string name = Group.GroupName;
Group.CreateDateTime = DateTime.Now;
Group.CreateUserId = Convert.ToInt32(Session["USERID"]);
context.CompetencyGroups.Add(Group);
context.SaveChanges();
return(Json(new { status = "Group Added Successfully!!" }));
}
}
public void DeleteGroup(CompetencyGroup group)
{
var compGroup = new CompetencyGroup {
CompetencyGroupID = group.CompetencyGroupID
};
using (SSITrainingEntities context = new SSITrainingEntities())
{
context.CompetencyGroups.Attach(compGroup);
context.CompetencyGroups.Remove(compGroup);
context.SaveChanges();
}
}
//public string GetCompetencies_withDefHeader(int GroupID, int compHeaderID)
//{
// var compList = new List<Competency>();
// var jsonSerialiser = new JavaScriptSerializer();
// using (var db = new SSITrainingEntities())
// {
// var query = from x in db.Competencies
// join s in db.tblCACompetency_Status on x.CompetencyStatusID equals s.CompetencyStatusID
// join t in db.CompetencyTypes on x.CompetencyTypeID equals t.CompetencyTypeID
// join d in db.CompetencyDefDetails on x.CompetencyID equals d.CompetencyID into leftjoin
// from dd in leftjoin.Where(f => f.CompDefHeaderID == compHeaderID && f.Active == true).DefaultIfEmpty()
// where x.CompetencyGroupID == GroupID && s.ObjectStatusCode == "Active"
// select new
// {
// CompetencyID = x.CompetencyID,
// CompetencyGroupID = x.CompetencyGroupID,
// CompetencyStatusID = x.CompetencyStatusID,
// Question = x.Question,
// Answer = x.Answer,
// CompetencyTypeID = x.CompetencyTypeID,
// LevelID = x.LevelID,
// CompetencyTypeName = t.CompetencyTypeName
// ,
// CompDefHeaderID = (dd.CompDefHeaderID == null) ? 0 : dd.CompDefHeaderID
// };
// try
// {
// compList = query.ToList().Select(x => new Competency
// {
// CompetencyID = x.CompetencyID,
// CompetencyGroupID = x.CompetencyGroupID,
// CompetencyStatusID = x.CompetencyStatusID,
// Question = x.Question,
// Answer = x.Answer,
// CompetencyTypeID = x.CompetencyTypeID,
// LevelID = x.LevelID,
// CompetencyTypeName = x.CompetencyTypeName
// ,
// CompDefHeaderID = x.CompDefHeaderID
// }).ToList();
// }
// catch (Exception ex)
// {
// }
// }
// var json = jsonSerialiser.Serialize(compList);
// return json;
//}
//public string GetCompDefDetails(int compHeaderID)
//{
// var compList = new List<Competency>();
// var jsonSerialiser = new JavaScriptSerializer();
// using (var db = new SSITrainingEntities())
// {
// var query = from x in db.Competencies
// join d in db.CompetencyDefDetails on x.CompetencyID equals d.CompetencyID
// join s in db.tblCACompetency_Status on x.CompetencyStatusID equals s.CompetencyStatusID
// join t in db.CompetencyTypes on x.CompetencyTypeID equals t.CompetencyTypeID
// where d.CompDefHeaderID == compHeaderID && s.ObjectStatusCode == "Active" && d.Active == true
// select new
// {
// CompetencyID = x.CompetencyID,
// CompetencyGroupID = x.CompetencyGroupID,
// CompetencyStatusID = x.CompetencyStatusID,
// Question = x.Question,
// Answer = x.Answer,
// CompetencyTypeID = x.CompetencyTypeID,
// LevelID = x.LevelID,
// CompetencyTypeName = t.CompetencyTypeName
// };
// compList = query.ToList().Select(x => new Competency
// {
// CompetencyID = x.CompetencyID,
// CompetencyGroupID = x.CompetencyGroupID,
// CompetencyStatusID = x.CompetencyStatusID,
// Question = x.Question,
// Answer = x.Answer,
// CompetencyTypeID = x.CompetencyTypeID,
// LevelID = x.LevelID,
// CompetencyTypeName = x.CompetencyTypeName
// }).ToList();
// }
// var json = jsonSerialiser.Serialize(compList);
// return json;
//}
public string GetCompHeaderDetails(int compHeaderID)
{
//CompetencyDefHeader CompDefHeader = new CompetencyDefHeader();
var jsonSerialiser = new JavaScriptSerializer();
using (var db = new SSITrainingEntities())
{
var compDefHeader = db.sp_CACompetency_GetCompetencyHeaderDetails(compHeaderID).Single();
var json = jsonSerialiser.Serialize(compDefHeader);
return(json);
}
}
public void RemovefromSnapshot(int EmployeeID, int CompDefHeaderID)
{
using (var context = new SSITrainingEntities())
{
try
{
context.sp_CACompetency_DeleteCompetency_fromEmployeeSnapshot(EmployeeID, CompDefHeaderID, Convert.ToInt32(Session["UserID"]));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
public void RemoveCompetencyDefinition(int compDefHeaderID)
{
using (var context = new SSITrainingEntities())
{
try
{
context.sp_CACompetency_RemoveCompetencyDefinition(compDefHeaderID, Convert.ToInt32(Session["UserID"]));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
public void InsertDetail(int compHeaderID, int CompetencyID)
{
using (var context = new SSITrainingEntities())
{
try
{
context.sp_CACompetency_InsertCompetencyDefDetail(compHeaderID, CompetencyID, Convert.ToInt32(Session["UserID"]));
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
public void RemoveManagerAssignments(int ObjectID, string ObjectType, int EmployeeID)
{
try
{
// CompetencyTask cTask = new CompetencyTask();
using (var context = new SSITrainingEntities())
{
context.sp_CACompetency_ManagerAssignments_Remove(ObjectID, ObjectType, EmployeeID, Convert.ToInt32(Session["USERID"]));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public string SetCompStatus(int compID, string statusCode)
{
var msg = "Competency Deleted Successfully!";
using (var context = new SSITrainingEntities())
{
try
{
context.sp_CACompetency_SetStatus(compID, statusCode);
}
catch (Exception ex)
{
msg = "Error Delete Competency. Please Contact IT with the following message: " + ex.Message;
}
}
return(msg);
}
public int?GetTaskMaxSort(int?compDefHeader)
{
int?maxSort = 0;
try
{
// CompetencyTask cTask = new CompetencyTask();
using (var context = new SSITrainingEntities())
{
maxSort = context.CompetencyTasks.Where(h => h.CompDefHeaderID == compDefHeader).Max(s => s.Sort);
}
}
catch (Exception ex)
{
}
return(maxSort = (maxSort ?? 0) + 1);
}
public string GetGroups()
{
List <CompetencyGroup> groupList = new List <CompetencyGroup>();
var jsonSerialiser = new JavaScriptSerializer();
using (var db = new SSITrainingEntities())
{
//return (from g in db.CompetencyGroups
// select g).ToList();
groupList = db.CompetencyGroups.ToList();
}
var json = jsonSerialiser.Serialize(groupList);
return(json);
//var j = Json(new { Response = groupList }, JsonRequestBehavior.AllowGet);
//return j;
//return groupList;
}
public string UpdateAllTaskSorts(int oldSort, int newSort, int compDefHeader)
{
string result = "Successfull";
try
{
// CompetencyTask cTask = new CompetencyTask();
using (var context = new SSITrainingEntities())
{
context.sp_CACompetency_UpdateSorts(oldSort, newSort, compDefHeader, Convert.ToInt32(Session["UserID"]));
}
}
catch (Exception ex)
{
result = "Failed To Update All Tasks";
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
using (SSITrainingEntities context = new SSITrainingEntities())
{
var allGroups = context.CompetencyGroups.OrderBy(i => i.GroupName);
var allTypes = context.CompetencyTypes.OrderBy(i => i.CompetencyTypeName);
rptTabs.DataSource = allGroups.ToList();
//rptPages.DataSource = allGroups.ToList();
RadComboBoxType.DataSource = allTypes.ToList();
RadComboBoxEditType.DataSource = allTypes.ToList();
RadComboBoxEditType.DataBind();
RadComboBoxType.DataBind();
rptTabs.DataBind();
//rptPages.DataBind();
}
}
public string GetAllEmployeeCompetencies(int EmployeeID)
{
var jsonSerialiser = new JavaScriptSerializer();
try {
using (var db = new SSITrainingEntities())
{
var snapshotEmployees = db.sp_CACompetency_GetAllEmployeeCompetencies(EmployeeID).ToList();
var json = jsonSerialiser.Serialize(snapshotEmployees);
return(json);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return("");
}
}
public string GetCompetencies(int GroupID)
{
var compList = new List <Competency>();
var jsonSerialiser = new JavaScriptSerializer();
using (var db = new SSITrainingEntities())
{
var query = from x in db.Competencies
join s in db.tblCACompetency_Status on x.CompetencyStatusID equals s.CompetencyStatusID
join t in db.CompetencyTypes on x.CompetencyTypeID equals t.CompetencyTypeID
where x.CompetencyGroupID == GroupID && s.ObjectStatusCode == "Active"
select new
{
CompetencyID = x.CompetencyID,
CompetencyGroupID = x.CompetencyGroupID,
CompetencyStatusID = x.CompetencyStatusID,
Question = x.Question,
Answer = x.Answer,
CompetencyTypeID = x.CompetencyTypeID,
LevelID = x.LevelID,
CompetencyTypeName = t.CompetencyTypeName
};
compList = query.ToList().Select(x => new Competency
{
CompetencyID = x.CompetencyID,
CompetencyGroupID = x.CompetencyGroupID,
CompetencyStatusID = x.CompetencyStatusID,
Question = x.Question,
Answer = x.Answer,
CompetencyTypeID = x.CompetencyTypeID,
LevelID = x.LevelID,
CompetencyTypeName = x.CompetencyTypeName
}).ToList();
}
var json = jsonSerialiser.Serialize(compList);
return(json);
//var j = Json(new { Response = groupList }, JsonRequestBehavior.AllowGet);
//return j;
//return groupList;
}
public int?InsertHeader(CompetencyDefHeader header)
{
var result = (int?)null;
using (var context = new SSITrainingEntities())
{
try
{
result = context.sp_CACompetency_CompetencyDefHeader_Insert(header.JobTitleID, header.JobRoleID, header.JobResponsibilityID, header.Description, header.PassingGrade,
header.NotifyDays, header.NotifyEmail, header.RecurrenceQty, header.UOMSchedulingRecurrenceID, header.Failure_RecurrenceQty, header.Failure_UOMSchedulingRecurrenceID,
Convert.ToInt32(Session["UserID"])).FirstOrDefault();
header.CompDefHeaderID = Convert.ToInt32(result);
}
catch (Exception ex)
{
}
return(result);
}
}
// GET: Competency
public Competency AddEditComp(Competency comp)
{
using (var context = new SSITrainingEntities())
{
try
{
var result = context.sp_CACompetency_AddEditCompetency(comp.CompetencyID, comp.CompetencyGroupID, comp.Question,
comp.Answer, comp.CompetencyTypeID, comp.LevelID, Convert.ToInt32(Session["USERID"]));
if (comp.CompetencyID == 0) //if this is true, then this is a Competency Insert, otherwise, it's an edit.
{
comp.CompetencyID = Convert.ToInt32(result);
comp.CreateUserID = Convert.ToInt32(Session["USERID"]);
}
}
catch (Exception ex)
{
}
return(comp);
}
}
public string UpdateHeader(CompetencyDefHeader header)
{
// var result = (int?)null;
string result = "";
using (var context = new SSITrainingEntities())
{
try
{
context.sp_CACompetency_CompetencyDefHeader_Update(header.CompDefHeaderID, header.JobTitleID, header.JobRoleID, header.JobResponsibilityID, header.Description, header.PassingGrade,
header.NotifyDays, header.NotifyEmail, header.RecurrenceQty, header.UOMSchedulingRecurrenceID, header.Failure_RecurrenceQty, header.Failure_UOMSchedulingRecurrenceID, Convert.ToInt32(Session["UserID"]));
result = "Success";
// header.CompDefHeaderID = Convert.ToInt32(result);
}
catch (Exception ex)
{
result = "Update was not successful. Here's why:" + ex.Message;
}
return(result);
}
}
// GET: Assessment
public string GetManager_Employees()
{
var jsonSerialiser = new JavaScriptSerializer();
//var listOfStrings = new List<string>();
//string[] arrayOfStrings = listOfStrings.ToArray();
try
{
using (var db = new SSITrainingEntities())
{
var result = db.sp_CACompetency_GetManagerEmployees(Convert.ToInt32(Session["UserID"])).ToArray();
var json = jsonSerialiser.Serialize(result);
return(json);
}
}
catch (Exception ex)
{
return("");
}
}
public Array GetCompetencyDefinitions()
{
var jsonSerialiser = new JavaScriptSerializer();
var listOfStrings = new List <string>();
string[] arrayOfStrings = listOfStrings.ToArray();
try {
using (var db = new SSITrainingEntities())
{
var result = db.sp_CACompetency_GetCompetencyDefinitions().ToArray();
var json = jsonSerialiser.Serialize(result);
return(result);
}
}
catch (Exception ex)
{
return(arrayOfStrings);
}
}
public string GetJobResps(int EmployeeID)
{
var jsonSerialiser = new JavaScriptSerializer();
string jobespList = "";
try
{
using (var db = new SSITrainingEntities())
{
var result = db.sp_CACompetency_GetManagerJobQualification_Access(EmployeeID).ToArray();
var json = jsonSerialiser.Serialize(result);
jobespList = json;
}
}
catch (Exception ex)
{
}
return(jobespList);
}
public JsonResult AddTask(CompetencyTask compTask)
{
try {
// CompetencyTask cTask = new CompetencyTask();
using (var context = new SSITrainingEntities())
{
compTask.Sort = GetTaskMaxSort(compTask.CompDefHeaderID);
compTask.CreateDateTime = DateTime.Now;
compTask.CreateUserID = Convert.ToInt32(Session["USERID"]);
context.CompetencyTasks.Add(compTask);
context.SaveChanges();
return(Json(new { status = "Task Added Successfully!!" }));
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(Json(new { status = ex.Message }));
}
}
// GET: Global
public MobileUser GetMobileUser(string LastSix)
{
MobileUser mobileUser = new MobileUser();
try
{
using (var db = new SSITrainingEntities())
{
var query = db.sp_sys_GetMobileLogin(LastSix).Single();
mobileUser.Name = query.Name;
mobileUser.EmployeeID = query.EmployeeID;
mobileUser.EmployeeNumber = query.EmployeeNumber;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(mobileUser);
}
public string GetCompetencyDefinitions(int EmployeeID)
{
var jsonSerialiser = new JavaScriptSerializer();
var listOfStrings = new List <string>();
string[] arrayOfStrings = listOfStrings.ToArray();
try
{
using (var db = new SSITrainingEntities())
{
var result = db.sp_CACompetency_GetUnAssigned_CompetencyDefinitions(EmployeeID).ToList();
var json = jsonSerialiser.Serialize(result);
return(json);
}
}
catch (Exception ex)
{
return("");
}
}
public string GetCurrentTasks(int compDefHeaderID)
{
var taskList = new List <CompetencyTask>();
var jsonSerialiser = new JavaScriptSerializer();
string json = "";
try {
using (var db = new SSITrainingEntities())
{
var query = from x in db.CompetencyTasks
where x.CompDefHeaderID == compDefHeaderID && x.Active == true
select x;
taskList = query.OrderBy(t => t.Sort).ToList();
json = jsonSerialiser.Serialize(taskList);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.InnerException);
}
return(json);
}
