public User FdpUserSave(User userToAdd)
{
User retVal = new EmptyUser();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@CDSId", userToAdd.CDSId, DbType.String);
para.Add("@FullName", userToAdd.FullName, DbType.String);
para.Add("@Mail", userToAdd.Mail, DbType.String);
para.Add("@IsAdmin", userToAdd.IsAdmin, DbType.Boolean);
para.Add("@CreatorCDSId", CurrentCDSID, DbType.String);
var results = conn.Query<UserDataItem>("dbo.Fdp_User_Save", para, commandType: CommandType.StoredProcedure);
var enumerable = results as IList<UserDataItem> ?? results.ToList();
if (enumerable.Any()) {
retVal = enumerable.First().ToUser();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return retVal;
}
public User FdpUserUnSetAdministrator(User userToUnset)
{
User retVal = new EmptyUser();
using (var conn = DbHelper.GetDBConnection())
{
try
{
var para = new DynamicParameters();
para.Add("@CDSId", userToUnset.CDSId, DbType.String);
para.Add("@IsAdmin", false, DbType.Boolean);
para.Add("@UpdatedByCDSId", CurrentCDSID, DbType.String);
var results = conn.Query <UserDataItem>("dbo.Fdp_User_SetIsAdmin", para, commandType: CommandType.StoredProcedure);
var enumerable = results as IList <UserDataItem> ?? results.ToList();
if (enumerable.Any())
{
retVal = enumerable.First().ToUser();
}
}
catch (Exception ex)
{
Log.Error(ex);
throw;
}
}
return(retVal);
}
private void InitialiseMembers()
{
User = new EmptyUser();
IdentifierPrefix = "Page";
Programmes = Enumerable.Empty <Programme>();
}
private void InitialiseMembers()
{
User = new EmptyUser();
IdentifierPrefix = "Page";
Programmes = Enumerable.Empty<Programme>();
}
