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