public void Insert(KeyResultArea entity)
{
if (entity != null)
{
Collection.InsertOne(entity);
}
}
public IActionResult Save(KeyResultAreaIndexViewModel model)
{
var UserId = HttpContext.Session.GetString("UserId");
if (ModelState.IsValid)
{
var item = new KeyResultArea
{
Id = model.Id,
Title = model.Title,
Description = model.Description,
Weight = 100
};
if (model.Id == 0)
{
item.CreatedBy = UserId;
item.CreationDate = DateTime.Now;
_Services.Add(item);
}
else
{
item.ModifiedBy = UserId;
item.ModifiedDate = DateTime.Now;
_Services.Update(item);
}
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("Index", model));
}
}
public async Task <KeyResultArea> Update(ObjectId Id, KeyResultArea entity)
{
var filter = Builders <KeyResultArea> .Filter.Where(r => r.Id == Id);
var update = new BsonDocument("$set", entity.ToBsonDocument());
var result = await Collection.FindOneAndUpdateAsync(filter, update, options : new FindOneAndUpdateOptions <KeyResultArea> {
ReturnDocument = ReturnDocument.After
});
return(result);
}
public static KeyResultArea SetActive(this KeyResultArea resultArea)
{
if ((resultArea.Status.Hod.HasValue && resultArea.Status.Hod.Value) && (resultArea.Status.Employee.HasValue && resultArea.Status.Employee.Value) && (resultArea.Status.IsAccepted.HasValue && resultArea.Status.IsAccepted.Value))
{
resultArea.IsActive = true;
resultArea.Approved = true;
}
else
{
resultArea.IsActive = false;
resultArea.Approved = false;
}
return(resultArea);
}
public KeyResultArea GetKeyResultAreaByHeaderId(int headerid)
{
var result = _dbContext.RatingKeySuccessAreas
.Include(a => a.RatingHeader)
.Include(a => a.KeyResultArea)
.FirstOrDefault(a => a.RatingHeader.Id == headerid);
var item = new KeyResultArea
{
Id = result.KeyResultArea.Id,
Title = result.KeyResultArea.Title,
Description = result.KeyResultArea.Description,
Weight = result.KeyResultArea.Weight,
};
return(item);
}
public async Task <KeyResultArea> DeleteKeyOutcome(ObjectId id, KeyResultArea entity)
{
if (id != null)
{
var keyoutcome = entity.keyOutcomes.FirstOrDefault(a => a.Id == id);
var filter = Builders <KeyResultArea> .Filter.Eq("keyOutcomes.Id", id);
var update = Builders <KeyResultArea> .Update.Pull("keyOutcomes", keyoutcome);
var result = await Collection.FindOneAndUpdateAsync <KeyResultArea>(filter, update, options : new FindOneAndUpdateOptions <KeyResultArea> {
ReturnDocument = ReturnDocument.After
});
return(result);
}
return(null);
}
public IEnumerable <KeyResultArea> GetAvailableKRA(int employeeid)
{
string sql = string.Format(@"SELECT * FROM [dbo].[fnAvailableKRALookup]({0}) [fakl]", employeeid.ToString());
DataTable dt = SCObjects.LoadDataTable(sql, UserConnectionString);
List <KeyResultArea> items = new List <KeyResultArea>();
if (dt != null)
{
foreach (DataRow dr in dt.Rows)
{
var item = new KeyResultArea
{
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);
}
public void Update(KeyResultArea keyResultArea)
{
_dbContext.Entry(keyResultArea).State = EntityState.Modified;
_dbContext.SaveChanges();
}
public void Add(KeyResultArea keyResultArea)
{
_dbContext.Add(keyResultArea);
_dbContext.SaveChanges();
}
public void AddKeyOutcomes(KeyResultArea entity)
{
Collection.InsertOne(entity);
}
public async void Delete(KeyResultArea entity)
{
await Collection.FindOneAndDeleteAsync(Builders <KeyResultArea> .Filter.Where(r => r == entity));
}
