public ActionResult Edit([Bind(Include = "Skill_ID,Skill_Name,Skill_Remark")] HRMS_TRAINING_SKILL_MS hRMS_TRAINING_SKILL_MS)
{
if (ModelState.IsValid)
{
ViewBag.Status = "";
var existData = db.HRMS_TRAINING_SKILL_MS.FirstOrDefault(rec => rec.Skill_Name == hRMS_TRAINING_SKILL_MS.Skill_Name && rec.Skill_Remark == hRMS_TRAINING_SKILL_MS.Skill_Remark && rec.Skill_Remark == hRMS_TRAINING_SKILL_MS.Skill_Remark && rec.Skill_ID != hRMS_TRAINING_SKILL_MS.Skill_ID);
if (existData == null)
{
//var ExistRemark = db.HRMS_TRAINING_SKILL_MS.FirstOrDefault(rec => rec.Skill_Remark == hRMS_TRAINING_SKILL_MS.Skill_Remark && rec.Skill_ID != hRMS_TRAINING_SKILL_MS.Skill_ID);
//if (ExistRemark == null)
//{
db.Entry(hRMS_TRAINING_SKILL_MS).State = EntityState.Modified;
db.SaveChanges();
//ModelState.Clear();
ViewBag.Status = "Skill Updateded succcessfully.";
return(View());
//}
//ViewBag.Status = "This Remark is Already Exist ! ";
//return View();
}
ViewBag.Status = "this Skill is already exist !";
return(View());
}
return(View(hRMS_TRAINING_SKILL_MS));
}
// GET: HRMS_TRAINING_SKILLSET
public ActionResult Data(long?id)
{
if (id != null)
{
HRMS_TRAINING_SKILL_MS obj = db.HRMS_TRAINING_SKILL_MS.Where(x => x.Skill_ID == id.Value).FirstOrDefault();
if (obj != null)
{
var result = new { obj.Skill_Name };
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
return(Json(false, JsonRequestBehavior.AllowGet));
}
// GET: HRMS_TRAINING_SKILL_MS/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HRMS_TRAINING_SKILL_MS hRMS_TRAINING_SKILL_MS = db.HRMS_TRAINING_SKILL_MS.Find(id);
if (hRMS_TRAINING_SKILL_MS == null)
{
return(HttpNotFound());
}
return(View(hRMS_TRAINING_SKILL_MS));
}
// GET: HRMS_TRAINING_SKILL_MS/Delete/5
public bool Delete(long id)
{
HRMS_TRAINING_SKILL_MS employee_Personal_Detail = db.HRMS_TRAINING_SKILL_MS.Find(id);
if (employee_Personal_Detail != null)
{
db.HRMS_TRAINING_SKILL_MS.Remove(employee_Personal_Detail);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public ActionResult Create([Bind(Include = "SkillSet_ID,ProgDetail_ID,Skill_ID")] HRMS_TRAINING_SKILLSET hRMS_TRAINING_SKILLSET)
{
ViewBag.ProgDetail_ID = new SelectList(db.HRMS_ProgramDetail, "ID", "ProgramName", hRMS_TRAINING_SKILLSET.ProgDetail_ID);
ViewBag.Skill_ID = new SelectList(db.HRMS_TRAINING_SKILL_MS, "Skill_ID", "Skill_Name", hRMS_TRAINING_SKILLSET.Skill_ID);
long id = Convert.ToInt64(Request["Prog_id"]);
HRMS_ProgramDetail hRMS_ProgramDetail1 = db.HRMS_ProgramDetail.Find(id);
HRMS_TRAINING_SKILLSET hRMS_TRAINING_SKILLSET1 = new HRMS_TRAINING_SKILLSET();
List <HRMS_TRAINING_SKILLSET> hRMS_TRAINING_SKILLSET3 = db.HRMS_TRAINING_SKILLSET.Where(x => x.ProgDetail_ID == id).ToList();
dynamic MultiView = new ExpandoObject();
MultiView.hRMS_ProgramDetail = hRMS_ProgramDetail1;
MultiView.hRMS_TRAINING_SKILLSET = hRMS_TRAINING_SKILLSET1;
MultiView.hRMS_TRAINING_SKILLSET4 = hRMS_TRAINING_SKILLSET3;
// return View("Create", MultiView);
if (ModelState.IsValid)
{
long a = Convert.ToInt64(Request["Prog_id"]);
long b = Convert.ToInt64(Request["S_id"]);
if (b != 0 && a != 0)
{
ViewBag.Status = "";
if (!db.HRMS_TRAINING_SKILLSET.Where(x => x.ProgDetail_ID == a && x.Skill_ID == b).Any())
{
HRMS_ProgramDetail hRMS_ProgramDetaill = db.HRMS_ProgramDetail.Find(id);
HRMS_TRAINING_SKILL_MS hRMS_TRAINING_SKILL_MS = db.HRMS_TRAINING_SKILL_MS.Find(b);
hRMS_TRAINING_SKILLSET.ProgDetail_ID = Convert.ToInt64(Request["Prog_id"]);
hRMS_TRAINING_SKILLSET.Skill_ID = Convert.ToInt64(Request["S_id"]);
hRMS_TRAINING_SKILLSET.Skill_Name = hRMS_TRAINING_SKILL_MS.Skill_Name;
db.HRMS_TRAINING_SKILLSET.Add(hRMS_TRAINING_SKILLSET);
db.SaveChanges();
if (hRMS_ProgramDetaill.Skill == false)
{
hRMS_ProgramDetaill.Skill = true;
db.Entry(hRMS_ProgramDetaill).State = EntityState.Modified;
db.SaveChanges();
}
HRMS_ProgramDetail hRMS_ProgramDetail11 = db.HRMS_ProgramDetail.Find(id);
HRMS_TRAINING_SKILLSET hRMS_TRAINING_SKILLSET11 = new HRMS_TRAINING_SKILLSET();
List <HRMS_TRAINING_SKILLSET> hRMS_TRAINING_SKILLSET31 = db.HRMS_TRAINING_SKILLSET.Where(x => x.ProgDetail_ID == id).ToList();
MultiView = new ExpandoObject();
MultiView.hRMS_ProgramDetail = hRMS_ProgramDetail11;
MultiView.hRMS_TRAINING_SKILLSET = hRMS_TRAINING_SKILLSET11;
MultiView.hRMS_TRAINING_SKILLSET4 = hRMS_TRAINING_SKILLSET31;
ViewBag.Status = "New skill added successfully!!!";
return(View("Create", MultiView));
}
ViewBag.Status = "Skill already assigned to this Program";
return(View("Create", MultiView));
}
//ViewBag.Status = "Please Filled proper Data";
//return RedirectToAction("Index");
}
//ViewBag.Status = "";
return(View("Create", MultiView));
}
