public ActionResult Details(int skillid)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
DSRCManagementSystem.Models.Skills ObjLD = new DSRCManagementSystem.Models.Skills();
var Details = (from s in db.Skills
join ms in db.SkillsTechnologies on s.Technology equals ms.SkillId
join u in db.Users on s.ApprovedBy equals u.UserID
where s.Id == skillid
select new Skills()
{
ApprovedName = u.FirstName + " " + ((u.LastName).Length > 0? u.LastName:" "), // s.User.Firstname_lastname
ApprovedDate = s.ApprovedDate
}).FirstOrDefault();
return(View(Details));
}
public ActionResult EmployeeSkills(Skills model)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
Skills obj = new Skills();
var TechList = db.SkillsTechnologies.Where(x => x.IsActive == true).ToList();
var LevelList = db.Master_TrainingLevel.ToList();
var yearlist = db.Master_years.OrderByDescending(x => x.year).ToList();
string[] l = new string[LevelList.Count];
for (int j = 0; j < LevelList.Count; j++)
{
l[j] = LevelList[j].LevelName;
}
string[] t = new string[TechList.Count];
for (int k = 0; k < TechList.Count; k++)
{
t[k] = TechList[k].SkillName;
}
string[] y = new string[yearlist.Count];
for (int i = 0; i < yearlist.Count; i++)
{
// y[i] = yearlist[i].year1.ToString();
y[i] = yearlist[i].year.ToString();
}
DSRCManagementSystem.Models.Skills ObjLD = new DSRCManagementSystem.Models.Skills();
ModelState.Clear();
skilllist sk = new skilllist();
List <Skills> skl = new List <Skills>();
List <Skills> userSkl = new List <Skills>();
List <Skills> userSkl1 = new List <Skills>();
Skills lModel = new Skills();
int userId = Convert.ToInt32(Session["UserID"]);
var users = (from c in db.UserReportings
join b in db.Users on c.UserID equals b.UserID
where c.ReportingUserID == userId
select new
{
Name = b.FirstName + " " + (b.LastName ?? " "),
id = c.UserID
}).OrderBy(o => o.Name).ToList();
var requestStatus = (from rs in db.Master_SkillStatus
select new
{
RequestStatusId = rs.AssessmentStatusID,
RequestStatus = rs.AssessmentStatus
}).ToList();
ViewBag.requestStatus = new SelectList(requestStatus, "RequestStatusId", "RequestStatus", model.RequestStatusId);
ViewBag.UsersREP = new SelectList(users, "id", "Name", model.UserId);
List <Skills> modelObj = new List <Skills>();
//var skillSet
modelObj = (from s in db.Skills
join ms in db.SkillsTechnologies on s.Technology equals ms.SkillId
join tl in db.Master_TrainingLevel on s.Level equals tl.LevelId
join ss in db.SkillsSpecifications on s.Specialization equals ss.SpecificationId
join ur in db.UserReportings on s.UserId equals ur.UserID
join u in db.Users on s.UserId equals u.UserID
where ur.ReportingUserID == userId
select new Skills()
{
Id = s.Id,
UserId = u.UserID,
UName = u.FirstName + " " + (u.LastName ?? ""),
TechnologyID = s.Technology,
Technology = ms.SkillName,
SpecificationId = s.Specialization,
Specification = ss.Specification,
LevelId = s.Level,
level = tl.LevelName,
Primary = (bool)s.Primary,
Secondary = (bool)s.Secondary,
// DateAssessed = (s.Date).ToString("dd/MM/yyyy"),
LastUsed = s.LastUsed,
experiance = s.experiance,
Status = (int)s.status
}).ToList();
if (model.RequestStatusId != 0 && model.UserId != 0)
{
modelObj = modelObj.Where(o => o.Status == model.RequestStatusId && o.UserId == model.UserId).ToList();
}
else if (model.RequestStatusId != 0)
{
modelObj = modelObj.Where(o => o.Status == model.RequestStatusId).ToList();
}
else if (model.UserId != 0)
{
modelObj = modelObj.Where(o => o.UserId == model.UserId).ToList();
}
ViewBag.userSkills = modelObj;
List <SelectListItem> LevelList1 = new List <SelectListItem>();
List <SelectListItem> TechList1 = new List <SelectListItem>();
List <SelectListItem> yearlist11 = new List <SelectListItem>();
List <SelectListItem> specList1 = new List <SelectListItem>();
lModel.speciIdList = specList1;
foreach (var list in LevelList)
{
LevelList1.Add(new SelectListItem {
Text = list.LevelName, Value = Convert.ToString(list.LevelId)
});
}
lModel.LevelIDList = LevelList1;
foreach (var list in TechList)
{
TechList1.Add(new SelectListItem {
Text = list.SkillName, Value = Convert.ToString(list.SkillId)
});
}
lModel.TechIDList = TechList1;
foreach (var list in yearlist)
{
yearlist11.Add(new SelectListItem {
Text = list.year.ToString(), Value = Convert.ToString(list.year)
});
}
lModel.yearidlist = yearlist11;
for (int i = 0; i < 1; i++)
{
Skills lm = new Skills();
lm.SpecificationId = 0;
lm.LevelId = 0;
lm.Id = 0;
lm.DateAssessed = null;
lm.LastUsed = 0;
lm.Primary = false;
lm.Secondary = false;
skl.Add(lm);
}
sk.skilllists = skl;
sk.SKL = lModel;
return(View(modelObj));
}
public ActionResult Skills(string ID)
{
int INCOMING = 0;
if (ID == null)
{
INCOMING = 2;
ViewData["Phase"] = INCOMING;
}
else if (ID == "")
{
INCOMING = 0;
}
else
{
INCOMING = Convert.ToInt32(ID);
ViewData["Phase"] = INCOMING;
}
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
Skills obj = new Skills();
var TechList = db.SkillsTechnologies.Where(x => x.IsActive == true).ToList();
int userId = Convert.ToInt32(Session["UserID"]);
var LevelList = db.Master_TrainingLevel.ToList();
var reportingPersonId = db.UserReportings.Where(x => x.UserID == userId).Select(x => x.ReportingUserID).ToList();
List <ReportingPerson> reportingPersons = (from u in db.Users.Where(o => o.IsActive == true)
where reportingPersonId.Contains(u.UserID)
select new ReportingPerson
{
UserID = u.UserID,
Name = (u.FirstName + " " + (u.LastName ?? "")).Trim()
}).OrderBy(o => o.Name).ToList();
//ViewBag.details = new SelectList(reportingPersons, "UserID", "Name");
//var yearlist = db.Master_years.OrderByDescending(x => x.year1).ToList();
var yearlist = db.Master_years.OrderByDescending(x => x.year).ToList();
// var speclist = db.SkillsSpecifications.Where(x=>x.IsActive==true).ToList();
string[] l = new string[LevelList.Count];
for (int j = 0; j < LevelList.Count; j++)
{
l[j] = LevelList[j].LevelName;
}
string[] t = new string[TechList.Count];
for (int k = 0; k < TechList.Count; k++)
{
t[k] = TechList[k].SkillName;
}
string[] y = new string[yearlist.Count];
for (int i = 0; i < yearlist.Count; i++)
{
// y[i] = yearlist[i].year1.ToString();
y[i] = yearlist[i].year.ToString();
}
//string[] s = new string[speclist.Count];
//for (int r = 0; r < speclist.Count; r++)
//{
// s[r] = speclist[r].Specification;
//}
DSRCManagementSystem.Models.Skills ObjLD = new DSRCManagementSystem.Models.Skills();
ModelState.Clear();
skilllist sk = new skilllist();
List <Skills> skl = new List <Skills>();
List <Skills> userSkl = new List <Skills>();
List <Skills> userSkl1 = new List <Skills>();
Skills lModel = new Skills();
var skillSet = db.Skills.Where(skill => skill.UserId == userId && skill.status != 1 && skill.Isactive == true).Join(db.SkillsTechnologies, skill => skill.Technology, tech => tech.SkillId, (skill, tech) => new
{
skillMain = skill,
techMain = tech
}).Join(db.Master_TrainingLevel, skillLevel => skillLevel.skillMain.Level, level => level.LevelId, (allData, level) => new
{
skill = allData,
level = level
});
foreach (var item in skillSet)
{
Skills lm = new Skills();
lm.Id = item.skill.skillMain.Id;
lm.Technology = item.skill.techMain.SkillName;
lm.Specification = item.skill.skillMain.SkillsSpecification.Specification;
lm.level = item.level.LevelName;
lm.Primary = (bool)item.skill.skillMain.Primary;
lm.Secondary = (bool)item.skill.skillMain.Secondary;
lm.DateAssessed = ((DateTime)item.skill.skillMain.Date).ToString("dd/MM/yyyy");
lm.LastUsed = item.skill.skillMain.LastUsed;
lm.experiance = item.skill.skillMain.experiance;
lm.Status = (int)item.skill.skillMain.status;
if (INCOMING != 0)
{
if (lm.Status == INCOMING)
{
userSkl.Add(lm);
}
}
//else if (INCOMING != null && INCOMING!=0)
//{
// if (lm.Status == 2)
// {
// userSkl.Add(lm);
// }
//}
else
{
userSkl.Add(lm);
}
}
ViewBag.userSkills = userSkl;
var skillSet1 = db.Skills.Where(skill => skill.UserId == userId && skill.status == 1 && skill.Isactive == true).Join(db.SkillsTechnologies, skill => skill.Technology, tech => tech.SkillId, (skill, tech) => new
{
skillMain = skill,
techMain = tech
}).Join(db.Master_TrainingLevel, skillLevel => skillLevel.skillMain.Level, level => level.LevelId, (allData, level) => new
{
skill = allData,
level = level
});
foreach (var item in skillSet1)
{
Skills lm = new Skills();
lm.Id = item.skill.skillMain.Id;
lm.Technology = item.skill.techMain.SkillName;
lm.Specification = item.skill.skillMain.SkillsSpecification.Specification;
lm.level = item.level.LevelName;
lm.Primary = (bool)item.skill.skillMain.Primary;
lm.Secondary = (bool)item.skill.skillMain.Secondary;
lm.DateAssessed = ((DateTime)item.skill.skillMain.Date).ToString("dd/MM/yyyy");
lm.LastUsed = item.skill.skillMain.LastUsed;
lm.experiance = item.skill.skillMain.experiance;
userSkl1.Add(lm);
}
ViewBag.userSkills1 = userSkl1;
List <SelectListItem> LevelList1 = new List <SelectListItem>();
List <SelectListItem> TechList1 = new List <SelectListItem>();
List <SelectListItem> yearlist11 = new List <SelectListItem>();
List <SelectListItem> specList1 = new List <SelectListItem>();
List <SelectListItem> ApproveList1 = new List <SelectListItem>();
//foreach (var list in speclist)
//{
// specList1.Add(new SelectListItem { Text = list.Specification, Value = Convert.ToString(list.SpecificationId) });
//}
lModel.speciIdList = specList1;
foreach (var list in LevelList)
{
LevelList1.Add(new SelectListItem {
Text = list.LevelName, Value = Convert.ToString(list.LevelId)
});
}
lModel.LevelIDList = LevelList1;
foreach (var list in TechList)
{
TechList1.Add(new SelectListItem {
Text = list.SkillName, Value = Convert.ToString(list.SkillId)
});
}
lModel.TechIDList = TechList1;
foreach (var list in yearlist)
{
//yearlist11.Add(new SelectListItem { Text = list.year1.ToString(), Value = Convert.ToString(list.year1) });
yearlist11.Add(new SelectListItem {
Text = list.year.ToString(), Value = Convert.ToString(list.year)
});
}
lModel.yearidlist = yearlist11;
foreach (var list in reportingPersons)
{
ApproveList1.Add(new SelectListItem {
Text = Convert.ToString(list.Name), Value = Convert.ToString(list.UserID)
});
}
lModel.ApprovedList = ApproveList1;
for (int i = 0; i < 1; i++)
{
Skills lm = new Skills();
lm.SpecificationId = 0;
lm.LevelId = 0;
lm.Id = 0;
lm.DateAssessed = null;
lm.LastUsed = 0;
lm.Primary = false;
lm.Secondary = false;
skl.Add(lm);
}
sk.skilllists = skl;
sk.SKL = lModel;
var SkillStatus = db.Master_SkillStatus.Where(o => o.AssessmentStatusID == 2 || o.AssessmentStatusID == 3).ToList();
ViewBag.skillstatus = new SelectList(SkillStatus, "AssessmentStatusID", "AssessmentStatus");
return(View("Skills", sk));
}