Esempio n. 1
0
        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;
        }
Esempio n. 2
0
        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;
        }