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