public void GetCityForAutocompliteJSON(string query, string appkey)
{
if (appkey == Globals.Settings.AppServiceSecureKey)
{
var js = new JavaScriptSerializer {
MaxJsonLength = Int32.MaxValue
};
var allCityFromApp = Application["CityList"] as List <City>;
var allCityList = new List <AllCityForAutocompliteResult>();
var coefficientDeviationCost = Convert.ToDouble(BackendHelper.TagToValue("coefficient_deviation_cost")); //множительный коэфициент добавочной стоимости отклонения от основного города
foreach (
City city in
allCityFromApp.Where(
u =>
((u.Name.ToLower()
.Replace("ё", "е")
.Replace("ъ", "ь")
.Trim()
.Contains(query.ToLower().Replace("ё", "е").Replace("ъ", "ь").Trim()) &&
u.Blocked == 0) ||
u.ID.ToString().Equals(query))
).OrderBy(u => u.Name).Take(250))
{
allCityList.Add(new AllCityForAutocompliteResult()
{
value = CityHelper.CityIDToAutocompleteString(city),
data = city.ID.ToString(),
cost = MoneyMethods.MoneySeparatorForCityTableView((city.DistanceFromCity * Convert.ToDecimal(coefficientDeviationCost)).ToString()),
deliverydate =
DistrictsHelper.DeliveryDateStringToRuss(DistrictsHelper.DeliveryDateString(city.DistrictID)),
deliveryterms =
DistrictsHelper.DeliveryTermsToRuss(DistrictsHelper.DeliveryTerms(city.DistrictID))
});
}
Context.Response.ContentType = "application/json; charset=UTF-8";
Context.Response.Write("{\"query\": \"Unit\",\"suggestions\": " + js.Serialize(allCityList) + "}");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = PagesTitles.ManagerUserTicketEditTitle + BackendHelper.TagToValue("page_title_part");
OtherMethods.ActiveRightMenuStyleChanche("hlTickets", this.Page);
Form.DefaultButton = btnCreate.UniqueID;
AppKey = Globals.Settings.AppServiceSecureKey;
FirstUserApiKey = Globals.Settings.FirstUserApiKey;
#region Блок доступа к странице
var userInSession = (Users)Session["userinsession"];
var rolesList = Application["RolesList"] as List <Roles>;
var currentRole = Role = (Roles)rolesList.SingleOrDefault(u => u.Name.ToLower() == userInSession.Role.ToLower());
if (currentRole.PageUserTicketEdit != 1)
{
Response.Redirect("~/Error.aspx?id=1");
}
#endregion
#region Блок доступа к данным на странице
IsVisibleUserProfileData = true;
IsVisibleUserAccountData = true;
if (currentRole.PageUserProfileView == 0)
{
IsVisibleUserProfileData = false;
}
if (currentRole.PageClientsView == 0)
{
IsVisibleUserAccountData = false;
}
trUserProfileData.Visible = IsVisibleUserProfileData;
trUserAccountData.Visible = IsVisibleUserAccountData;
#endregion
#region едирект на страницу всех заявок если заявки нет
if (Page.Request.Params["id"] == null || Page.Request.Params["id"] == String.Empty)
{
Page.Response.Redirect("~/ManagerUI/Menu/Tickets/UserTicketView.aspx");
}
#endregion
if (!IsPostBack)
{
#region Загрузка tickets по SecureID или FullSecureID. Метод на очистку.
DAL.DataBaseObjects.Tickets ticket;
if (Page.Request.Params["id"].Length > 7)
{
ticket = new DAL.DataBaseObjects.Tickets {
FullSecureID = Page.Request.Params["id"]
};
ticket.GetByFullSecureId();
}
else
{
ticket = new DAL.DataBaseObjects.Tickets {
SecureID = Page.Request.Params["id"]
};
ticket.GetBySecureId();
}
#endregion
#region Создание форм для груза
GoodsCount = GoodsHelper.GoodsCount(ticket.FullSecureID);
hfHowManyControls.Value = GoodsCount.ToString();
AddGodsInPanel(GoodsCount);
#endregion
#region Заполнение созданных формы
var goods = new Goods {
TicketFullSecureID = ticket.FullSecureID
};
var ds = goods.GetAllItems("ID", "ASC", "TicketFullSecureID");
var goodsIterator = 1;
foreach (DataRow row in ds.Tables[0].Rows)
{
var tbGoodsDescription = (TextBox)pnlBooks.FindControl("tbGoodsDescription" + goodsIterator);
var tbGoodsModel = (TextBox)pnlBooks.FindControl("tbGoodsModel" + goodsIterator);
var tbGoodsNumber = (TextBox)pnlBooks.FindControl("tbGoodsNumber" + goodsIterator);
var tbGoodsCost = (TextBox)pnlBooks.FindControl("tbGoodsCost" + goodsIterator);
var hfGoodsID = (HiddenField)pnlBooks.FindControl("hfGoodsID" + goodsIterator);
var hfWithoutAkciza = (HiddenField)pnlBooks.FindControl("hfWithoutAkciza" + goodsIterator);
var hfGoodsNumber = (HiddenField)pnlBooks.FindControl("hfGoodsNumber" + goodsIterator);
var hfGoodsCost = (HiddenField)pnlBooks.FindControl("hfGoodsCost" + goodsIterator);
var hfGoodsDescription = (HiddenField)pnlBooks.FindControl("hfGoodsDescription" + goodsIterator);
var hfGoodsModel = (HiddenField)pnlBooks.FindControl("hfGoodsModel" + goodsIterator);
tbGoodsDescription.Text = hfGoodsDescription.Value = row["Description"].ToString();
tbGoodsModel.Text = hfGoodsModel.Value = row["Model"].ToString();
tbGoodsNumber.Text = hfGoodsNumber.Value = row["Number"].ToString();
tbGoodsCost.Text = hfGoodsCost.Value = MoneyMethods.MoneySeparator(row["Cost"].ToString());
hfGoodsID.Value = row["ID"].ToString();
hfWithoutAkciza.Value = row["WithoutAkciza"].ToString();
goodsIterator++;
}
#endregion
#region Вывод старых грузов. Метод на очистку.
if (GoodsCount == 0)
{
lblOldGoods.Visible = true;
lblOldGoods.Text = "<b>" + OtherMethods.GoodsStringFromTicketID(ticket.ID.ToString()) + "</b><br/>";
}
#endregion
#region Инициализация сущностей
var user = new Users();
user.ID = Convert.ToInt32(ticket.UserID);
user.GetById();
#region Блок конфигурации удаления заявки
if (currentRole.ActionUserTicketDelete != 1)
{
btnDelete.Visible = false;
}
#endregion
var profile = new UsersProfiles();
profile.ID = Convert.ToInt32(ticket.UserProfileID);
profile.GetById();
#endregion
#region блок общей информации
SpecialClient = user.SpecialClient;
hfID.Value = ticket.ID.ToString();
hfDriverID.Value = ticket.DriverID.ToString();
hfStatusID.Value = ticket.StatusID.ToString();
hfStatusIDOld.Value = ticket.StatusIDOld.ToString();
hfStatusDescription.Value = ticket.StatusDescription;
hfAdmissionDate.Value = ticket.AdmissionDate.ToString();
hfUserID.Value = UserID = ticket.UserID.ToString();
hfUserDiscount.Value = user.Discount.ToString();
hfUserProfileType.Value = profile.TypeID.ToString();
hfFullSecureID.Value = ticket.FullSecureID;
lblID.Text = ticket.SecureID;
hlUser.Text = user.Family + ' ' + user.Name;
hlUser.NavigateUrl = "~/ManagerUI/Menu/Souls/ClientEdit.aspx?id=" + ticket.UserID;
hlProfile.Text = profile.TypeID == 1 ? (profile.FirstName + ' ' + profile.LastName) : profile.CompanyName;
hlProfile.NavigateUrl = "~/ManagerUI/Menu/Souls/ProfileView.aspx?id=" + ticket.UserProfileID;
lblProfileType.Text = UsersProfilesHelper.UserProfileTypeToText(Convert.ToInt32(profile.TypeID));
lblCreateDate.Text = OtherMethods.DateConvert(ticket.CreateDate.ToString());
lblAdmissionDate.Text = OtherMethods.DateConvert(ticket.AdmissionDate.ToString());
lblDeliveryDateStatic.Text = OtherMethods.DateConvert(ticket.DeliveryDate.ToString());
lblIsExchange.Text = ticket.IsExchange == 0 ? "нет" : "да";
cbWithoutMoney.Checked = ticket.WithoutMoney != 0;
lblNN.Text = ticket.PrintNaklInMap == 0 ? "нет" : "да";
lblPN.Text = ticket.PrintNakl == 0 ? "нет" : "да";
if (String.IsNullOrEmpty(ticket.Comment))
{
tdComment.Visible = false;
}
else
{
lblComment.Text = WebUtility.HtmlDecode(ticket.Comment);
}
var regionText = CityHelper.CityToTrack(Convert.ToInt32(ticket.CityID), ticket.ID.ToString());
if (ticket.TrackIDUser != 0 || regionText == "Не задано")
{
ddlUserTrack.Visible = true;
lblTrack.Visible = false;
var region = new Tracks();
ddlUserTrack.DataSource = region.GetAllItems();
ddlUserTrack.DataTextField = "Name";
ddlUserTrack.DataValueField = "ID";
ddlUserTrack.DataBind();
ddlUserTrack.Items.Insert(0, new ListItem("Не задано", "0"));
ddlUserTrack.SelectedValue = Convert.ToString(ticket.TrackIDUser);
}
else
{
lblTrack.Text = regionText;
}
if (string.IsNullOrEmpty(lblAdmissionDate.Text))
{
lblAdmissionDate.Text = "Груз пока не на складе";
}
#endregion
#region блок информации, заполняемой пользователем
AssessedCost = MoneyMethods.MoneySeparator(ticket.AssessedCost.ToString());
hfAssessedCost.Value = ticket.AssessedCost.ToString();
lblAssessedCost.Text = MoneyMethods.MoneySeparator(ticket.AssessedCost.ToString());
tbDeliveryCost.Text = MoneyMethods.MoneySeparator(ticket.DeliveryCost.ToString());
ddlRecipientStreetPrefix.SelectedValue = ticket.RecipientStreetPrefix;
tbRecipientStreet.Text = ticket.RecipientStreet;
tbRecipientStreetNumber.Text = ticket.RecipientStreetNumber;
tbRecipientKorpus.Text = ticket.RecipientKorpus;
tbRecipientKvartira.Text = ticket.RecipientKvartira;
tbRecipientPhone.Text = ticket.RecipientPhone;
tbRecipientPhone2.Text = ticket.RecipientPhoneTwo;
ddlSenderStreetPrefix.SelectedValue = ticket.SenderStreetPrefix;
tbSenderStreetName.Text = ticket.SenderStreetName;
tbSenderStreetNumber.Text = ticket.SenderStreetNumber;
tbSenderHousing.Text = ticket.SenderHousing;
tbSenderApartmentNumber.Text = ticket.SenderApartmentNumber;
tbNote.Text = ticket.Note;
tbBoxesNumber.Text = string.IsNullOrEmpty(ticket.BoxesNumber.ToString()) ? "1" : ticket.BoxesNumber.ToString();
tbDeliveryDate.Text = Convert.ToDateTime(ticket.DeliveryDate).ToString("dd-MM-yyyy");
tbRecipientFirstName.Text = ticket.RecipientFirstName;
tbRecipientLastName.Text = ticket.RecipientLastName;
tbRecipientThirdName.Text = ticket.RecipientThirdName;
tbTtnSeria.Text = ticket.TtnSeria;
tbTtnNumber.Text = ticket.TtnNumber;
tbOtherDocuments.Text = ticket.OtherDocuments;
tbPassportNumber.Text = ticket.PassportNumber;
tbPassportSeria.Text = ticket.PassportSeria;
if (!String.IsNullOrEmpty(ticket.DeliveryCost.ToString()) && ticket.DeliveryCost != 0)
{
cbIsDeliveryCost.Checked = true;
}
//автокомплит наименования
var titles = new Titles();
var availableTitles = titles.GetAllItems("Name", "ASC", null).Tables[0].Rows.Cast <DataRow>().Aggregate(String.Empty, (current, items) => current + ("\"" + items["Name"] + "\","));
AvailableTitles = availableTitles.Remove(availableTitles.Length - 1);
#endregion
#region Заполнение города
var allCity = Application["CityList"] as List <City>;
if (allCity != null)
{
tbCity.Text = CityHelper.CityIDToAutocompleteString(allCity.FirstOrDefault(u => u.ID == ticket.CityID));
hfCityID.Value = ticket.CityID.ToString();
var senderCity = allCity.First(u => u.ID == ticket.SenderCityID);
tbSenderCity.Text = CityHelper.CityIDToAutocompleteString(senderCity);
hfSenderCityID.Value = ticket.SenderCityID.ToString();
}
#endregion
hfWharehouse.Value = ticket.WharehouseId.ToString();
#region блок информации, заполняемой менеджером
ddlStatus.DataSource = DAL.DataBaseObjects.Tickets.TicketStatuses;
ddlStatus.DataTextField = "Value";
ddlStatus.DataValueField = "Key";
ddlStatus.DataBind();
ddlStatus.SelectedValue = Convert.ToString(ticket.StatusID);
var ddrivers = new Drivers {
StatusID = 1
};
var dataSet5 = ddrivers.GetAllActivatedDrivers();
dataSet5.Tables[0].Columns.Add("FIOAndID", typeof(string), "'(' + ID + ') ' + FirstName + ' ' + SUBSTRING(LastName,1,1) + '.' + SUBSTRING(ThirdName,1,1) + '.'");
ddlDrivers.DataSource = dataSet5;
ddlDrivers.DataTextField = "FIOAndID";
ddlDrivers.DataValueField = "ID";
ddlDrivers.DataBind();
ddlDrivers.Items.Insert(0, new ListItem("Водитель не назначен", "0"));
tbAgreedCost.Text = MoneyMethods.MoneySeparator(ticket.AgreedCost.ToString());
tbGruzobozCost.Text = MoneyMethods.MoneySeparator(ticket.GruzobozCost.ToString());
#region Блок блокировки полей
if (currentRole.ActionControlGruzobozCost != 1)
{
tbGruzobozCost.Enabled = false;
}
if (currentRole.ActionStatusAdd != 1)
{
ddlStatus.Enabled = false;
tbDeliveryDate.Enabled = false;
tbStatusDescription.Enabled = false;
}
if (currentRole.ActionDriverAdd != 1)
{
ddlDrivers.Enabled = false;
}
if (currentRole.ActionAllowChangeMoneyAndCourse != 1)
{
tbAgreedCost.Enabled = false;
tbGruzobozCost.Enabled = false;
}
#endregion
//если id водителя 0 или -1 - водитель не назначен
if (ticket.DriverID != 0 && ticket.DriverID != -1)
{
ddlDrivers.SelectedValue = ticket.DriverID.ToString();
}
else
{
ddlDrivers.SelectedValue = "0";
}
//если статусы На складе (перенесен), Отказ (у курьера), Возврат (на складе), Отмена (на складе), Отмена то показываем почему
if (ddlStatus.SelectedValue == "7" || ddlStatus.SelectedValue == "8" || ddlStatus.SelectedValue == "4" || ddlStatus.SelectedValue == "9" || ddlStatus.SelectedValue == "10")
{
lblStatusDescription.Visible = true;
tbStatusDescription.Visible = true;
tbStatusDescription.Text = ticket.StatusDescription;
}
#endregion
#region Ограничения на правку текстбоксов
//если админ или статусы "Не обработана" или "На складе" или "На складе (перенесено)", или "Отмена" или "Отмена (на складе)" - можно изменять все поля пользователя
if (currentRole.ActionDisallowEditSomeFieldInTickets != 1 &&
(ddlStatus.SelectedValue == "1" || ddlStatus.SelectedValue == "2" || ddlStatus.SelectedValue == "4" || ddlStatus.SelectedValue == "9" || ddlStatus.SelectedValue == "10") &&
currentRole.ActionDisallowTicketChangeWithoutManagerInfo != 1)
{
tbCity.Enabled =
tbRecipientStreetNumber.Enabled =
tbRecipientKorpus.Enabled =
tbRecipientFirstName.Enabled =
tbRecipientLastName.Enabled =
tbRecipientThirdName.Enabled =
tbRecipientKvartira.Enabled =
tbRecipientPhone.Enabled =
tbBoxesNumber.Enabled =
tbDeliveryDate.Enabled =
tbOtherDocuments.Enabled =
tbTtnNumber.Enabled =
tbTtnSeria.Enabled =
tbPassportNumber.Enabled =
tbPassportSeria.Enabled =
tbRecipientPhone2.Enabled =
tbRecipientStreet.Enabled =
tbNote.Enabled = true;
for (var i = 1; i <= GoodsCount; i++)
{
var tbGoodsDescription = (TextBox)pnlBooks.FindControl("tbGoodsDescription" + i);
var tbGoodsModel = (TextBox)pnlBooks.FindControl("tbGoodsModel" + i);
var tbGoodsNumber = (TextBox)pnlBooks.FindControl("tbGoodsNumber" + i);
tbGoodsDescription.Enabled = true;
tbGoodsModel.Enabled = true;
tbGoodsNumber.Enabled = true;
}
}
if (currentRole.ActionDisallowTicketChangeWithoutManagerInfo == 1)
{
ddlUserTrack.Enabled = false;
tbRecipientFirstName.Enabled = false;
tbRecipientLastName.Enabled = false;
tbRecipientThirdName.Enabled = false;
}
//только админ может изменять курсы
if (currentRole.ActionAllowChangeMoneyAndCourse == 1 && currentRole.ActionDisallowTicketChangeWithoutManagerInfo != 1)
{
cbIsDeliveryCost.Enabled =
tbDeliveryCost.Enabled = true;
for (var i = 1; i <= GoodsCount; i++)
{
var tbGoodsCost = (TextBox)pnlBooks.FindControl("tbGoodsCost" + i);
tbGoodsCost.Enabled = true;
}
}
#endregion
}
if (!String.IsNullOrEmpty(hfCityID.Value))
{
var coefficientDeviationCost = Convert.ToDouble(BackendHelper.TagToValue("coefficient_deviation_cost"));
var city = new City {
ID = Convert.ToInt32(hfCityID.Value)
};
city.GetById();
var district = new Districts {
ID = Convert.ToInt32(city.DistrictID)
};
district.GetById();
lblCityCost.Text = MoneyMethods.MoneySeparatorForCityTableView((city.DistanceFromCity * Convert.ToDecimal(coefficientDeviationCost)).ToString());
lblCityDeliveryDate.Text =
DistrictsHelper.DeliveryDateStringToRuss(DistrictsHelper.DeliveryDateString(city.DistrictID));
lblCityDeliveryTerms.Text =
DistrictsHelper.DeliveryTermsToRuss(DistrictsHelper.DeliveryTerms(city.DistrictID));
}
}
