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