// загрузка списка точек осуществляется из базы АИС УРТ
private void initializeSalePoints()
{
// загрузка информации из XML
var salePointsXml = XmlHelper.Deserialize <SalePointList>(Path.Combine(Application.StartupPath, "SalePointIps.xml"));
// загрузка информации из БД
List <SalePointRecordSql> salePointsSql;
List <Region> regions;
List <Person> persons;
List <Contact> contacts;
using (var connAisurt = new SqlConnection(ConnectionWrapper.CreateLoginPassword(
"192.168.1.202", "AISURT", "BlankPublishAgent", "BlankPublishAgent").ConnectionString))
{
connAisurt.Open();
salePointsSql = loadList <SalePointRecordSql>(
"select SubjectID ID, SubjectCode Code, SubjectName Name, AddressText Address, RegionCode Region from ViewSalePoint", connAisurt);
regions = loadList <Region>(
"select cast(Code as bigint) ID, Name from RoleRegion", connAisurt);
persons = loadList <Person>(
"select SubjectID, FName, IName, OName, Position from TrustPerson", connAisurt);
contacts = loadList <Contact>(
"select SubjectID, Phone, MobilePhone, FAX from ContactInformation", connAisurt);
}
// сведение всех данных воедино
foreach (var xml in salePointsXml.SalePoints)
{
salePoints.Add(SalePoint.LoadInfo(xml, salePointsSql, regions, persons, contacts, salePoints.FindAll(sp => sp.Code == xml.Code)));
}
}
public ActionResult Add(SalePoint newentry)
{
if (ModelState.IsValid)
{
var salepoint = AgroExpressDBAccess.IsSalePointExist(newentry.SalePointName);
if (salepoint != null)
{
ModelState.AddModelError("SalePointName", "Sale Point already exist");
return(View(newentry));
}
var salepointt = new SalePoint();
salepointt.SalePointName = newentry.SalePointName;
salepointt.SalePointAddress = newentry.SalePointAddress;
salepointt.IsDeleted = false;
if (AgroExpressDBAccess.AddSalePoint(salepointt))
{
ViewBag.success = "Sale Point Add Successsfull";
ModelState.Clear();
SalePoint registration = new SalePoint();
return(View(registration));
}
}
return(View(newentry));
}
/// <summary>
/// Вывод на экран.
/// </summary>
/// <param name="parent">родительская форма</param>
/// <param name="sp">ПР</param>
/// <param name="data">информация</param>
public static void Show(IWin32Window parent, SalePoint sp, List <StatusInfo> data)
{
var dialog = new StatusForm();
dialog.Text = string.Format("Состояние {0} {1}", sp.Code, sp.Name);
dialog.statusInfoBindingSource.DataSource = data;
dialog.statusInfoBindingSource.ResetBindings(false);
dialog.ShowDialog(parent);
}
/// <summary>
/// Вывод на экран.
/// </summary>
/// <param name="parent">родительская форма</param>
/// <param name="sp">ПР</param>
/// <param name="info">информация</param>
public static void Show(IWin32Window parent, SalePoint sp, SystemInfo info)
{
var dialog = new SystemForm();
dialog.Text = string.Format("Системная информация {0} {1}", sp.Code, sp.Name);
dialog.systemInfoBindingSource.DataSource = info;
dialog.systemInfoBindingSource.ResetBindings(false);
dialog.ShowDialog(parent);
}
/// <summary>
/// Вывод на экран.
/// </summary>
/// <param name="parent">родительская форма</param>
/// <param name="sp">ПР</param>
/// <param name="data">информация</param>
public static void Show(IWin32Window parent, SalePoint sp, List <VelcomInfo> data)
{
var dialog = new VelcomForm();
dialog.Text = string.Format("Детализация трафика {0} {1}", sp.Code, sp.Name);
dialog.velcomInfoBindingSource.DataSource = data;
dialog.velcomInfoBindingSource.ResetBindings(false);
dialog.ShowDialog(parent);
}
/// <summary>
/// Вывод на экран.
/// </summary>
/// <param name="parent">родительская форма</param>
/// <param name="sp">ПР</param>
/// <param name="data">информация</param>
public static void Show(IWin32Window parent, SalePoint sp, List <VersionInfo> data)
{
var dialog = new VersionForm();
dialog.Text = string.Format("Версии ПО {0} {1}", sp.Code, sp.Name);
dialog.versionInfoBindingSource.DataSource = data;
dialog.versionInfoBindingSource.ResetBindings(false);
dialog.ShowDialog(parent);
}
/// <summary>
/// Вывод на экран.
/// </summary>
/// <param name="parent">родительская форма</param>
/// <param name="sp">ПР</param>
/// <param name="data">информация</param>
public static void Show(IWin32Window parent, SalePoint sp, List <PrintInfo> data)
{
var dialog = new PrintForm();
dialog.Text = string.Format("Напечатанные документы {0} {1}", sp.Code, sp.Name);
dialog.printInfoBindingSource.DataSource = data;
dialog.printInfoBindingSource.ResetBindings(false);
dialog.memoEditStatistics.Text = getSummary(data).ToString();
dialog.ShowDialog(parent);
}
public IActionResult AddSalePoint(SalePoint SalePoint)
{
if (ModelState.IsValid)
{
var postResult = Helper.PostValueToSevice <SalePoint>("POST", SalePoint);
return(Json(new { success = postResult.result, message = postResult.message }));
}
return(Json(new { success = false, message = "Model Is Not Vald!" }));
}
public IActionResult EditSalePoint(long id, SalePoint SalePoint)
{
if (ModelState.IsValid)
{
SalePoint.State = BusinessEntity.Models.Base.Enums.ObjectState.Active;
var postResult = Helper.PostValueToSevice <SalePoint>("PUT?id=" + SalePoint.Id.ToString(), SalePoint);
return(Json(new { success = postResult.result, message = postResult.message }));
}
return(Json(new { success = false, message = "Model Is Not Valid!" }));
}
/// <summary>
/// Вывод на экран.
/// </summary>
/// <param name="parent">родительская форма</param>
/// <param name="sp">ПР</param>
/// <param name="data">информация</param>
public static void Show(IWin32Window parent, SalePoint sp, List <LogInfo> data)
{
var dialog = new LogForm();
dialog.Text = string.Format("Журналы работы {0} {1}", sp.Code, sp.Name);
dialog.logs = data;
dialog.comboBoxEditLogSelect.Properties.Items.Clear();
foreach (var log in dialog.logs)
{
dialog.comboBoxEditLogSelect.Properties.Items.Add(log.Program);
}
dialog.comboBoxEditLogSelect.SelectedIndex = dialog.logs.Count - 1;
dialog.ShowDialog(parent);
}
public IActionResult Sell(int curEmId)
{
List <Ticket> res;
int rows, cols;
int adultsNum = Convert.ToInt32(Request.Form["kol"].ToString());
int childrensNum = Convert.ToInt32(Request.Form["kolChildren"].ToString());
List <User> ListCustomer = new List <User>();
_service.emission = _db.TicketEmissions.FirstOrDefault(t => t.id == curEmId);
if (adultsNum + childrensNum > _service.emission.currentQuantity)
{
return(Redirect("~/Home/TicketOrderError"));
}
for (int i = 0; i <= adultsNum - 1; i++)
{
User Adult = new User();
Adult.firstName = Request.Form["fio"][i];
Adult.phoneNumber = Request.Form["phone"][i];
Adult.isChildren = false;
ListCustomer.Add(Adult);
}
for (int i = 0; i <= childrensNum - 1; i++)
{
User Child = new User();
Child.firstName = Request.Form["fioChildren"][i];
Child.age = Convert.ToInt32(Request.Form["age"][i]);
Child.isChildren = true;
ListCustomer.Add(Child);
}
res = SalePoint.sellTicket(ref _service.emission, adultsNum, childrensNum);
_service.ivm.currentTicketsEmission = _service.emission;
_service.ivm.currentTicketsSet = _service.emission.ticketsSet;
Order singleOrder = new Order();
singleOrder.Comments = "shtolce_test";
singleOrder.Emission = _service.emission;
singleOrder.Customers = ListCustomer;
singleOrder.InitialCost = singleOrder.CalculateAnOrderCostDynamic();
singleOrder.OrderDate = DateTime.Now;
singleOrder.SoldTickets = res;
_db.Orders.Add(singleOrder);
_db.SaveChanges();
_service.ivm.Orders.Add(singleOrder);
rows = _service.ivm.hallMapping.GetUpperBound(0) + 1;
cols = _service.ivm.hallMapping.GetUpperBound(1) + 1;
int idx = 0;
foreach (var ce in _service.emission.ticketsSet)
{
idx++;
int row = (int)Math.Ceiling((double)idx / cols);
int col;
int quiotent = Math.DivRem(idx, cols, out col);
col = (col == 0) ? 6 : col;
_service.ivm.hallMapping[row - 1, col - 1] = Convert.ToInt32(ce.isSold);
_db.TicketEmissions.Include(t => t.ticketsSet).
FirstOrDefault(t => t.id == _service.emission.id).
ticketsSet[idx - 1].isSold = ce.isSold;
_db.SaveChanges();
}
ViewData["CurrentOrderId"] = singleOrder.id;
return(View(_service.ivm));
}
public IActionResult DeleteSalePoint(SalePoint SalePoint)
{
var postResult = Helper.PostValueToSevice <SalePoint>("Delete?id=" + SalePoint.Id.ToString(), SalePoint);
return(Json(new { success = postResult.result, message = postResult.message }));
}
