public ActionResult AddCoreQualification(Core_Qualification model)
{
cvId = GetId();
Core_Qualification cqul = new Core_Qualification();
if (!db.Core_Qualification.Any())
{
cqul.Id = 1;
}
else
{
int lastId = int.Parse(db.Core_Qualification.OrderByDescending(x => x.Id).Select(x => x.Id).First().ToString());
cqul.Id = lastId + 1;
}
cqul.CoreDesc = model.CoreDesc;
cqul.CoreSkill = model.CoreSkill;
cqul.DateCreated = DateTime.Now;
cqul.CVId = cvId;
cqul.QualField = model.QualField;
if (ModelState.IsValid)
{
db.Core_Qualification.Add(cqul);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else if (!ModelState.IsValid)
{
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult _FlowPartialView()
{
var f = new List <Freelancer>();
var edu = new Education();
var emp = new Prior_Employments();
var lang = new Language();
var qual = new Core_Qualification();
var emps = new List <Prior_Employments>();
var edus = new List <Education>();
var quals = new List <Core_Qualification>();
var langs = new List <Language>();
foreach (var x in db.Freelancer)
{
var cv = new CV();
var cvn = new List <CV>();
cv = db.CV.FirstOrDefault(c => c.FreelancerId == x.Id);
cvn.Add(cv);
var fl = new Freelancer()
{
Firstname = x.Firstname,
Lastname = x.Lastname,
Phone = x.Phone,
Email = x.Email,
Adress = x.Adress,
City = x.City,
Postalnr = x.Postalnr,
Nationality = x.Nationality,
Conumber = x.Conumber,
Id = x.Id,
CV = cvn
};
var free = fl.Id;
f.Add(fl);
}
PopulateList();
var qualFields = qualificationFields;
ViewBag.QualFields = qualFields;
ViewBag.Edu = edus;
ViewBag.Emp = emps;
ViewBag.Lang = langs;
ViewBag.Qual = quals;
return(PartialView("_FlowPartialView", f));
}
public ActionResult _CoreQualificationPartialView()
{
cvId = GetId();
Core_Qualification cqul = new Core_Qualification();
var qual = db.Core_Qualification.Where(p => p.CVId == cvId);
ViewBag.CoreQual = qual;
PopulateList();
var qualFields = qualificationFields;
ViewBag.QualFields = qualFields;
return(PartialView("_CoreQualificationPartialView", cqul));
}
public ActionResult _FreelancerCoreQPartialView(int?id)
{
var f = db.Freelancer.Find(id);
var c = db.CV.SingleOrDefault(cf => cf.FreelancerId == f.Id);
var cid = db.Core_Qualification.FirstOrDefault(cf => cf.CVId == c.FreelancerId);
var qc = new List <Core_Qualification>();
foreach (var x in c.Core_Qualification)
{
var q = new Core_Qualification()
{
QualField = x.QualField,
CoreDesc = x.CoreDesc,
CoreSkill = x.CoreSkill
};
qc.Add(q);
}
return(PartialView("_FreelancerCoreQPartialView", qc));
}
public ActionResult EditCoreQualifications(Core_Qualification model)
{
cvId = GetId();
Core_Qualification cqul = new Core_Qualification();
cqul.CoreDesc = model.CoreDesc;
cqul.CoreSkill = model.CoreSkill;
cqul.CVId = cvId;
cqul.Id = model.Id;
cqul.DateCreated = DateTime.Now;
cqul.QualField = model.QualField;
if (ModelState.IsValid)
{
db.Entry(cqul).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult _QualificationFlowPartialView(int input1, int input2)
{
var free = new List <Freelancer>();
var q = new Core_Qualification();
var cv = new CV();
var cvn = new List <CV>();
input1 = 1;
input2 = 5;
string desc = "Back-end";
foreach (var f in db.Freelancer)
{
cv = db.CV.SingleOrDefault(c => c.FreelancerId == f.Id);
cvn.Add(cv);
q = db.Core_Qualification.SingleOrDefault(x => x.CoreDesc == desc && x.CVId == cv.Id);
if (q == null)
{
break;
}
else
{
if (q.CoreSkill >= input1 && input2 >= q.CoreSkill)
{
var fl = new Freelancer()
{
Firstname = f.Firstname,
Lastname = f.Lastname,
Phone = f.Phone,
Email = f.Email,
CV = cvn
};
free.Add(fl);
}
}
}
return(PartialView("_QualificationFlowPartialView", free));
}
