// GET: HRMS_TRAINING_SKILLSET/Delete/5
//public ActionResult Delete(long? id)
//{
// if (id == null)
// {
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
// }
// HRMS_TRAINING_SKILLSET hRMS_TRAINING_SKILLSET = db.HRMS_TRAINING_SKILLSET.Find(id);
// if (hRMS_TRAINING_SKILLSET == null)
// {
// return HttpNotFound();
// }
// return View(hRMS_TRAINING_SKILLSET);
//}
// POST: HRMS_TRAINING_SKILLSET/Delete/5
//[HttpPost, ActionName("Delete")]
//[ValidateAntiForgeryToken]
//public ActionResult DeleteConfirmed(long id)
//{
// HRMS_TRAINING_SKILLSET hRMS_TRAINING_SKILLSET = db.HRMS_TRAINING_SKILLSET.Find(id);
// long P_id = hRMS_TRAINING_SKILLSET.ProgDetail_ID;
// db.HRMS_TRAINING_SKILLSET.Remove(hRMS_TRAINING_SKILLSET);
// db.SaveChanges();
// if (!db.HRMS_TRAINING_SKILLSET.Where(x=>x.ProgDetail_ID==P_id).Any())
// {
// HRMS_ProgramDetail hRMS_ProgramDetaill = db.HRMS_ProgramDetail.Find(P_id);
// if (hRMS_ProgramDetaill.Skill == true)
// {
// hRMS_ProgramDetaill.Skill = false;
// db.Entry(hRMS_ProgramDetaill).State = EntityState.Modified;
// db.SaveChanges();
// }
// }
// return RedirectToAction("Index1");
//}
public bool Delete(long id)
{
HRMS_TRAINING_SKILLSET hRMS_TRAINING_SKILLSET = db.HRMS_TRAINING_SKILLSET.Find(id);
if (hRMS_TRAINING_SKILLSET != null)
{
long P_id = hRMS_TRAINING_SKILLSET.ProgDetail_ID;
db.HRMS_TRAINING_SKILLSET.Remove(hRMS_TRAINING_SKILLSET);
db.SaveChanges();
//ViewBag.Status = "Skill Deleted!!!";
if (!db.HRMS_TRAINING_SKILLSET.Where(x => x.ProgDetail_ID == P_id).Any())
{
HRMS_ProgramDetail hRMS_ProgramDetaill = db.HRMS_ProgramDetail.Find(P_id);
if (hRMS_ProgramDetaill.Skill == true)
{
hRMS_ProgramDetaill.Skill = false;
db.Entry(hRMS_ProgramDetaill).State = EntityState.Modified;
db.SaveChanges();
}
}
return(true);
}
else
{
return(false);
}
}
public ActionResult Edit([Bind(Include = "MaterialSet_ID,ProgDet_ID,Material_ID,Material_Name,Bud_Act,MaterialSet_Qty,MaterialSet_Rate,MaterialSet_Amt")] HRMS_TRAINING_MATERIALSET hRMS_TRAINING_MATERIALSET)
{
if (ModelState.IsValid)
{
HRMS_ProgramDetail hRMS_ProgramDetaill = db.HRMS_ProgramDetail.Find(hRMS_TRAINING_MATERIALSET.ProgDet_ID);
long b = Convert.ToInt64(Request["M_id"]);
HRMS_TRAINING_MATERIAL_MS hRMS_TRAINING_MATERIAL_MS = db.HRMS_TRAINING_MATERIAL_MS.Find(b);
hRMS_TRAINING_MATERIALSET.Material_ID = b;
hRMS_TRAINING_MATERIALSET.Material_Name = hRMS_TRAINING_MATERIAL_MS.Material_Name;
hRMS_TRAINING_MATERIALSET.MaterialSet_Qty = Convert.ToInt64(Request["M_qty"]);
hRMS_TRAINING_MATERIALSET.MaterialSet_Rate = Convert.ToDecimal(Request["M_rate"]);
hRMS_TRAINING_MATERIALSET.MaterialSet_Amt = Convert.ToDecimal(Request["M_amt"]);
db.Entry(hRMS_TRAINING_MATERIALSET).State = EntityState.Modified;
db.SaveChanges();
decimal total = GetTotalRate(hRMS_ProgramDetaill.ID);
if (hRMS_ProgramDetaill.Program_Amount != total)
{
hRMS_ProgramDetaill.Program_Amount = total;
db.Entry(hRMS_ProgramDetaill).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index1"));
}
//ViewBag.ProgDet_ID = new SelectList(db.HRMS_ProgramDetail, "ID", "ProgramName", hRMS_TRAINING_MATERIALSET.ProgDet_ID);
//ViewBag.Material_ID = new SelectList(db.HRMS_TRAINING_MATERIAL_MS, "Material_ID", "Material_Name", hRMS_TRAINING_MATERIALSET.Material_ID);
return(View(hRMS_TRAINING_MATERIALSET));
}
//// GET: HRMS_TRAINING_MATERIALSET/Delete/5
//public ActionResult Delete(long? id)
//{
// if (id == null)
// {
// return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
// }
// HRMS_TRAINING_MATERIALSET hRMS_TRAINING_MATERIALSET = db.HRMS_TRAINING_MATERIALSET.Find(id);
// if (hRMS_TRAINING_MATERIALSET == null)
// {
// return HttpNotFound();
// }
// return View(hRMS_TRAINING_MATERIALSET);
//}
//// POST: HRMS_TRAINING_MATERIALSET/Delete/5
//[HttpPost, ActionName("Delete")]
//[ValidateAntiForgeryToken]
//public ActionResult DeleteConfirmed(long id)
//{
// HRMS_TRAINING_MATERIALSET hRMS_TRAINING_MATERIALSET = db.HRMS_TRAINING_MATERIALSET.Find(id);
// db.HRMS_TRAINING_MATERIALSET.Remove(hRMS_TRAINING_MATERIALSET);
// db.SaveChanges();
// return RedirectToAction("Index");
//}
public bool Delete(long id)
{
HRMS_TRAINING_MATERIALSET hRMS_TRAINING_MATERIALSET = db.HRMS_TRAINING_MATERIALSET.Find(id);
if (hRMS_TRAINING_MATERIALSET != null)
{
long P_id = hRMS_TRAINING_MATERIALSET.ProgDet_ID;
db.HRMS_TRAINING_MATERIALSET.Remove(hRMS_TRAINING_MATERIALSET);
db.SaveChanges();
HRMS_ProgramDetail hRMS_ProgramDetaill = db.HRMS_ProgramDetail.Find(P_id);
if (!db.HRMS_TRAINING_MATERIALSET.Where(x => x.ProgDet_ID == P_id).Any())
{
if (hRMS_ProgramDetaill.Material == true)
{
hRMS_ProgramDetaill.Material = false;
db.Entry(hRMS_ProgramDetaill).State = EntityState.Modified;
db.SaveChanges();
}
}
decimal total = GetTotalRate(hRMS_ProgramDetaill.ID);
if (hRMS_ProgramDetaill.Program_Amount != total)
{
hRMS_ProgramDetaill.Program_Amount = total;
db.Entry(hRMS_ProgramDetaill).State = EntityState.Modified;
db.SaveChanges();
}
return(true);
}
else
{
return(false);
}
}
//[ValidateAntiForgeryToken]
public JsonResult Create(TrainingProgramCommon hRMS_ProgramDetail)
{
HRMS_ProgramDetail obj = hRMS_ProgramDetail.ProDetail;
if (obj.ToDate < obj.FromDate)
{
var msg = "ToDate must be greater than FromDate!";
return(Json(msg, JsonRequestBehavior.AllowGet));
}
else
{
db.HRMS_ProgramDetail.Add(obj);
db.SaveChanges();
ViewBag.msg = "Program Added Succesfully! Now Add Faculty!";
var ID = db.HRMS_ProgramDetail.Where(x => x.TrainingID == obj.TrainingID).Select(x => x.ID).FirstOrDefault();
//update in training request table (programFlag)
HRMS_Training_Request_Application req = db.HRMS_Training_Request_Application.Find(obj.TrainingID);
req.ProgramFlag = 1; //admin can only edit program detail
db.Entry(req).State = EntityState.Modified;
db.SaveChanges();
return(Json(ID, JsonRequestBehavior.AllowGet));
//return RedirectToAction("Index");
}
}
public ActionResult DeleteConfirmed(long id)
{
HRMS_ProgramDetail hRMS_ProgramDetail = db.HRMS_ProgramDetail.Find(id);
db.HRMS_ProgramDetail.Remove(hRMS_ProgramDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
// POST: TrainingProgramDetail/Edit/5
// To protect from overposting attacks, please enable the specific properties you want to bind to, for
// more details see https://go.microsoft.com/fwlink/?LinkId=317598.
//[HttpPost]
//[ValidateAntiForgeryToken]
//public ActionResult Edit([Bind(Include = "ID,TransactionDate,TrainingID,ProgramName,Subject,FromDate,ToDate,FromTime,ToTime,TrainingType,ProgramType,SubjectType,Type,ProgramMode,Venue,Budget,Address,City,BenefitsToOrg,Remarks,RatingMethod,TrainingStatus,CompletedBy,CompleteDate,RemarksOther,Flag")] HRMS_ProgramDetail hRMS_ProgramDetail)
//{
// if (ModelState.IsValid)
// {
// db.Entry(hRMS_ProgramDetail).State = EntityState.Modified;
// db.SaveChanges();
// return RedirectToAction("Index");
// }
// ViewBag.TrainingID = new SelectList(db.HRMS_Training_Request_Application, "ApplicationId", "Training_Name", hRMS_ProgramDetail.TrainingID);
// return View(hRMS_ProgramDetail);
//}
// GET: TrainingProgramDetail/Delete/5
public ActionResult Delete(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HRMS_ProgramDetail hRMS_ProgramDetail = db.HRMS_ProgramDetail.Find(id);
if (hRMS_ProgramDetail == null)
{
return(HttpNotFound());
}
return(View(hRMS_ProgramDetail));
}
// GET: TrainingProgramDetail/Create
public ActionResult Create(long?id)
{
HRMS_ProgramDetail obj = new HRMS_ProgramDetail();
obj.TransactionDate = DateTime.Now;
obj.TrainingID = id.Value;
TrainingProgramCommon O = new TrainingProgramCommon();
O.ProDetail = obj;
//ViewBag.TrainingID = new SelectList(db.HRMS_Training_Request_Application.Where(x => x.ApplicationId == id.Value), "ApplicationId", "Training_Name");
return(View(O));
}
public ActionResult EditEmployeeSelection(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//TrainingEmployeeSelection trainingEmployeeSelection = new TrainingEmployeeSelection();
HRMS_ProgramDetail programDetail = db.HRMS_ProgramDetail.Find(id);
//List< HRMS_TrainingApproval> employeeList = db.HRMS_TrainingApproval.Where(rec=>rec.Program_ID == id).ToList();
if (programDetail == null)
{
return(HttpNotFound());
}
//trainingEmployeeSelection.programDetail = programDetail;
ViewBag.ID = programDetail.ID;
ViewBag.ProgramName = programDetail.ProgramName;
ViewBag.ProgramType = programDetail.ProgramType;
ViewBag.TrainingType = programDetail.TrainingType;
ViewBag.FromDate = programDetail.FromDate;
ViewBag.ToDate = programDetail.ToDate;
ViewBag.FromTime = programDetail.FromTime;
ViewBag.ToTime = programDetail.ToTime;
ViewBag.TransactionDate = programDetail.TransactionDate;
HRMS_TrainingApproval TrainingApproval = new HRMS_TrainingApproval();
TrainingApproval.FromDate = programDetail.FromDate;
TrainingApproval.ToDate = programDetail.ToDate;
TrainingApproval.Program_ID = programDetail.ID;
TrainingApproval.FromTime = programDetail.FromTime;
TrainingApproval.ToTime = programDetail.ToTime;
//trainingEmployeeSelection.employeeSelection = TrainingApproval;
//if (employeeList != null)
//{
// trainingEmployeeSelection.employeeDataList = employeeList;
//}
return(View(TrainingApproval));
}
// GET: TrainingProgramDetail/Details/5
public ActionResult Details(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HRMS_ProgramDetail hRMS_ProgramDetail = db.HRMS_ProgramDetail.Where(x => x.TrainingID == id.Value).FirstOrDefault();
if (hRMS_ProgramDetail == null)
{
return(HttpNotFound());
}
TrainingProgramCommon obj = new TrainingProgramCommon();
obj.ProDetail = hRMS_ProgramDetail;
return(View(obj));
}
// GET: HRMS_TRAINING_MATERIALSET/Create
public ActionResult Create(long?id)
{
ViewBag.ProgDet_ID = new SelectList(db.HRMS_ProgramDetail, "ID", "ProgramName");
ViewBag.Material_ID = new SelectList(db.HRMS_TRAINING_MATERIAL_MS, "Material_ID", "Material_Name");
HRMS_ProgramDetail hRMS_ProgramDetail1 = db.HRMS_ProgramDetail.Find(id);
HRMS_TRAINING_MATERIALSET hRMS_TRAINING_MATERIALSET1 = new HRMS_TRAINING_MATERIALSET();
List <HRMS_TRAINING_MATERIALSET> hRMS_TRAINING_MATERIALSET3 = db.HRMS_TRAINING_MATERIALSET.Where(x => x.ProgDet_ID == id).ToList();
dynamic MultiView = new ExpandoObject();
MultiView.hRMS_ProgramDetail = hRMS_ProgramDetail1;
MultiView.hRMS_TRAINING_MATERIALSET = hRMS_TRAINING_MATERIALSET1;
MultiView.hRMS_TRAINING_MATERIALSET4 = hRMS_TRAINING_MATERIALSET3;
return(View("Create", MultiView));
//return View();
}
public ActionResult View(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HRMS_ProgramDetail programDetail = db.HRMS_ProgramDetail.Find(id);
if (programDetail == null)
{
return(HttpNotFound());
}
ViewBag.ID = programDetail.ID;
ViewBag.ProgramName = programDetail.ProgramName;
ViewBag.ProgramType = programDetail.ProgramType;
ViewBag.TrainingType = programDetail.TrainingType;
ViewBag.FromDate = programDetail.FromDate;
ViewBag.ToDate = programDetail.ToDate;
ViewBag.FromTime = programDetail.FromTime;
ViewBag.ToTime = programDetail.ToTime;
ViewBag.TransactionDate = programDetail.TransactionDate;
HRMS_TrainingApproval TrainingApproval = new HRMS_TrainingApproval();
TrainingApproval.FromDate = programDetail.FromDate;
TrainingApproval.ToDate = programDetail.ToDate;
TrainingApproval.Program_ID = programDetail.ID;
TrainingApproval.FromTime = programDetail.FromTime;
TrainingApproval.ToTime = programDetail.ToTime;
return(View(TrainingApproval));
}
// GET: TrainingProgramDetail/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HRMS_ProgramDetail hRMS_ProgramDetail = db.HRMS_ProgramDetail.Where(x => x.TrainingID == id.Value).FirstOrDefault();
//hRMS_ProgramDetail.FromTime =y;
if (hRMS_ProgramDetail == null)
{
return(HttpNotFound());
}
TrainingProgramCommon obj = new TrainingProgramCommon();
obj.ProDetail = hRMS_ProgramDetail;
//ViewBag.TrainingID = new SelectList(db.HRMS_Training_Request_Application, "ApplicationId", "Training_Name", hRMS_ProgramDetail.TrainingID);
return(View(obj));
}
//[ValidateAntiForgeryToken]
public JsonResult Edit(TrainingProgramCommon hRMS_ProgramDetail)
{
HRMS_ProgramDetail obj = hRMS_ProgramDetail.ProDetail;
if (obj.Extra == "Hello")
{
var msg = "Sorry";
return(Json(msg, JsonRequestBehavior.AllowGet));
}
if (obj.ToDate < obj.FromDate)
{
var msg = "ToDate must be greater than FromDate!";
return(Json(msg, JsonRequestBehavior.AllowGet));
}
else
{
if (obj.TrainingStatus == "Completed")
{
HRMS_Training_Request_Application req = db.HRMS_Training_Request_Application.Where(x => x.ApplicationId == obj.TrainingID).FirstOrDefault();
req.ProgramFlag = 2; //completed
db.Entry(req).State = EntityState.Modified;
db.SaveChanges();
}
if (obj.TrainingStatus == "Cancel")
{
HRMS_Training_Request_Application req = db.HRMS_Training_Request_Application.Where(x => x.ApplicationId == obj.TrainingID).FirstOrDefault();
req.ProgramFlag = 3; //Cancel
db.Entry(req).State = EntityState.Modified;
db.SaveChanges();
}
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
var msg = "Done";
return(Json(msg, JsonRequestBehavior.AllowGet));
}
}
public ActionResult EmailNotification(IEnumerable <string> ListOfEmp)
{
long programID = Convert.ToInt64(TempData["Pro_ID"]);
if (ListOfEmp == null)
{
TempData["Error"] = "Please!Select atleast one employee!";
return(RedirectToAction("Index", new { id = programID }));
}
else
{
HRMS_ProgramDetail objj = db.HRMS_ProgramDetail.Where(x => x.ID == programID).FirstOrDefault();
string ProgramName = objj.ProgramName;
string address;
if (objj.Venue == "Internal")
{
address = "On Company Location";
}
else
{
address = objj.Address;
}
foreach (var item in ListOfEmp.ToList())
{
//time and date
long EmpID = db.Accounts.Where(x => x.UserName == item).Select(x => x.ID).FirstOrDefault();
HRMS_TrainingApproval obj = db.HRMS_TrainingApproval.Where(x => x.Program_ID == programID && x.EMP_ID == EmpID).FirstOrDefault();
//sending Email
MailMessage mail = new MailMessage();
//mail.To = accounts.UserName;
mail.To.Add(item);
mail.From = new MailAddress("*****@*****.**");
mail.Subject = "Training Schedule";
string htmlString = @"<html>
<body>
<br><br><br>
<p><i>Regards,</i><br><b>Team HRMS<b></p>
</body>
</html>
";
//mail.Body = "password:"******"<html>
<b>Program Name : <b>
</html>
" + ProgramName +
@"<html>
<br>
<b>From Date : <b>
</html>
" + obj.FromDate?.ToShortDateString() +
@"<html>
<br>
<b>To Date : <b>
</html>
" + obj.ToDate?.ToShortDateString() +
@"<html>
<br>
<b>From Time : <b>
</html>
" + obj.FromTime +
@"<html>
<br>
<b>To Time : <b>
</html>
" + obj.ToTime +
@"<html>
<br>
<b>Venue : <b>
</html>
" + address +
htmlString;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
// smtp.UseDefaultCredentials = false;
smtp.UseDefaultCredentials = true;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Aniket@Vikalp"); // Enter seders User name and password
smtp.EnableSsl = true;
smtp.Send(mail);
//update email flag
obj.IsEmailSent = 1; //email sent
db.Entry(obj).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index", "TrainingApproval"));
}
}
public ActionResult Create([Bind(Include = "MaterialSet_ID,ProgDet_ID,Material_ID,Material_Name,Bud_Act,MaterialSet_Qty,MaterialSet_Rate,MaterialSet_Amt")] HRMS_TRAINING_MATERIALSET hRMS_TRAINING_MATERIALSET)
{
ViewBag.ProgDet_ID = new SelectList(db.HRMS_ProgramDetail, "ID", "ProgramName", hRMS_TRAINING_MATERIALSET.ProgDet_ID);
ViewBag.Material_ID = new SelectList(db.HRMS_TRAINING_MATERIAL_MS, "Material_ID", "Material_Name", hRMS_TRAINING_MATERIALSET.Material_ID);
long id = Convert.ToInt64(Request["Prog_id"]);
HRMS_ProgramDetail hRMS_ProgramDetail1 = db.HRMS_ProgramDetail.Find(id);
HRMS_TRAINING_MATERIALSET hRMS_TRAINING_MATERIALSET1 = new HRMS_TRAINING_MATERIALSET();
List <HRMS_TRAINING_MATERIALSET> hRMS_TRAINING_MATERIALSET3 = db.HRMS_TRAINING_MATERIALSET.Where(x => x.ProgDet_ID == id).ToList();
dynamic MultiView = new ExpandoObject();
MultiView.hRMS_ProgramDetail = hRMS_ProgramDetail1;
MultiView.hRMS_TRAINING_MATERIALSET = hRMS_TRAINING_MATERIALSET1;
MultiView.hRMS_TRAINING_MATERIALSET4 = hRMS_TRAINING_MATERIALSET3;
if (ModelState.IsValid)
{
long a = Convert.ToInt64(Request["Prog_id"]);
long b = Convert.ToInt64(Request["M_id"]);
if (b != 0 && a != 0)
{
ViewBag.Status = "";
if (!db.HRMS_TRAINING_MATERIALSET.Where(x => x.ProgDet_ID == a && x.Material_ID == b).Any())
{
HRMS_ProgramDetail hRMS_ProgramDetaill = db.HRMS_ProgramDetail.Find(id);
HRMS_TRAINING_MATERIAL_MS hRMS_TRAINING_MATERIAL_MS = db.HRMS_TRAINING_MATERIAL_MS.Find(b);
hRMS_TRAINING_MATERIALSET.ProgDet_ID = a;
hRMS_TRAINING_MATERIALSET.Material_ID = b;
hRMS_TRAINING_MATERIALSET.Material_Name = hRMS_TRAINING_MATERIAL_MS.Material_Name;
hRMS_TRAINING_MATERIALSET.MaterialSet_Qty = Convert.ToInt64(Request["M_qty"]);
hRMS_TRAINING_MATERIALSET.MaterialSet_Rate = Convert.ToDecimal(Request["M_rate"]);
hRMS_TRAINING_MATERIALSET.MaterialSet_Amt = Convert.ToDecimal(Request["M_amt"]);
hRMS_TRAINING_MATERIALSET.Bud_Act = Convert.ToString(Request["Bud_Act"]);
db.HRMS_TRAINING_MATERIALSET.Add(hRMS_TRAINING_MATERIALSET);
db.SaveChanges();
decimal total = GetTotalRate(a);
if (hRMS_ProgramDetaill.Program_Amount != total)
{
hRMS_ProgramDetaill.Program_Amount = total;
db.Entry(hRMS_ProgramDetaill).State = EntityState.Modified;
db.SaveChanges();
}
if (hRMS_ProgramDetaill.Material == false)
{
hRMS_ProgramDetaill.Material = true;
db.Entry(hRMS_ProgramDetaill).State = EntityState.Modified;
db.SaveChanges();
}
HRMS_ProgramDetail hRMS_ProgramDetail11 = db.HRMS_ProgramDetail.Find(id);
HRMS_TRAINING_MATERIALSET hRMS_TRAINING_MATERIALSET11 = new HRMS_TRAINING_MATERIALSET();
List <HRMS_TRAINING_MATERIALSET> hRMS_TRAINING_MATERIALSET31 = db.HRMS_TRAINING_MATERIALSET.Where(x => x.ProgDet_ID == id).ToList();
MultiView = new ExpandoObject();
MultiView.hRMS_ProgramDetail = hRMS_ProgramDetail11;
MultiView.hRMS_TRAINING_MATERIALSET = hRMS_TRAINING_MATERIALSET11;
MultiView.hRMS_TRAINING_MATERIALSET4 = hRMS_TRAINING_MATERIALSET31;
ViewBag.Status = "New Material added successfully!!!";
return(View("Create", MultiView));
}
ViewBag.Status = "Material already assigned to this Program";
return(View("Create", MultiView));
}
}
return(View("Create", MultiView));
}
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));
}
//View Program
public ActionResult View(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HRMS_ProgramDetail obj = db.HRMS_ProgramDetail.Find(id.Value);
HRMS_TrainingApproval obj1 = new HRMS_TrainingApproval();
obj1.EMP_ID = Convert.ToInt64(Session["id"]);
HRMS_Emp_Details Detail = db.HRMS_Emp_Details.Where(x => x.EMP_ID == obj1.EMP_ID).FirstOrDefault();
obj1.Designation = Detail.Designation;
obj1.EmpDept = Detail.Department;
obj1.Program_ID = id.Value;
obj1.EmpName = Detail.First_Name + " " + Detail.Last_Name;
// obj1.HRMS_ProgramDetail.FromDate = obj.FromDate;
//readonly dropdown
ViewBag.Designation = new SelectList(db.HRMS_DESG_MS.Where(x => x.Desg_Id == obj1.Designation), "Desg_Id", "Desg_Name");
ViewBag.EmpDept = new SelectList(db.HRMS_DEPT.Where(x => x.Dept_Id == obj1.EmpDept), "Dept_Id", "Dept_Name");
ViewBag.Program_ID = new SelectList(db.HRMS_ProgramDetail.Where(x => x.ID == obj1.Program_ID), "ID", "ProgramName");
// ViewBag.xyz = new SelectList(db.HRMS_ProgramDetail.Where(x => x.ID == obj1.Program_ID), "FromDate", "FromDate");
obj1.FromDate = obj.FromDate;
obj1.ToDate = obj.ToDate;
obj1.FromTime = obj.FromTime;
obj1.ToTime = obj.ToTime;
//NoOfDays
TimeSpan?difference = obj.ToDate - obj.FromDate;
ViewBag.NoOfDays = difference.Value.TotalDays;
ViewBag.remarks = obj.Remarks;
//already Exist or completed
if (User.IsInRole("emp"))
{
bool IsExist = db.HRMS_TrainingApproval.Any(x => x.EMP_ID == obj1.EMP_ID && x.Program_ID == id.Value);
bool IsExist1 = db.HRMS_ProgramDetail.Any(x => x.ID == id.Value && x.TrainingStatus == "Completed");
if (IsExist || IsExist1)
{
ViewBag.exist = "Exist";
}
HRMS_TrainingApproval status = db.HRMS_TrainingApproval.Where(x => x.EMP_ID == obj1.EMP_ID && x.Program_ID == id.Value).FirstOrDefault();
if (status != null)
{
if (status.Status == 1)
{
ViewBag.msg = "Your Request is in Pending!";
}
else if (status.Status == 2)
{
ViewBag.msg = "Your Request is Approved!";
}
else if (status.Status == 3)
{
ViewBag.msg = "Your Request is Cancelled!";
}
}
}
return(View(obj1));
}
