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);
}