public IActionResult Save(int id, int employeeid)
{
var userId = int.Parse(HttpContext.Session.GetString("UserId"));
var item = new RecommendationAssignment
{
Id = 0,
Employee = _Services.GetAccountById(employeeid),
Recommender = _Services.GetAccountById(id),
};
_Services.Save(item, userId);
return(RedirectToAction("Assign", new { id = id }));
}
public void Save(RecommendationAssignment item, int userid)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Id", item.Id);
cmd.Parameters.AddWithValue("@EmployeeId", item.Employee.Id);
cmd.Parameters.AddWithValue("@RecommenderId", item.Recommender.Id);
cmd.Parameters.AddWithValue("@CreatedBy", userid);
cmd.Parameters.AddWithValue("@ModifiedBy", userid);
cmd.Parameters.AddWithValue("@QueryType", item.Id == 0 ? 2 : 3);
var result = SCObjects.ExecuteNonQuery(cmd, UserConnectionString);
}
