public void SaveBehavioralFactor(BehavioralFactor behavioralFactor) { if (behavioralFactor.Id == 0) { _dbContext.Add(behavioralFactor); } else { _dbContext.Entry(behavioralFactor).State = EntityState.Modified; } _dbContext.SaveChanges(); }
public BehavioralFactor GetBehavioralFactorByHeaderId(int headerid) { var result = _dbContext.RatingBehavioralFactors .Include(a => a.BehavioralFactor) .Include(a => a.RatingHeader) .FirstOrDefault(a => a.RatingHeader.Id == headerid); var item = new BehavioralFactor { Id = result.BehavioralFactor.Id, Title = result.BehavioralFactor.Title, Description = result.BehavioralFactor.Description, Weight = result.BehavioralFactor.Weight }; return(item); }
public IActionResult SaveBehavioralFactor(BehavioralFactorIndexViewModel model) { if (ModelState.IsValid) { var item = new BehavioralFactor { Id = model.BehavioralFactor.Id, Title = model.BehavioralFactor.Title, Description = model.BehavioralFactor.Description, Weight = 100, Category = _BehavioralFactor.GetEmployeeCategoryById(model.BehavioralFactor.Category), CreatedBy = HttpContext.Session.GetString("UserId"), CreationDate = DateTime.Now, }; _BehavioralFactor.SaveBehavioralFactor(item); return(RedirectToAction("Index")); } else { return(RedirectToAction("Index", model)); } }
public IEnumerable <BehavioralFactor> GetAvailableBehavioral(int employeeid) { string sql = string.Format("SELECT * FROM [dbo].[fnAvailableBehavioralLookup]({0}) [fabl]", employeeid.ToString()); DataTable dt = SCObjects.LoadDataTable(sql, UserConnectionString); List <BehavioralFactor> items = new List <BehavioralFactor>(); if (dt != null) { foreach (DataRow dr in dt.Rows) { var item = new BehavioralFactor { Id = int.Parse(dr["Id"].ToString()), Title = dr["Title"].ToString(), Description = dr["Description"].ToString(), Weight = int.Parse(dr["Weight"].ToString()), }; items.Add(item); } } return(items); }