public ActionResult Index(ConsultInformation consInfo) { db.ConsultInformations.Add(new ConsultInformation { Name = consInfo.Name, Hours = consInfo.Hours, YearsOfEmployment = Convert.ToDateTime(consInfo.YearsOfEmployment.ToString("yyyy-MM-dd")) }); db.SaveChanges(); return(View()); }
public ActionResult Edit(ConsultInformation consInfo) { var editConsultant = db.ConsultInformations.Find(consInfo.Id); editConsultant.Hours = consInfo.Hours; editConsultant.Name = consInfo.Name; editConsultant.YearsOfEmployment = Convert.ToDateTime(consInfo.YearsOfEmployment.ToString("yyyy-MM-dd")); db.Entry(editConsultant).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); }
public JsonResult GetConsultants() { var BonusPott = 5000; ConsultInformation consult = new ConsultInformation(); List <ConsultInformation> list = new List <ConsultInformation>(); var consultants = db.ConsultInformations.ToList(); foreach (var item in consultants) { var editUser = db.ConsultInformations.Find(item.Id); editUser.Bonus = Convert.ToInt32(BonusPott * (((((DateTime.Now.Year - item.YearOfEmployment.Year) / 10m) + 1) * item.Hours) / CreditPoint())); db.Entry(editUser).State = EntityState.Modified; db.SaveChanges(); } return(Json(consultants, JsonRequestBehavior.AllowGet)); }