public void Updatejobsdata(UsersJob UJ)
{
using (RecrutmentsysEntities db = new RecrutmentsysEntities())
{
//db.Database.Connection.Open();
//using (var dbcontexttransection = db.Database.Connection.BeginTransaction())
//{
// try
// {
COMPANY_JOB_OPENING CJO = db.COMPANY_JOB_OPENING.Find(UJ.DepatmentID);
CJO.DepartmentName = UJ.DepartmentName;
CJO.RequestedBy = UJ.RequestedBy;
CJO.Name_of_Vacancy = UJ.Name_of_Vacancy;
CJO.Number_of_Position = UJ.Number_of_Position;
CJO.Required_Technical_Skill = UJ.Required_Technical_Skill;
CJO.Special_Technical_Skill = UJ.Special_Technical_Skill;
CJO.Min_Yearof_Experience = UJ.Min_Yearof_Experience;
CJO.Min_Qualification = UJ.Min_Qualification;
CJO.Deadline_Date = UJ.Deadline_Date;
db.SaveChanges();
// dbcontexttransection.Commit();
//}
//catch
//{
// dbcontexttransection.Rollback();
//}
//}
}
}
//@@@@@@@********************* approval jobs
public void approvaljob(UsersJob UJ)
{
using (RecrutmentsysEntities db = new RecrutmentsysEntities())
{
COMPANY_JOB_OPENING CJO = db.COMPANY_JOB_OPENING.Find(UJ.DepatmentID);
CJO.Approval = UJ.Approval_admin;
db.SaveChanges();
}
}
public ActionResult AddExistingUser(Workers frm)
{
var uRepo = new UsersRepo();
var usr = uRepo.GetById(frm.UserId);
ViewBag.SeasonId = frm.SeasonId;
if (usr == null || usr.FullName != frm.FullName)
{
ModelState.AddModelError("FullName", Messages.UserNotExists);
return(PartialView("_WorkerList", GetWorkerVMByRelevantEntity(frm.RelevantEntityId, frm.RelevantEntityLogicalName, frm.SeasonId, frm.LeagueId)));
}
var uJob = new UsersJob
{
JobId = frm.JobId,
UserId = usr.UserId,
SeasonId = frm.SeasonId,
LeagueId = (frm.LeagueId == 0 ? (int?)null : frm.LeagueId)
};
switch (frm.RelevantEntityLogicalName)
{
case LogicaName.Union:
uJob.UnionId = frm.RelevantEntityId;
break;
case LogicaName.League:
uJob.LeagueId = frm.RelevantEntityId;
break;
case LogicaName.Team:
uJob.TeamId = frm.RelevantEntityId;
break;
case LogicaName.Club:
uJob.ClubId = frm.RelevantEntityId;
break;
}
var jobsRepo = new JobsRepo();
if (jobsRepo.IsUserInJob(frm.RelevantEntityLogicalName, frm.RelevantEntityId, uJob.JobId, usr.UserId))
{
ModelState.AddModelError("FullName", Messages.UserAlreadyHasThisRole);
return(PartialView("_WorkerList", GetWorkerVMByRelevantEntity(frm.RelevantEntityId, frm.RelevantEntityLogicalName, frm.SeasonId, frm.LeagueId)));
}
jobsRepo.AddUsersJob(uJob);
jobsRepo.Save();
TempData["SavedId"] = uJob.UserId;
return(PartialView("_WorkerList", GetWorkerVMByRelevantEntity(frm.RelevantEntityId, frm.RelevantEntityLogicalName, frm.SeasonId, frm.LeagueId)));
}
public static async Task Main(string[] args)
{
Console.WriteLine("RocketMod to OpenMod");
Console.WriteLine("If you haven't already please place this file inside the Rocket folder");
if (!File.Exists("Rocket.Permissions.Xml"))
{
Console.WriteLine("Wrong folder! Exiting");
await Task.Delay(3000);
return;
}
Job currentJob;
WriteFileType write;
if (args.Length == 0)
{
write = WriteFileType.Yaml;
}
else
{
write = args[0].ToLower() switch
{
"json" => WriteFileType.Json,
"xml" => WriteFileType.Xml,
_ => WriteFileType.Yaml
}
};
Console.WriteLine("1. Role Permissions ");
currentJob = new RolePermissionsJob(write);
await currentJob.DoAsync();
Console.WriteLine("2. User Permissions ");
Console.WriteLine("Coming soon :p");
Console.WriteLine("3. Users");
currentJob = new UsersJob(write);
await currentJob.DoAsync();
Console.WriteLine("4. Core Translations");
Console.WriteLine("Coming soon :p");
Console.WriteLine("Done!");
await Task.Delay(5000);
}
// CRUD Worker
public ActionResult EditWorker(int id, int relevantEntityId, LogicaName logicalName, int seasonId, int?leagueId)
{
var frm = new CreateWorkerForm
{
RelevantEntityId = relevantEntityId,
RelevantEntityLogicalName = logicalName,
};
switch (frm.RelevantEntityLogicalName)
{
case LogicaName.Union:
frm.JobsList = new SelectList(jobsRepo.GetByUnion(frm.RelevantEntityId), "JobId", "JobName");
break;
case LogicaName.League:
frm.JobsList = new SelectList(jobsRepo.GetByLeague(frm.RelevantEntityId), "JobId", "JobName");
break;
case LogicaName.Team:
frm.JobsList = new SelectList(jobsRepo.GetByTeam(frm.RelevantEntityId), "JobId", "JobName");
break;
case LogicaName.Club:
frm.JobsList = new SelectList(jobsRepo.GetClubJobs(frm.RelevantEntityId), "JobId", "JobName");
break;
default:
frm.JobsList = new List <SelectListItem>();
break;
}
UsersJob userJob = jobsRepo.GetUsersJobById(id);
frm.InjectFrom(userJob.User);
frm.JobId = userJob.JobId;
frm.UserJobId = userJob.Id;
frm.SeasonId = seasonId;
if (!string.IsNullOrEmpty(userJob.User.Password))
{
frm.Password = Protector.Decrypt(userJob.User.Password);
}
return(PartialView("_EditWorker", frm));
}
public void AddUsersJob(UsersJob job)
{
db.UsersJobs.Add(job);
}
public void RemoveUsersJob(UsersJob job)
{
db.UsersJobs.Remove(job);
}
public ActionResult CreateWorker(CreateWorkerForm frm)
{
if (usersRepo.GetByIdentityNumber(frm.IdentNum) != null)
{
var tst = Messages.IdIsAlreadyExists;
tst = string.Format(tst, "\"");
ModelState.AddModelError("IdentNum", tst);
}
if (usersRepo.GetByEmail(frm.Email) != null)
{
var tst = Messages.EmailAlreadyExists;
tst = string.Format(tst, "\"");
ModelState.AddModelError("Email", tst);
}
switch (frm.RelevantEntityLogicalName)
{
case LogicaName.Union:
frm.JobsList = new SelectList(jobsRepo.GetByUnion(frm.RelevantEntityId), "JobId", "JobName");
break;
case LogicaName.League:
frm.JobsList = new SelectList(jobsRepo.GetByLeague(frm.RelevantEntityId), "JobId", "JobName");
break;
case LogicaName.Team:
frm.JobsList = new SelectList(jobsRepo.GetByTeam(frm.RelevantEntityId), "JobId", "JobName");
break;
case LogicaName.Club:
frm.JobsList = new SelectList(jobsRepo.GetClubJobs(frm.RelevantEntityId), "JobId", "JobName");
break;
default:
frm.JobsList = new List <SelectListItem>();
break;
}
if (ModelState.IsValid)
{
var user = new User();
UpdateModel(user);
user.Password = Protector.Encrypt(frm.Password);
user.TypeId = 3;
usersRepo.Create(user);
var uJob = new UsersJob
{
JobId = frm.JobId,
UserId = user.UserId,
SeasonId = frm.SeasonId
};
switch (frm.RelevantEntityLogicalName)
{
case LogicaName.Union:
uJob.UnionId = frm.RelevantEntityId;
break;
case LogicaName.League:
uJob.LeagueId = frm.RelevantEntityId;
break;
case LogicaName.Team:
uJob.TeamId = frm.RelevantEntityId;
break;
case LogicaName.Club:
uJob.ClubId = frm.RelevantEntityId;
break;
}
var jRepo = new JobsRepo();
jRepo.AddUsersJob(uJob);
jRepo.Save();
ViewBag.SeasonId = frm.SeasonId;
TempData["WorkerAddedSuccessfully"] = true;
}
return(PartialView("_CreateWorker", frm));
}
public ActionResult EditWorker(CreateWorkerForm frm)
{
User user = usersRepo.GetById(frm.UserId);
UsersJob userJob = jobsRepo.GetUsersJobById(frm.UserJobId);
if (user == null)
{
string err = Messages.UserNotExists;
ModelState.AddModelError("FullName", err);
}
if (userJob == null)
{
string err = Messages.RoleNotExists;
ModelState.AddModelError("UserJob", err);
}
if (usersRepo.GetByIdentityNumber(frm.IdentNum) != null && frm.IdentNum != user.IdentNum)
{
string tst = Messages.IdIsAlreadyExists;
tst = String.Format(tst, "\"");
ModelState.AddModelError("IdentNum", tst);
}
if (usersRepo.GetByEmail(frm.Email) != null && frm.Email != user.Email)
{
string tst = Messages.EmailAlreadyExists;
tst = string.Format(tst, "\"");
ModelState.AddModelError("Email", tst);
}
bool isUserInJob = jobsRepo.IsUserInJob(frm.RelevantEntityLogicalName, frm.RelevantEntityId, frm.JobId, userJob.UserId);
if (isUserInJob && userJob.JobId != frm.JobId)
{
ModelState.AddModelError("JobId", Messages.UserAlreadyHasThisRole);
}
switch (frm.RelevantEntityLogicalName)
{
case LogicaName.Union:
frm.JobsList = new SelectList(jobsRepo.GetByUnion(frm.RelevantEntityId), "JobId", "JobName");
break;
case LogicaName.League:
frm.JobsList = new SelectList(jobsRepo.GetByLeague(frm.RelevantEntityId), "JobId", "JobName");
break;
case LogicaName.Team:
frm.JobsList = new SelectList(jobsRepo.GetByTeam(frm.RelevantEntityId), "JobId", "JobName");
break;
case LogicaName.Club:
frm.JobsList = new SelectList(jobsRepo.GetClubJobs(frm.RelevantEntityId), "JobId", "JobName");
break;
default:
frm.JobsList = new List <SelectListItem>();
break;
}
if (ModelState.IsValid)
{
UpdateModel(user);
user.Password = Protector.Encrypt(frm.Password);
usersRepo.Save();
userJob.SeasonId = frm.SeasonId;
UpdateModel(userJob);
userJob.LeagueId = (userJob.LeagueId == 0 ? (int?)null : userJob.LeagueId);
jobsRepo.Save();
TempData["WorkerAddedSuccessfully"] = true;
}
return(PartialView("_EditWorker", frm));
}
//get the record
public List <UsersJob> getuserjobs(string LoginName)
{
List <UsersJob> userjobs = new List <UsersJob>();
using (RecrutmentsysEntities db = new RecrutmentsysEntities())
{
var type = db.COMPANY_REGISTER_REFRENCES.Where(o => o.CompanyEmailRef.Equals(LoginName));
string typefor = type.FirstOrDefault().CompanyType;
if (typefor == "Other")
{
UsersJob UJV;
var hr_id = db.COMPANY_HR_REGISTER.Where(o => o.HrEmail == LoginName);
int hrid = hr_id.FirstOrDefault().HrId;
var users = db.COMPANY_JOB_OPENING.ToList();
foreach (COMPANY_JOB_OPENING u in db.COMPANY_JOB_OPENING.Where(o => o.HrId.Equals(hrid)))
{
UJV = new UsersJob();
UJV.CompanyId = u.CompanyId;
UJV.DepatmentID = u.DepatmentID;
UJV.DepartmentCode = u.DepartmentCode;
UJV.DepartmentName = u.DepartmentName;
UJV.RequestedBy = u.RequestedBy;
UJV.HrEmail = u.HrEmail;
UJV.Name_of_Vacancy = u.Name_of_Vacancy;
UJV.Number_of_Position = Convert.ToInt32(u.Number_of_Position);
UJV.Required_Technical_Skill = u.Required_Technical_Skill;
UJV.Special_Technical_Skill = u.Special_Technical_Skill;
UJV.Min_Yearof_Experience = u.Min_Yearof_Experience;
UJV.Min_Qualification = u.Min_Qualification;
UJV.Deadline_Date = Convert.ToDateTime(u.Deadline_Date);
UJV.Requested_Date = Convert.ToDateTime(u.Requested_Date);
UJV.Approval = Convert.ToBoolean(u.Approval);
userjobs.Add(UJV);
}
}
else
{
UsersJob UJV;
var compid = db.COMPANY_REGISTER_REFRENCES.Where(o => o.CompanyEmailRef == LoginName);
int companyid = Convert.ToInt32(compid.FirstOrDefault().CompanyId);
var users = db.COMPANY_JOB_OPENING.ToList();
foreach (COMPANY_JOB_OPENING u in db.COMPANY_JOB_OPENING.Where(o => o.CompanyId.Equals(companyid)))
{
UJV = new UsersJob();
UJV.CompanyId = u.CompanyId;
UJV.DepatmentID = u.DepatmentID;
UJV.DepartmentCode = u.DepartmentCode;
UJV.DepartmentName = u.DepartmentName;
UJV.RequestedBy = u.RequestedBy;
UJV.HrEmail = u.HrEmail;
UJV.Name_of_Vacancy = u.Name_of_Vacancy;
UJV.Number_of_Position = Convert.ToInt32(u.Number_of_Position);
UJV.Required_Technical_Skill = u.Required_Technical_Skill;
UJV.Special_Technical_Skill = u.Special_Technical_Skill;
UJV.Min_Yearof_Experience = u.Min_Yearof_Experience;
UJV.Min_Qualification = u.Min_Qualification;
UJV.Deadline_Date = Convert.ToDateTime(u.Deadline_Date);
UJV.Requested_Date = Convert.ToDateTime(u.Requested_Date);
UJV.Approval = Convert.ToBoolean(u.Approval);
UJV.Approval_admin = Convert.ToBoolean(u.Approval);
userjobs.Add(UJV);
}
}
}
return(userjobs);
}
public static async Task Main(string[] args)
{
try
{
Console.WriteLine("RocketMod to OpenMod");
Console.WriteLine("If you haven't already please place this file inside the Rocket folder");
if (!File.Exists("Permissions.Config.Xml"))
{
Console.WriteLine("Wrong folder! Exiting");
await Task.Delay(3000);
return;
}
Job currentJob;
WriteFileType write;
if (args.Length == 0)
{
write = WriteFileType.Yaml;
}
else
{
write = args[0].ToLower() switch
{
"json" => WriteFileType.Json,
"xml" => WriteFileType.Xml,
_ => WriteFileType.Yaml
}
};
Console.WriteLine("1. Permission Format Conversions ");
currentJob = new RolePermissionsReformatJob(write);
await currentJob.DoAsync();
Console.WriteLine("2. Permission Name Conversions ");
currentJob = new RolePermissionsRefactorJob(write);
await currentJob.DoAsync();
Console.WriteLine("3. User General Data");
currentJob = new UsersJob(write);
await currentJob.DoAsync();
Console.WriteLine("4. Core Translations");
currentJob = new LocalisationJob(write);
await currentJob.DoAsync();
Console.WriteLine("Finding jobs from external assemblies....");
ExternalJobManager externalJobManager = new ExternalJobManager(write);
await externalJobManager.LoadExternalJobs();
Console.WriteLine("Done!");
Console.ReadLine();
}
catch (Exception e)
{
Console.WriteLine(e);
Console.ReadLine();
}
}
