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));
}
public ActionResult Data(long?id)
{
if (id != null)
{
HRMS_TRAINING_MATERIAL_MS obj = db.HRMS_TRAINING_MATERIAL_MS.Where(x => x.Material_ID == id.Value).FirstOrDefault();
if (obj != null)
{
var result = new { obj.Material_Name };
return(Json(result, JsonRequestBehavior.AllowGet));
}
}
return(Json(false, JsonRequestBehavior.AllowGet));
}
// GET: HRMS_TRAINING_MATERIAL_MS/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HRMS_TRAINING_MATERIAL_MS hRMS_TRAINING_MATERIAL_MS = db.HRMS_TRAINING_MATERIAL_MS.Find(id);
if (hRMS_TRAINING_MATERIAL_MS == null)
{
return(HttpNotFound());
}
return(View(hRMS_TRAINING_MATERIAL_MS));
}
public decimal GetDefaultRate(long?id)
{
if (id == 0)
{
return(0);
}
//checking for configuration
HRMS_TRAINING_MATERIAL_MS objl = db.HRMS_TRAINING_MATERIAL_MS.Where(x => x.Material_ID == id).FirstOrDefault();
//HRMS_EMP_GRA_POL obj1 = db.HRMS_EMP_GRA_POL.Where(x => x.Emp_ID == emp_id).FirstOrDefault();
//decimal val = db.HRMS_TRAVEL_MILEAGE_CONFIG.Where(x => x.Travel_Mileage_Emp_Grade.StartsWith(obj1.Gra_ID.ToString()) && x.Travel_Group == obj1.Pol_ID).Select(x => x.Travel_Mileage_Four).FirstOrDefault();
decimal Amount = objl.Material_Rate;
return(Amount);
}
// GET: HRMS_TRAINING_MATERIAL_MS/Delete/5
public bool Delete(long id)
{
HRMS_TRAINING_MATERIAL_MS employee_Personal_Detail = db.HRMS_TRAINING_MATERIAL_MS.Find(id);
if (employee_Personal_Detail != null)
{
db.HRMS_TRAINING_MATERIAL_MS.Remove(employee_Personal_Detail);
db.SaveChanges();
return(true);
}
else
{
return(false);
}
}
public ActionResult Edit([Bind(Include = "Material_ID,Material_Name,Material_Rate,Material_Remarks,Material_IsActive")] HRMS_TRAINING_MATERIAL_MS hRMS_TRAINING_MATERIAL_MS)
{
if (ModelState.IsValid)
{
ViewBag.Status = "";
var existData = db.HRMS_TRAINING_MATERIAL_MS.FirstOrDefault(rec => rec.Material_Name == hRMS_TRAINING_MATERIAL_MS.Material_Name && rec.Material_Rate == hRMS_TRAINING_MATERIAL_MS.Material_Rate && rec.Material_Remarks == hRMS_TRAINING_MATERIAL_MS.Material_Remarks && rec.Material_IsActive == hRMS_TRAINING_MATERIAL_MS.Material_IsActive && rec.Material_ID != hRMS_TRAINING_MATERIAL_MS.Material_ID);
if (existData == null)
{
db.Entry(hRMS_TRAINING_MATERIAL_MS).State = EntityState.Modified;
db.SaveChanges();
//ModelState.Clear();
ViewBag.Status = "Material updated successfully.";
return(View());
}
ViewBag.Status = "this Material is already exist !";
return(View());
}
return(View(hRMS_TRAINING_MATERIAL_MS));
}
public ActionResult Create([Bind(Include = "Material_ID,Material_Name,Material_Rate,Material_Remarks,Material_IsActive")] HRMS_TRAINING_MATERIAL_MS hRMS_TRAINING_MATERIAL_MS)
{
if (ModelState.IsValid)
{
ViewBag.Status = "";
var existData = db.HRMS_TRAINING_MATERIAL_MS.FirstOrDefault(rec => rec.Material_Name == hRMS_TRAINING_MATERIAL_MS.Material_Name);
if (existData == null)
{
db.HRMS_TRAINING_MATERIAL_MS.Add(hRMS_TRAINING_MATERIAL_MS);
db.SaveChanges();
ModelState.Clear();
ViewBag.Status = "New Material added successfully.";
return(View());
}
ViewBag.Status = "this Material is already exist !";
return(View());
}
return(View(hRMS_TRAINING_MATERIAL_MS));
}
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));
}
