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);
}
