public static SignInView GetSignInView(DataRow row)
{
SignInView view = new SignInView();
view.UserId = Conversion.TryCastInteger(ConversionHelper.GetColumnValue(row, "user_id"));
view.Role = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "role"));
view.IsAdmin = Conversion.TryCastBoolean(ConversionHelper.GetColumnValue(row, "is_admin"));
view.IsSystem = Conversion.TryCastBoolean(ConversionHelper.GetColumnValue(row, "is_system"));
view.UserName = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "user_name"));
view.FullName = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "full_name"));
view.LogOnId = Conversion.TryCastInteger(ConversionHelper.GetColumnValue(row, "login_id"));
view.OfficeId = Conversion.TryCastInteger(ConversionHelper.GetColumnValue(row, "office_id"));
view.Culture = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "culture"));
view.Office = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "office"));
view.OfficeCode = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "office_code"));
view.OfficeName = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "office_name"));
view.Nickname = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "nick_name"));
view.RegistrationDate = Conversion.TryCastDate(ConversionHelper.GetColumnValue(row, "registration_date"));
view.RegistrationNumber = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "registration_number"));
view.PanNumber = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "pan_number"));
view.AddressLine1 = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "address_line_1"));
view.AddressLine2 = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "address_line_2"));
view.Street = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "street"));
view.City = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "city"));
view.State = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "state"));
view.ZipCode = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "zip_code"));
view.Country = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "country"));
view.Phone = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "phone"));
view.Fax = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "fax"));
view.Email = Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "email"));
view.Url = new Uri(Conversion.TryCastString(ConversionHelper.GetColumnValue(row, "url")), UriKind.RelativeOrAbsolute);
return view;
}
public static SignInView GetLastSignInView(string userName)
{
SignInView view = new SignInView();
const string sql = "SELECT * FROM office.sign_in_view WHERE user_name=@UserName;";
using (NpgsqlCommand command = new NpgsqlCommand(sql))
{
command.Parameters.AddWithValue("@UserName", userName);
using (DataTable table = DbOperations.GetDataTable(command))
{
if (table != null && table.Rows.Count.Equals(1))
{
view = GetSignInView(table.Rows[0]);
}
}
}
return view;
}