protected void Page_Load(object sender, EventArgs e) { Page.Title = PagesTitles.ManagerCarView + BackendHelper.TagToValue("page_title_part"); OtherMethods.ActiveRightMenuStyleChanche("hlCars", this.Page); OtherMethods.ActiveRightMenuStyleChanche("hlSouls", this.Page); #region Блок доступа к странице var userInSession = (Users)Session["userinsession"]; var rolesList = Application["RolesList"] as List <Roles>; var currentRole = (Roles)rolesList.SingleOrDefault(u => u.Name.ToLower() == userInSession.Role.ToLower()); if (currentRole.PageCarView != 1) { Response.Redirect("~/Error.aspx?id=1"); } #endregion if (Page.Request.Params["id"] != null) { if (!IsPostBack) { var id = Convert.ToInt32(Page.Request.Params["id"]); var car = new Cars { ID = id }; car.GetById(); lblID.Text = car.ID.ToString(); var dm = new DataManager(); var driversForCarTable = dm.QueryWithReturnDataSet(String.Format("SELECT ID, FirstName, LastName, ThirdName FROM drivers WHERE CarID = {0}", id)); foreach (DataRow driver in driversForCarTable.Tables[0].Rows) { lblDrivers.Text += String.Format("<a href='DriversEdit.aspx?id={3}'>{0} {1}.{2}.</a> ", driver["FirstName"], driver["LastName"].ToString().Remove(1, driver["LastName"].ToString().Length - 1), driver["ThirdName"].ToString().Remove(1, driver["ThirdName"].ToString().Length - 1), driver["ID"]); } lblType.Text = CarsHelper.CarTypeToFullString(Convert.ToInt32(car.TypeID)); hfTypeID.Value = car.TypeID.ToString(); lblModel.Text = car.Model; lblNumber.Text = car.Number; lblCompanyName.Text = car.CompanyName; lblFirstName.Text = car.FirstName; lblLastName.Text = car.LastName; lblThirdName.Text = car.ThirdName; lblPassport.Text = car.PassportSeria + car.PassportNumber; lblPersonalNumber.Text = car.PersonalNumber; lblROVD.Text = car.ROVD; lblRegistrationAddress.Text = car.RegistrationAddress; lblValidity.Text = Convert.ToDateTime(car.Validity).ToString("dd-MM-yyyy"); lblBirthDay.Text = Convert.ToDateTime(car.BirthDay).ToString("dd-MM-yyyy"); lblDateOfIssue.Text = Convert.ToDateTime(car.DateOfIssue).ToString("dd-MM-yyyy"); } } }
public static string OldNewValueToRuss(string tableName, string propertyName, string value) { #region таблица заявок if (tableName == "tickets") { if (propertyName == "CourseRUR" || propertyName == "CourseUSD" || propertyName == "CourseEUR" || propertyName == "DeliveryCost" || propertyName == "AssessedCost" || propertyName == "AgreedCost" || propertyName == "ReceivedUSD" || propertyName == "ReceivedEUR" || propertyName == "ReceivedEUR" || propertyName == "ReceivedBLR" || propertyName == "GruzobozCost") { return(MoneyMethods.MoneySeparator(value)); } if (propertyName == "DriverID") { return(DriversHelper.DriverIDToFioToPrint(value)); } if (propertyName == "StatusIDOld" || propertyName == "StatusID") { return(OtherMethods.TicketStatusToText(value)); } if (propertyName == "CityID") { return(CityHelper.CityIDToCityNameWithotCustom(value)); } if (propertyName == "TrackIDUser") { return(OtherMethods.TrackToText(Convert.ToInt32(value))); } if (propertyName == "DeliveryDate") { return(value.Remove(value.Length - 8)); } if (propertyName == "Comment") { return(WebUtility.HtmlDecode(value)); } if (propertyName == "PrintNakl" || propertyName == "PrintNaklInMap" || propertyName == "IsExchange" || propertyName == "WithoutMoney" || propertyName == "CheckedOut" || propertyName == "Phoned") { return(value == "0" ? "нет" : "да"); } if (propertyName == "OvDateFrom" || propertyName == "OvDateTo") { return(String.IsNullOrEmpty(value) ? String.Empty : Convert.ToDateTime(value).ToString("HH:mm")); } } #endregion #region таблица пользователей if (tableName == "users") { if (propertyName == "SpecialClient" || propertyName == "IsCourse" || propertyName == "AllowApi") { return(value == "0" ? "нет" : "да"); } if (propertyName == "Status") { return(UsersHelper.UserStatusToText(Convert.ToInt32(value))); } if (propertyName == "Role") { return(UsersHelper.RoleToRuss(value)); } if (propertyName == "Discount") { return(String.Format("{0}%", value)); } if (propertyName == "Password") { return(String.Empty); } if (propertyName == "Validity" && value.Length >= 8) { return(value.Remove(value.Length - 8)); } if (propertyName == "BirthDay" && value.Length >= 8) { return(value.Remove(value.Length - 8)); } if (propertyName == "DateOfIssue" && value.Length >= 8) { return(value.Remove(value.Length - 8)); } } #endregion #region таблица грузов if (tableName == "goods") { if (propertyName == "Cost") { return(MoneyMethods.MoneySeparator(value)); } if (propertyName == "WithoutAkciza") { return(value == "0" ? "нет" : "да"); } } #endregion #region таблица профилей if (tableName == "usersprofiles") { if (propertyName == "StatusID") { return(UsersProfilesHelper.UserProfileStatusToText(Convert.ToInt32(value))); } } #endregion #region таблица водителй if (tableName == "drivers") { if (propertyName == "StatusID" && !String.IsNullOrEmpty(value)) { return(DriversHelper.DriverStatusToText(Convert.ToInt32(value))); } if (value.Length >= 8 && (propertyName == "DateOfIssue" || propertyName == "Validity" || propertyName == "BirthDay" || propertyName == "DriverPassportDateOfIssue" || propertyName == "DriverPassportValidity" || propertyName == "MedPolisDateOfIssue" || propertyName == "MedPolisValidity")) { return(value.Remove(value.Length - 8)); } } #endregion #region таблица авто if (tableName == "cars") { if (propertyName == "TypeID" && !String.IsNullOrEmpty(value)) { return(CarsHelper.CarTypeToFullString(Convert.ToInt32(value))); } } #endregion #region таблица категорий if (tableName == "category") { if (propertyName == "Name") { return(value); } } #endregion return(value); }