public ActionResult UploadMarks(tblApplicant obj)
{
IRepository repo = new ApplicantRepository();
var passingmarks = repo.Getmarkscriteria(Convert.ToInt32(obj.VacancyId)).Select(a => a.MarksCriteria).SingleOrDefault();
if (ModelState.IsValid)
{
if (obj.ApplicationId > 0)
{
if (obj.Marks >= passingmarks)
{
TempData["UpdateMessage3"] = "Uploaded Successfully";
repo.update2(obj.ApplicationId, Convert.ToInt32(obj.Marks));
repo.Save();
}
else if (obj.Marks < passingmarks)
{
TempData["UpdateMessage3"] = "Uploaded Successfully";
repo.update3(obj.ApplicationId, Convert.ToInt32(obj.Marks));
repo.Save();
}
}
else
{
repo.Add(obj);
}
repo.Save();
return(Json(new { success = true, message = "Marks Uploaded Successfully" }, JsonRequestBehavior.AllowGet));
}
return(Json(false, JsonRequestBehavior.AllowGet));
}
public ActionResult Edit(tblApplicant objApplicant)
{
string msg;
bool hasError = applicant.Update(objApplicant, out msg);
return(Json(new { Error = hasError }, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(tblApplicant applicantObj)
{
string msg;
bool hasError = applicant.Create(applicantObj, out msg);
return(Json(new { Error = hasError }, JsonRequestBehavior.AllowGet));
}
public bool Create(tblApplicant applicant, out string msg)
{
msg = "Not Saved";
var hasError = false;
try
{
db.tblApplicants.InsertOnSubmit(applicant);
db.SubmitChanges();
msg = "Saved";
}
catch (Exception ex)
{
hasError = true;
}
return(hasError);
}
public bool Delete(int id, out string msg)
{
msg = "Not Deleted";
var hasError = false;
try
{
tblApplicant std = db.tblApplicants.SingleOrDefault(i => i.ID == id);
db.tblApplicants.DeleteOnSubmit(std);
db.SubmitChanges();
msg = "Deleted";
}
catch (Exception ex)
{
hasError = true;
}
return(hasError);
}
public tblApplicant AddApplicant(int vacid, string name, string phone, string email, DateTime dob, string gender, string Appliedfor, string address, string cv)
{
var addapplicant = new tblApplicant()
{
VacancyId = vacid,
ApplicantName = name,
Phone = phone,
Email = email,
Dob = dob,
Gender = gender,
Appliedfor = Appliedfor,
Status = "Pending",
Address = address,
Submittedon = DateTime.Now.Date,
CV = cv,
TestStatus = "Pending",
};
return(addapplicant);
}
public bool Update(tblApplicant applicant, out string msg)
{
msg = "Not Saved";
var hasError = false;
try
{
db = new NitisDBDataContext();
tblApplicant objApplicant = db.tblApplicants.SingleOrDefault(i => i.ID == applicant.ID);
objApplicant.Name = applicant.Name;
objApplicant.Email = applicant.Email;
objApplicant.City = applicant.City;
objApplicant.Phone = applicant.Phone;
db.SubmitChanges();
msg = "Updated";
}
catch (Exception ex)
{
hasError = true;
throw ex;
}
return(hasError);
}
public void Add(tblApplicant obj)
{
context.tblApplicants.Add(obj);
}