public void Save(ApprovalLevelAssignment approval, int userid) { //if(approval.Id == 0) //{ // approval.CreatedBy = userid.ToString(); // approval.CreationDate = DateTime.Now; // _dbContext.Add(approval); //} //else //{ // approval.ModifiedBy = userid.ToString(); // approval.ModifiedDate = DateTime.Now; // _dbContext.Entry(approval).State = EntityState.Modified; //} //_dbContext.SaveChanges(); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "[dbo].[spApprovalLevelAssignment]"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Id", approval.Id); cmd.Parameters.AddWithValue("@EmployeeId", approval.Employee.Id); cmd.Parameters.AddWithValue("@FirstApproval", approval.FirstApproval.Id); if (approval.IsWithSecondApproval) { cmd.Parameters.AddWithValue("@SecondApproval", approval.SecondApproval.Id); } cmd.Parameters.AddWithValue("@CreatedBy", userid); cmd.Parameters.AddWithValue("@ModifiedBy", userid); cmd.Parameters.AddWithValue("@IsWithSecondApproval", approval.IsWithSecondApproval ? 1 : 0); cmd.Parameters.AddWithValue("@QueryType", approval.Id == 0 ? 1 : 2); var result = SCObjects.ExecuteNonQuery(cmd, UserConnectionString); }
public IActionResult Save(ApprovalLevelAssignViewModel model) { var userId = int.Parse(HttpContext.Session.GetString("UserId")); if (model.ApprovalLevel != null) { var approvalLevel = new ApprovalLevelAssignment { Id = model.ApprovalLevel.Id, Employee = _Services.GetAccountById(model.ApprovalLevel.EmployeeId), FirstApproval = _Services.GetAccountById(model.ApprovalLevel.FirstApprovalId), SecondApproval = model.ApprovalLevel.IsWithSecondApproval == "on" ? _Services.GetAccountById(model.ApprovalLevel.SecondApprovalId) : null, IsWithSecondApproval = model.ApprovalLevel.IsWithSecondApproval == "on" ? true : false }; _Services.Save(approvalLevel, userId); return(RedirectToAction("Index")); } else { return(RedirectToAction("Index")); } }