public string GetApplicantList()
{
try
{
using (HREntities db = new HREntities())
{
var data = (from ja in db.JobsAppliedFors
join jp in db.jobPosts on ja.jobpostid equals jp.jobId
join d in db.Candidates on ja.candidateid equals d.id
select(new
{
jp.jobTilte,
d.firstname,
d.lastname,
d.contact,
d.skillindividual,
d.skillset,
ja.applydate
})).ToList();
return(JsonConvert.SerializeObject(data));
}
}
catch (Exception)
{
throw;
}
}
public string GetEmpProjManagementList()
{
try
{
using (HREntities db = new HREntities())
{
var data = (from a in db.EmployeeProjectManagements
join m1 in db.Clients on a.clientid equals m1.clientId
join m2 in db.Projects on a.projectid equals m2.projectId
join u in db.UserManagements on a.userid equals u.userId
select new ModelEmpProjManagement
{
id = a.id,
userid = a.userid,
userName = u.email,
clientid = a.clientid,
clientName = m1.clientname,
projectid = a.projectid,
projectName = m2.projectName,
modules = a.modules,
branchid = a.branchid,
position = a.position,
estimatedclosedate = a.estimatedclosedate,
createddate = DateTime.UtcNow
});
return(JsonConvert.SerializeObject(data.ToList()));
}
}
catch (Exception)
{
throw;
}
}
public string UserManagement()
{
using (HREntities db = new HREntities())
{
try
{
var data = (from a in db.UserManagements
select new Models.UserManage
{
userId = a.userId,
firstName = a.firstName,
LastName = a.LastName,
email = a.email,
gender = a.gender,
phone = a.phone,
dob = a.dob,
address1 = a.address1,
address2 = a.address2,
createDate = a.createDate,
status = true,
roles = a.roles,
grade = a.grade,
gradeChangeDate = a.gradeChangeDate,
registeredBy = a.registeredBy,
branchId = a.branchId,
reportingTo = a.reportingTo
});
return(JsonConvert.SerializeObject(data.ToList <Models.UserManage>()));
}
catch (Exception ex)
{
throw;
}
}
}
public List <Models.ModelTask> GetTaskList()
{
try
{
using (HREntities db = new HREntities())
{
var data = (from a in db.Tasks
select new Models.ModelTask
{
TaskId = a.taskId,
TaskName = a.taskName,
CompletedDate = a.completedDate,
createDate = a.createdDate,
GitUrl = a.gitUrl,
TimeTaken = a.timeTaken,
});
return(data.ToList <Models.ModelTask>());
}
}
catch (Exception)
{
throw;
}
}
public object getCandidate(int id)
{
object candidate;
using (HREntities db = new HREntities())
{
candidate = db.Candidates.Where(x => x.id == id).ToList();
}
return(candidate);
}
public bool createJob(string recordid, string jobtitle, string skills, int noofvacancies, string remarks, bool isActive)
{
bool flagSucess = false;
//bool isActiveTest = true;
int userId = 0;
if (Session["adminuser"] != null)
{
string currentUser = Session["adminuser"].ToString();
if (currentUser != null)
{
userId = int.Parse(currentUser.Split('|')[0]);
}
}
using (HREntities db = new HREntities())
{
try
{
jobPost jobpost = new jobPost();
if (recordid == "")
{
jobpost.createDate = DateTime.Now;
jobpost.jobTilte = jobtitle;
jobpost.skills = skills;
jobpost.noOfVacancies = noofvacancies;
jobpost.remarks = remarks;
jobpost.userId = userId;
jobpost.isActive = isActive;
db.jobPosts.Add(jobpost);
}
else
{
long id = long.Parse(recordid);
jobpost = db.jobPosts.Where(x => x.jobId == id).SingleOrDefault();
jobpost.createDate = DateTime.Now;
jobpost.jobTilte = jobtitle;
jobpost.skills = skills;
jobpost.noOfVacancies = noofvacancies;
jobpost.remarks = remarks;
jobpost.userId = userId;
jobpost.isActive = isActive;
}
flagSucess = true;
db.SaveChanges();
}
catch (Exception)
{
throw;
}
}
return(flagSucess);
}
public bool SaveTask(string Taskname, string gitUrl, int timeTaken, string recordid)
{
bool flagSucess = false;
using (HREntities db = new HREntities())
{
if (recordid == "")
{
Task tsk = new Task()
{
taskName = Taskname,
gitUrl = gitUrl,
timeTaken = timeTaken,
createdDate = DateTime.UtcNow
};
if (Session["user"] != null)
{
string currentUser = Session["user"].ToString();
if (currentUser != null)
{
tsk.userId = long.Parse(currentUser.Split('|')[0]);
}
}
db.Tasks.Add(tsk);
}
else
{
long Taskid = long.Parse(recordid);
var data = db.Tasks.Where(j => j.taskId == Taskid);
if (data.Any())
{
var d = data.FirstOrDefault();
d.taskName = Taskname;
d.gitUrl = gitUrl;
d.timeTaken = timeTaken;
}
}
db.SaveChanges();
flagSucess = true;
}
return(flagSucess);
}
public string GetCandidateList()
{
try
{
using (HREntities db = new HREntities())
{
var data = db.Candidates.ToList();
return(JsonConvert.SerializeObject(data));
}
}
catch (Exception)
{
throw;
}
}
public string moduleList()
{
List <ProjectModule> moduleList = new List <ProjectModule>();
using (HREntities db = new HREntities())
{
try
{
moduleList = db.ProjectModules.OrderBy(a => a.modulename).ToList();
}
catch (Exception)
{
}
}
return(JsonConvert.SerializeObject(moduleList));
}
public string GetJobs()
{
try
{
using (HREntities db = new HREntities())
{
var data = db.jobPosts.Where(x => x.isActive == true).ToList();
jobPost obj = new jobPost();
return(JsonConvert.SerializeObject(data));
}
}
catch (Exception)
{
throw;
}
}
public string projectList()
{
List <Project> projectList = new List <Project>();
using (HREntities db = new HREntities())
{
try
{
projectList = db.Projects.OrderBy(a => a.projectName).ToList();
}
catch (Exception ex)
{
}
}
return(JsonConvert.SerializeObject(projectList));
}
public string skills()
{
List <Skill> skillList = new List <Skill>();
using (HREntities db = new HREntities())
{
try
{
skillList = db.Skills.ToList();
}
catch (Exception)
{
}
}
return(JsonConvert.SerializeObject(skillList));
}
public string branches()
{
List <Branch> branchList = new List <Branch>();
using (HREntities db = new HREntities())
{
try
{
branchList = db.Branches.ToList();
}
catch (Exception)
{
throw;
}
}
return(JsonConvert.SerializeObject(branchList));
}
public string roles()
{
List <UserRole> roleList = new List <UserRole>();
using (HREntities db = new HREntities())
{
try
{
roleList = db.UserRoles.ToList();
}
catch (Exception)
{
throw;
}
}
return(JsonConvert.SerializeObject(roleList));
}
public object ValidateUser(string userName, string password)
{
Boolean flag = false;
using (HREntities db = new HREntities())
{
try
{
var user = db.Candidates.Where(x => x.emialid == userName && x.password == password).ToList();
if (user.Count > 0)
{
flag = true;
Session["candidateuser"] = string.Format("{0}|{1}", user.FirstOrDefault().id, user.FirstOrDefault().emialid);
}
}
catch (Exception)
{
throw;
}
}
return(flag);
}
public bool createAdminUser(string fname, string lname, string email, string password, string phNumber, string gender, string address, string dob, string grade, string branch, string role, string reportingTo)
{
Boolean flag = false;
using (HREntities db = new HREntities())
{
try
{
var Candidate = db.Set <UserManagement>();
Candidate.Add(new UserManagement {
firstName = fname, LastName = lname, email = email, password = password, phone = phNumber, gender = gender, address1 = address, dob = Convert.ToDateTime(dob), grade = grade, branchId = Convert.ToInt32(branch), roles = role, reportingTo = Convert.ToInt32(reportingTo)
});
db.SaveChanges();
flag = true;
}
catch (Exception)
{
throw;
}
}
return(flag);
}
public bool updateCandidate(string skillset, int experience, string biodata)
{
bool flagSucess = false;
int userId = 0;
if (Session["adminuser"] != null)
{
string currentUser = Session["adminuser"].ToString();
if (currentUser != null)
{
userId = int.Parse(currentUser.Split('|')[0]);
}
}
Candidate candidate = new Candidate();
using (HREntities db = new HREntities())
{
try
{
candidate = db.Candidates.Where(x => x.id == userId).FirstOrDefault();
if (candidate != null)
{
candidate.skillset = skillset;
candidate.overallexperience = experience;
candidate.biodatapath = biodata;
}
db.SaveChanges();
flagSucess = true;
}
catch (Exception)
{
throw;
}
}
return(flagSucess);
}
public bool ValidateAdminUser(string userName, string password)
{
Boolean flag = false;
using (HREntities db = new HREntities())
{
try
{
var user = db.UserManagements.Where(x => x.email == userName && x.password == password);
if (user.Any())
{
flag = true;
Session["adminuser"] = string.Format("{0}|{1}", user.FirstOrDefault().userId, user.FirstOrDefault().email);
}
}
catch (Exception)
{
throw;
}
}
return(flag);
}
public bool createUser(string fname, string lname, string email, string password, string phNumber, string gender)
{
Boolean flag = false;
using (HREntities db = new HREntities())
{
try
{
var Candidate = db.Set <Candidate>();
Candidate.Add(new Candidate {
firstname = fname, lastname = lname, emialid = email, password = password, contact = phNumber, gender = gender
});
db.SaveChanges();
flag = true;
}
catch (Exception)
{
throw;
}
}
return(flag);
}
public bool SaveEmpProjManagement(int userid, int projectid, string modules, string position, DateTime estimatedclosedate)
{
bool flagSucess = false;
try
{
using (HREntities db = new HREntities())
{
EmployeeProjectManagement tsk = new EmployeeProjectManagement();
var cId = db.Projects.Where(a => a.projectId == projectid).Select(a => a.clientId).FirstOrDefault();
var bId = db.UserManagements.Where(a => a.userId == userid).Select(a => a.branchId).FirstOrDefault();
tsk.userid = userid;
tsk.clientid = cId;
tsk.projectid = projectid;
tsk.modules = modules;
tsk.branchid = bId == null ? 1 : bId;
tsk.position = position;
tsk.estimatedclosedate = estimatedclosedate;
tsk.status = "Added";
tsk.updatedby = 2;
tsk.createddate = DateTime.UtcNow;
db.EmployeeProjectManagements.Add(tsk);
db.SaveChanges();
flagSucess = true;
}
}
catch (Exception)
{
throw;
}
return(flagSucess);
}
public string ApplyForJob(string jobId)
{
try
{
//bool flagSucess = false;
int userId = 0;
if (Session["candidateuser"] != null)
{
string currentUser = Session["candidateuser"].ToString();
if (currentUser != null)
{
userId = int.Parse(currentUser.Split('|')[0]);
}
else
{
// HttpContext.Current.Response.Redirect("~/User/Signin.aspx");
return("unauthorised");
}
}
else
{
//HttpContext.Current.Response.Redirect("~/User/Signin.aspx");
return("unauthorised");
}
using (HREntities db = new HREntities())
{
long lngJobid = long.Parse(jobId);
var data = db.JobsAppliedFors.Where(x => x.candidateid == userId && x.jobpostid == lngJobid).ToList();
if (data.Count > 0)
{
return("Already Applied");
}
else
{
var job = db.jobPosts.Where(x => x.jobId == lngJobid).FirstOrDefault();
JobsAppliedFor objJob = new JobsAppliedFor()
{
applydate = DateTime.Today,
branchid = job.branchid,
jobpostid = Convert.ToInt32(jobId),
candidateid = Convert.ToInt32(userId),
createddate = DateTime.Today
};
db.JobsAppliedFors.Add(objJob);
db.SaveChanges();
return(JsonConvert.SerializeObject(objJob));
}
}
}
catch (Exception)
{
throw;
}
}