public int InsertUser(Core.Users.User user)
{
try
{
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var param = new DynamicParameters();
param.Add("@Id", user.Id);
param.Add("@DisplayName", user.DisplayName);
param.Add("@Name", user.Name);
param.Add("@Trigram", user.Trigram);
param.Add("@ManagerId", user.ManagerId);
param.Add("@Email", user.Email);
param.Add("@IsExternal", user.IsExternal);
param.Add("@IsPresenter", user.IsPresenter);
var result = con.Execute("InsertUpdateUser", param, sqltrans, 0, System.Data.CommandType.StoredProcedure);
if (result > 0)
{
sqltrans.Commit();
}
else
{
sqltrans.Rollback();
}
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public int DeleteUser(Core.Users.User User)
{
try
{
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var paramUserCalendar = new DynamicParameters();
string sql = "DELETE FROM Users WHERE Id = " + User.Id;
var resultUser = con.Execute(sql, null, sqltrans, 0, System.Data.CommandType.Text);
if (resultUser > 0)
{
sqltrans.Commit();
}
else
{
sqltrans.Rollback();
}
return(resultUser);
}
}
catch (Exception ex)
{
throw ex;
}
}