public PersonalRoleCard()
{
ID = Guid.NewGuid();
WorkingType = new WorkingType();
WorkingTypeID = WorkingType.ID.Value;
Login = "";
PassWord = "";
TelegramID = null;
FullName = "_.";
FirstName = "";
LastName = "";
isAdmin = false;
isEditingNow = false;
HasValue = true;
}
public PersonalRoleCard(Guid id)
{
try
{
using (var con = new SqlConnection(SystemSingleton.Configuration.ConnectionString))
{
SystemSingleton.Configuration.SqlConnections.Add(con);
using (var command = new SqlCommand(SqlCommands.LoadPersonalRoleCommand, con))
{
command.Parameters.Add("@RoleID", SqlDbType.UniqueIdentifier);
command.Parameters["@RoleID"].Value = id;
EnvironmentHelper.SendLogSQL(command.CommandText);
con.Open();
using (var reader = command.ExecuteReader())
{
if (reader.Read())
{
ID = id;
Login = reader.GetString(1);
PassWord = reader.GetString(2);
TelegramID = (reader.GetInt64(3) == 0) ? (long?)null : reader.GetInt64(3);
FullName = reader.GetString(4);
FirstName = reader.GetString(5);
LastName = reader.GetString(6);
isAdmin = reader.GetBoolean(7);
WorkingTypeID = reader.GetGuid(8);
isEditingNow = reader.GetBoolean(9);
HasValue = true;
WorkingType = new WorkingType(WorkingTypeID);
}
else
{
EnvironmentHelper.SendDialogBox(
(string)SystemSingleton.Configuration.mainWindow.FindResource("m_UserNotFound") + "\n\n" + id.ToString(),
"Role Error"
);
HasValue = false;
}
}
con.Close();
}
}
}
catch (Exception ex)
{
EnvironmentHelper.SendErrorDialogBox(ex.Message, "SQL Error", ex.StackTrace);
}
}