public ActionResult PhdInfo(string qenID)
{
long qenid = 0;
try
{
qenid = (long)Convert.ToInt64(qenID);
//if (qenid == (long)Session["LoginID"])
//{
qendidatePHD model = null;
model = db.qendidatePHDs.Where(ex => ex.qenID == qenid).FirstOrDefault();
return(View(model));
//}
//else
//{
// TempData["msg"] = "Invalid user to update record";
// return RedirectToAction("Error");
//}
}
catch (Exception ex)
{
TempData["msg"] = ex.Message.ToString();
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(qenid);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
return(RedirectToAction("Error"));
}
}
public ActionResult AcademicInfo(string qenID)
{
long qenid = 0;
try
{
qenid = (long)Convert.ToInt64(qenID);
//if (qenid == (long)Session["LoginID"])
//{
ViewBag.qenid = qenid;
return(View());
//}
//else
//{
// TempData["msg"] = "Invalid user to update record";
// return RedirectToAction("Error");
//}
}
catch (Exception ex)
{
TempData["msg"] = ex.Message.ToString();
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(qenid);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
return(RedirectToAction("Error"));
}
}
public ActionResult CareerObjective(FormCollection frm)
{
try
{
long qenid = 0;
string txt = string.Empty;
qenid = Convert.ToInt64(frm["hdn_qenID"]);
txt = frm["CareerObjective"].ToString();
qendidateList oqendidateList = new qendidateList();
oqendidateList = db.qendidateLists.Find(qenid);
oqendidateList.CareerObjective = txt;
db.SaveChanges();
return(RedirectToAction("thankyou"));
}
catch (Exception ex)
{
TempData["msg"] = ex.Message.ToString();
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(frm["hdn_qenID"]);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
return(RedirectToAction("Error"));
}
}
public ActionResult EmplomentInfo(string qenID)
{
long qenid = 0;
try
{
qenid = (long)Convert.ToInt64(qenID);
//if (qenid == (long)Session["LoginID"])
//{
EmployerModel model = null;
List <qenEmpDetail> emp = null;
if (qenid != 0)
{
emp = db.qenEmpDetails.Where(ex => ex.qenID == qenid).ToList();
if (emp.Count > 0 && emp != null)
{
model = new EmployerModel();
model.employers = emp;
model.qenid = qenid;
}
else
{
model = new EmployerModel();
model.qenid = qenid;
}
}
else
{
model = new EmployerModel();
model.qenid = qenid;
}
ViewBag.qenID = qenid;
return(View(model));
//}
//else
//{
// TempData["msg"] = "Invalid user to update record";
// return RedirectToAction("Error");
//}
}
catch (Exception ex)
{
TempData["msg"] = ex.Message.ToString();
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(qenid);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
return(RedirectToAction("Error"));
}
}
public ActionResult RefrenceInfo(string qenID)
{
long qenid = 0;
try
{
qenid = (long)Convert.ToInt64(qenID);
//if (qenid == (long)Session["LoginID"])
//{
qenrefvalidation model = null;
List <qenReference> reflist = db.qenReferences.Where(ex => ex.qenID == qenid).OrderBy(ex => ex.qenRefID).ToList();
if (reflist != null && reflist.Count() > 1)
{
model = new qenrefvalidation();
model.qenRefName1 = reflist[0].qenRefName;
model.qenRefPhone1 = reflist[0].qenRefPhone;
model.qenRefPosition1 = reflist[0].qenRefPosition;
model.qenRefEmail1 = reflist[0].qenRefEmail;
model.qenRefCompany1 = reflist[0].qenRefCompany;
model.qenRefName2 = reflist[1].qenRefName;
model.qenRefPhone2 = reflist[1].qenRefPhone;
model.qenRefPosition2 = reflist[1].qenRefPosition;
model.qenRefEmail2 = reflist[1].qenRefEmail;
model.qenRefCompany2 = reflist[1].qenRefCompany;
}
else
{
model = new qenrefvalidation();
model.qenid = (Int32)qenid;
}
ViewBag.qenID_ = qenid;
return(View(model));
//}
//else
//{
// TempData["msg"] = "Invalid user to update record";
// return RedirectToAction("Error");
//}
}
catch (Exception ex)
{
TempData["msg"] = ex.Message.ToString();
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(qenid);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
return(RedirectToAction("Error"));
}
}
public ActionResult Graduation(qendidateGraduation oqenSecondary)
{
try
{
oqenSecondary.dataIsCreated = BaseUtil.GetCurrentDateTime();
oqenSecondary.dataIsUpdated = BaseUtil.GetCurrentDateTime();
if (ModelState.IsValid)
{
if (!db.qendidateGraduations.Any(e => e.qenID == oqenSecondary.qenID))
{
db.qendidateGraduations.Add(oqenSecondary);
db.SaveChanges();
TempData["msg"] = "Success";
}
else
{
var oqenSecondary1 = db.qendidateGraduations.Where(e => e.qenID == oqenSecondary.qenID).FirstOrDefault();
oqenSecondary1.gradPercentage = oqenSecondary.gradPercentage;
oqenSecondary1.subjects = oqenSecondary.subjects;
oqenSecondary1.YearPassing = oqenSecondary.YearPassing;
oqenSecondary1.collegeName = oqenSecondary.collegeName;
oqenSecondary1.collegeUniversity = oqenSecondary.collegeUniversity;
oqenSecondary1.courseField = oqenSecondary.courseField;
oqenSecondary1.courseName = oqenSecondary.courseName;
oqenSecondary1.dataIsUpdated = BaseUtil.GetCurrentDateTime();
db.Entry(oqenSecondary1).State = EntityState.Modified;
db.SaveChanges();
TempData["msg"] = "Success";
}
}
else
{
TempData["msg"] = "fail";
}
return(RedirectToAction("AcademicInfo", new { qenid = oqenSecondary.qenID }));
}
catch (Exception ex)
{
TempData["msg"] = ex.Message.ToString();
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(oqenSecondary.qenID);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
return(RedirectToAction("Error"));
}
}
public ActionResult higherSchool(qenHigherSecondary oqenSecondary)
{
try
{
oqenSecondary.dataIsCreated = BaseUtil.GetCurrentDateTime();
oqenSecondary.dataIsUpdated = BaseUtil.GetCurrentDateTime();
if (ModelState.IsValid)
{
if (!db.qenHigherSecondaries.Any(e => e.qenID == oqenSecondary.qenID))
{
db.qenHigherSecondaries.Add(oqenSecondary);
db.SaveChanges();
TempData["msg"] = "Success";
}
else
{
var oqenSecondary1 = db.qenHigherSecondaries.Where(e => e.qenID == oqenSecondary.qenID).FirstOrDefault();
oqenSecondary1.hSecondaryBoard = oqenSecondary.hSecondaryBoard;
oqenSecondary1.hSecondaryPassYear = oqenSecondary.hSecondaryPassYear;
oqenSecondary1.hSecondaryPercentage = oqenSecondary.hSecondaryPercentage;
oqenSecondary1.hSecondarySubjects = oqenSecondary.hSecondarySubjects;
oqenSecondary1.schoolName = oqenSecondary.schoolName;
oqenSecondary1.dataIsUpdated = BaseUtil.GetCurrentDateTime();
db.Entry(oqenSecondary1).State = EntityState.Modified;
db.SaveChanges();
TempData["msg"] = "Success";
}
}
else
{
TempData["msg"] = "fail";
}
return(RedirectToAction("AcademicInfo", new { qenid = oqenSecondary.qenID }));
}
catch (Exception ex)
{
TempData["msg"] = ex.Message.ToString();
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(oqenSecondary.qenID);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
return(RedirectToAction("Error"));
}
}
// GET: profiler
public ActionResult Introduction(string qenID)
{
long qenid = 0;
try
{
qenid = (long)Convert.ToInt64(qenID);
if (qenid != 0)
{
var qenList = db.qendidateLists.Where(e => e.qenID == qenid).FirstOrDefault();
if (qenList != null)
{
Session["LoginID"] = qenid;
ViewBag.qenid = qenid;
if (qenList.qenName != null && qenList.qenName != "")
{
ViewBag.candidateName = qenList.qenName;
}
else
{
ViewBag.candidateName = "Unknown";
}
return(View());
}
TempData["msg"] = "Invalid user to update record";
return(RedirectToAction("Error"));
}
else
{
TempData["msg"] = "Invalid user to update record";
return(RedirectToAction("Error"));
}
}
catch (Exception ex)
{
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(qenid);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
TempData["msg"] = "Error : " + ex.Message.ToString();
return(RedirectToAction("Error"));
}
}
public ActionResult SavePhdInfo(qendidatePHD model)
{
try
{
if (model.courseField != null && model.courseField.Trim() != "")
{
qendidatePHD phd = null;
if (model.phdid != 0)
{
phd = db.qendidatePHDs.Where(ex => ex.phdid == model.phdid).FirstOrDefault();
if (phd != null)
{
phd.courseField = model.courseField;
phd.phdRemarks = model.phdRemarks;
phd.phdTitle = model.phdTitle;
phd.phdStart = model.phdStart;
phd.phdEnd = model.phdEnd;
phd.collegeName = model.collegeName;
phd.collegeUniversity = model.collegeUniversity;
phd.dataIsUpdated = BaseUtil.GetCurrentDateTime();
db.SaveChanges();
}
}
else
{
model.dataIsCreated = BaseUtil.GetCurrentDateTime();
db.qendidatePHDs.Add(model);
db.SaveChanges();
}
}
return(RedirectToAction("certifications", new { qenid = model.qenID }));
}
catch (Exception ex)
{
TempData["msg"] = ex.Message.ToString();
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(model.qenID);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
return(RedirectToAction("Error"));
}
}
public ActionResult AddSkills(qenSkillName model)
{
try
{
qenSkill oqenSkill = null;
oqenSkill = db.qenSkills.Where(ex => ex.qenSkillsID == model.qenSkillsID).FirstOrDefault();
if (oqenSkill != null)
{
int skill_id = checkValuExist(model.skillName.ToString());
oqenSkill.skillsID = skill_id;
oqenSkill.yearOfExp = model.yearOfExp;
oqenSkill.qenID = model.qenID;
oqenSkill.qenSkillsID = model.qenSkillsID;
db.Entry(oqenSkill).State = EntityState.Modified;
db.SaveChanges();
}
else
{
oqenSkill = new qenSkill();
int skill_id = checkValuExist(model.skillName.ToString());
oqenSkill.skillsID = skill_id;
oqenSkill.yearOfExp = model.yearOfExp;
oqenSkill.qenID = model.qenID;
db.qenSkills.Add(oqenSkill);
db.SaveChanges();
}
return(RedirectToAction("skills", new { qenid = model.qenID }));
}
catch (Exception ex)
{
TempData["msg"] = ex.Message.ToString();
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(model.qenID);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
return(RedirectToAction("Error"));
}
}
public ActionResult SaveEmploymentDetails(qenEmpDetail model)
{
try
{
qenEmpDetail emp = null;
if (model.qenEmploymentNum != 0)
{
emp = db.qenEmpDetails.Where(ex => ex.qenEmploymentNum == model.qenEmploymentNum).FirstOrDefault();
if (emp != null)
{
emp.qenPosition = model.qenPosition;
emp.qenEmpFrom = model.qenEmpFrom;
emp.qenEmpTo = model.qenEmpTo;
emp.qenSalary = model.qenSalary;
emp.CompanyName = model.CompanyName;
emp.jobDescription = model.jobDescription;
emp.dataIsUpdated = BaseUtil.GetCurrentDateTime();
db.SaveChanges();
}
}
else
{
model.dataIsCreated = BaseUtil.GetCurrentDateTime();
db.qenEmpDetails.Add(model);
db.SaveChanges();
}
return(RedirectToAction("EmplomentInfo", new { qenid = model.qenID }));
}
catch (Exception ex)
{
TempData["msg"] = ex.Message.ToString();
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(model.qenID);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
return(RedirectToAction("Error"));
}
}
public ActionResult CareerObjective(string qenID)
{
long qenid = 0;
try
{
qenid = (long)Convert.ToInt64(qenID);
//if (qenid == (long)Session["LoginID"])
//{
var careerObjective = db.qendidateLists.Where(e => e.qenID == qenid).Select(e => new { e.CareerObjective }).FirstOrDefault();
if (careerObjective.CareerObjective != null)
{
ViewBag.careerObjective = careerObjective.CareerObjective.ToString();
}
else
{
ViewBag.careerObjective = "";
}
ViewBag.qenID = qenid;
return(View());
// }
//else
// {
// TempData["msg"] = "Invalid user to update record";
// return RedirectToAction("Error");
// }
}
catch (Exception ex)
{
TempData["msg"] = ex.Message.ToString();
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(qenid);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
return(RedirectToAction("Error"));
}
}
public ActionResult PostGraduation(long qenid)
{
try
{
//if (qenid == (long)Session["LoginID"])
//{
qendidatePGraduation oqenSecondary = null;
oqenSecondary = db.qendidatePGraduations.Where(e => e.qenID == qenid).FirstOrDefault();
if (oqenSecondary != null)
{
return(PartialView("_partialPostGraduation", oqenSecondary));
}
else
{
oqenSecondary = new qendidatePGraduation();
oqenSecondary.qenID = qenid;
return(PartialView("_partialPostGraduation"));
}
//}
//else
//{
// TempData["msg"] = "Invalid user to update record";
// return RedirectToAction("Error");
//}
}
catch (Exception ex)
{
TempData["msg"] = ex.Message.ToString();
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(qenid);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
return(RedirectToAction("Error"));
}
}
public ActionResult SaveRefrenceInfo(qenrefvalidation refinfo)
{
try
{
List <qenReference> refrence = db.qenReferences.Where(ex => ex.qenID == refinfo.qenid).ToList();
qenReference ref1 = null;
qenReference ref2 = null;
if (refrence.Count > 0 && refrence != null)
{
ref1 = refrence[0];
ref2 = refrence[1];
if (ref1 != null)
{
ref1.qenRefEmail = refinfo.qenRefEmail1;
ref1.qenRefCompany = refinfo.qenRefCompany1;
ref1.qenRefName = refinfo.qenRefName1;
ref1.qenRefPhone = refinfo.qenRefPhone1;
ref1.qenRefPosition = refinfo.qenRefPosition1;
ref1.dataIsUpdated = BaseUtil.GetCurrentDateTime();
ref2.qenID = Convert.ToInt32(refinfo.qenid);
db.SaveChanges();
}
if (ref2 != null)
{
ref2.qenRefEmail = refinfo.qenRefEmail2;
ref2.qenRefCompany = refinfo.qenRefCompany2;
ref2.qenRefName = refinfo.qenRefName2;
ref2.qenRefPhone = refinfo.qenRefPhone2;
ref2.qenRefPosition = refinfo.qenRefPosition2;
ref2.dataIsUpdated = BaseUtil.GetCurrentDateTime();
ref2.qenID = Convert.ToInt32(refinfo.qenid);
db.SaveChanges();
}
}
else
{
ref1 = new qenReference();
ref2 = new qenReference();
ref1.qenRefEmail = refinfo.qenRefEmail1;
ref1.qenRefCompany = refinfo.qenRefCompany1;
ref1.qenRefName = refinfo.qenRefName1;
ref1.qenRefPhone = refinfo.qenRefPhone1;
ref1.qenRefPosition = refinfo.qenRefPosition1;
ref1.dataIsCreated = BaseUtil.GetCurrentDateTime();
ref1.qenID = Convert.ToInt32(refinfo.qenid);
ref2.qenRefEmail = refinfo.qenRefEmail2;
ref2.qenRefCompany = refinfo.qenRefCompany2;
ref2.qenRefName = refinfo.qenRefName2;
ref2.qenRefPhone = refinfo.qenRefPhone2;
ref2.qenRefPosition = refinfo.qenRefPosition2;
ref2.dataIsCreated = BaseUtil.GetCurrentDateTime();
ref2.qenID = Convert.ToInt32(refinfo.qenid);
db.qenReferences.Add(ref1);
db.qenReferences.Add(ref2);
db.SaveChanges();
}
return(RedirectToAction("CareerObjective", new { qenID = refinfo.qenid }));
}
catch (Exception ex)
{
TempData["msg"] = ex.Message.ToString();
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(refinfo.qenid);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
return(RedirectToAction("Error"));
}
}
public ActionResult SavePersonalInfo(qendidateList model, HttpPostedFileBase files)
{
try
{
String fileName = "";
if (files != null)
{
fileName = Guid.NewGuid() + "_" + Path.GetFileName(files.FileName);
var path = Path.Combine(Server.MapPath("~/Logo/"), fileName);
files.SaveAs(path);
fileName = "http://newsletter.qendidate.com/Logo/" + fileName;
}
qendidateList data = null;
if (ModelState.IsValid)
{
data = db.qendidateLists.Where(ex => ex.qenID == model.qenID).FirstOrDefault();
if (data != null)
{
data.dataIsUpdated = BaseUtil.GetCurrentDateTime();
data.qenEmail = model.qenEmail;
data.City = model.City;
data.country = model.country;
data.state = model.state;
data.zipCode = model.zipCode;
data.latitude = model.latitude;
data.longitude = model.longitude;
data.dob = model.dob;
data.streetNo = model.streetNo;
data.qenAddress = model.qenAddress;
data.qenName = model.qenName;
data.qenNationality = model.qenNationality;
data.qenPassport = model.qenPassport;
data.qenLinkdInUrl = model.qenLinkdInUrl;
data.qenPhone = model.qenPhone;
data.genderID = model.genderID;
if (fileName != "")
{
data.qenImage = fileName;
}
db.SaveChanges();
}
else
{
model.qenImage = fileName;
db.qendidateLists.Add(model);
db.SaveChanges();
}
}
return(RedirectToAction("AcademicInfo", new { qenid = model.qenID }));
}
catch (Exception ex)
{
TempData["msg"] = ex.Message.ToString();
app_error_log oapp_error_log = new app_error_log();
oapp_error_log.user_id = Convert.ToInt32(model.qenID);
oapp_error_log.error_message = ex.Message.ToString();
oapp_error_log.ApplicationName = "NewsLetter";
oapp_error_log.created_date = DateTime.Now;
db.app_error_log.Add(oapp_error_log);
db.SaveChanges();
return(RedirectToAction("Error"));
}
}
