public static Response AddRouteToTag(string clientId, string tag, string route)
{
using (ClientDataContext db = new ClientDataContext())
{
var clientTag = GetClientTag(clientId, tag);
if (clientTag == null)
{
return(new Response("Не удалось найти остановку по такому тегу"));
}
var stop = db.Stops.Where(s => s.Id == clientTag.StopId).FirstOrDefault();
var timeIntervals = Parser.GetTime(stop, new List <string> {
route
});
if (!timeIntervals.Any())
{
return(new Response("Не удалось добавить маршрут, проверьте корректность названия маршрута"));
}
var routes = clientTag.Routes;
if (routes.Contains(route))
{
return(new Response("Маршрут уже был добавлен ранее"));
}
clientTag.Routes.Add(route);
db.ClientTags.Update(clientTag);
db.SaveChanges();
return(new Response("Добавлено!"));
}
}
public TfEditClient(string connctionString, Customer customer)
{
InitializeComponent();
_connectionString = connctionString;
_customer = customer;
using (var dc = new ClientDataContext(_connectionString))
{
_emailMask = dc.Заказы_покупатель_маска("email");
_descriptionMask = dc.Заказы_покупатель_маска("desc");
_faceMask = dc.Заказы_покупатель_маска("face");
_fullMask = dc.Заказы_покупатель_маска("full");
var telMask = dc.Заказы_покупатель_маска("tel");
_telephoneMasks = dc.Replaces
.Where(replace => replace.Тип == 1)
.OrderBy(replace => replace.Приоритет)
.ToList();
_telephoneRecords = dc.RegExMatch(_fullMask, customer.Телефон ?? "")
.Where(rec => rec.GroupName == "head" || rec.GroupName == "element")
.ToList()
.Select(rec =>
new TelephoneRecord()
{
Telephone = Regex.Replace(rec.Value, telMask, "${tel}"),
Face = Regex.Replace(rec.Value, telMask, "${face}"),
Appendix = Regex.Replace(rec.Value, telMask, "${desc}")
})
.ToList();
}
}
public static bool CreateDesign(DesignDummyViewModel dummy, int page_id)
{
using (ClientDataContext context = new ClientDataContext())
{
if (dummy.ad_id != 0)
{
//var FolioEntity = CreateDummyFolio();
//var FolioEntity = context.tbl_dummy_folio;
var PageEntity = context.tbl_dummy_page.Where(x => x.dummy_page_id == page_id).FirstOrDefault();
// PageEntity.tbl_dummy_folio = FolioEntity;
var PagePlacementEntity = dummy.ToEntity();
PagePlacementEntity.tbl_dummy_page = PageEntity;
//Unity.Work.Repository<tbl_dummy_page_placement>().Insert(PagePlacementEntity);
context.tbl_dummy_page_placement.Add(PagePlacementEntity);
context.SaveChanges();
////remove existing item
//var existingItem = Unity.Work.Repository<tbl_dummy_page_placement>().GetAll().Where(x => x.dummy_page_id == page_id && x.media_page_number_id == dummy.ad_id).FirstOrDefault();
//if(existingItem!= null)
//{
// Unity.Work.Repository<tbl_dummy_page_placement>().Delete(existingItem);
//}
// Unity.Work.Save();
}
return(true);
}
}
//public static bool UpdatePages() {
// var pages = Unity.Work.Repository<tbl_dummy_page>().GetAll().ToList();
// int i = 3;
// foreach (var page in pages)
// {
// page.page_name = "Page";
// page.page_number = i;
// i++;
// Unity.Work.Repository<tbl_dummy_page>().Update(page);
// }
// Unity.Work.Save();
// return true;
//}
public static FolioLoadViewModel CreateDummyFolio(FolioViewMode folio, int pub_id, int iss_id)
{
using (ClientDataContext context = new ClientDataContext())
{
var newfolio = new tbl_dummy_folio
{
dummy_page_dimension_id = context.lu_dummy_page_dimension.Where(x => x.pub_id == pub_id).FirstOrDefault().dummy_page_dimension_id,
total_page = folio.total_page,
start_page_number = folio.start_page_number,
iss_id = iss_id,
page_sequence = folio.start_page_number,
is_deleted = folio.is_deleted,
folio_name = folio.folio_name
};
context.tbl_dummy_folio.Add(newfolio);
// UpdateFolioSequence(newfolio, folio.insertAt, folio.folioAt, context);
context.SaveChanges();
var result = new FolioLoadViewModel();
result.pages = new List <DummyPageViewModel>();
result.pages = CreatePages(folio.total_page.GetValueOrDefault(), folio.start_page_number.GetValueOrDefault(), newfolio.dummy_folio_id, folio.page_desc).Select(pl => new DummyPageViewModel
{
dummy_page_id = pl.dummy_page_id,
page_number = pl.page_number.GetValueOrDefault(),
page_name = pl.page_name,
page_note = pl.page_note,
page_status = pl.page_status,
is_deleted = pl.is_deleted.GetValueOrDefault()
}).ToList();
result.folio_id = newfolio.dummy_folio_id;
result.folio_name = newfolio.folio_name;
result.folio_sequence = newfolio.page_sequence.GetValueOrDefault();
return(result);
}
}
private void CreateClient()
{
using (ClientDataContext db = new ClientDataContext(Config.LIFENAVConnectionString))
{
var client = new LIFENAV_Client();
client.FirstName = txtFirstName.Text;
client.LastName = txtLastName.Text;
client.Address1 = txtAddress1.Text;
client.Address2 = txtAddress2.Text;
client.City = txtCity.Text;
client.StateCode = ddlState.SelectedValue;
client.ZipCode = txtZipCode.Text;
client.Email = txtEmail.Text;
client.Password = txtPassword.Text;
client.HomePhone = txtHomePhone.Text;
client.WorkPhone = txtWorkPhone.Text;
db.LIFENAV_Clients.InsertOnSubmit(client);
db.SubmitChanges();
// update cookie with Client.Id
clientId = client.Id;
MyCookie.ClientId = clientId.ToString();
MyCookie.EmailAddress = txtEmail.Text;
}
}
public static List <FolioLoadViewModel> GetPubIssueData(int pub_id, int iss_id)
{
var pubIssueData = new PubIssueData();
// pubIssueData.Folios = new List<FolioLoadViewModel>();
var Folios = new List <FolioLoadViewModel>();
using (ClientDataContext context = new ClientDataContext())
{
var folios = context.tbl_dummy_folio.Where(x => x.iss_id == iss_id).Select(fo =>
new FolioViewMode {
folio_name = fo.folio_name,
page_sequence = fo.page_sequence,
dummy_folio_id = fo.dummy_folio_id,
total_page = fo.total_page
});
foreach (var folio in folios)
{
var item = new FolioLoadViewModel();
//item.folio = folio;
item.pages = GetPagesByFolioId(folio.dummy_folio_id);
item.folio_name = folio.folio_name;
item.folio_id = folio.dummy_folio_id;
item.folio_sequence = folio.page_sequence.GetValueOrDefault();
Folios.Add(item);
}
}
return(Folios);
}
public static Response ShowSavedStops(string clientId)
{
using (ClientDataContext db = new ClientDataContext())
{
var clientStops = db.ClientTags.Where(c => c.ClientId == clientId)
.Join(db.Stops, tag => tag.StopId, stop => stop.Id,
(tag, stop) => new { tag.TagName, stop.Name, tag.Routes });
if (!clientStops.Any())
{
return(new Response("А здесь пусто. Пока что."));
}
StringBuilder result = new StringBuilder().Append("Все ваши сохраненные остановки:\n");
foreach (var stop in clientStops)
{
result
.Append("Тег остановки: ")
.Append(stop.TagName)
.Append("\n")
.Append("Остановка: ")
.Append(stop.Name)
.Append("\n")
.Append("Маршруты: ")
.Append(string.Join(", ", stop.Routes))
.Append("\n\n");
}
return(new Response(result.ToString()));
}
}
public static ClientTag GetClientTag(string clientId, string tag)
{
using (ClientDataContext db = new ClientDataContext())
return(db.ClientTags
.Where(c => c.ClientId == clientId)
.Where(c => c.TagName.Contains(tag))
.FirstOrDefault());
}
private static XElement _getMembershipXML(int clientId)
{
using (ClientDataContext db = new ClientDataContext(Config.LIFENAVConnectionString))
{
var data = db.LIFENAV_GetMembershipXML(clientId);
var result = data.FirstOrDefault <LIFENAV_GetMembershipXMLResult>();
return(result == null ? null : result.Column1);
}
}
private ClientDataContext getContext ()
{
if (context_ == null) {
context_ = Most.Client.ClientDataContext
.create (ConfigurationManager.AppSettings ["Server"])
.authenticate (ConfigurationManager.AppSettings ["Username"], ConfigurationManager.AppSettings ["Password"]);
}
return context_;
}
public bool IsEmailAvailable()
{
bool result = false;
using (ClientDataContext db = new ClientDataContext(Config.LIFENAVConnectionString))
{
result = (db.LIFENAV_Clients.Count(c => c.Email.Equals(txtEmail.Text)) == 0);
}
return(result);
}
public static string ChangeStateToAddingName(string clientId)
{
using (ClientDataContext db = new ClientDataContext())
{
var clientState = GetClientState(clientId);
clientState.ClientStatus = Status.AddingName;
db.ClientStates.Update(clientState);
db.SaveChanges();
return($"! Кажется, я вас вижу, ой, слышу впервые... давайте знакомиться! Как вас зовут?");
}
}
public static Response ReturnDefaultState(string clientId, string text = null)
{
using (ClientDataContext db = new ClientDataContext())
{
var clientState = GetClientState(clientId);
clientState.ClientStatus = Status.Default;
db.ClientStates.Update(clientState);
db.SaveChanges();
return(new Response(text));
}
}
private void RemplirCbClient()
{
ClientDataContext DCClient = new ClientDataContext();
var requete = from client in DCClient.ClientsVoiture
select client;
foreach (var aa in requete)
{
cbNomClient.Items.Add(aa.nomClient.ToString() + " " + aa.prenomClient.ToString() + " " + aa.idClient.ToString());
}
}
public static Response ChangeStateToAddStop(string clientId)
{
using (ClientDataContext db = new ClientDataContext())
{
var clientState = GetClientState(clientId);
clientState.ClientStatus = Status.AddingStop;
db.ClientStates.Update(clientState);
db.SaveChanges();
return(StateHelper.GetInstruction(clientState));
}
}
public static Response AddBufferTag(string clientId, string tagName)
{
using (ClientDataContext db = new ClientDataContext())
{
var clientState = GetClientState(clientId);
clientState.BufferTagName = tagName;
clientState.ClientStatus = Status.AddingRoute;
db.ClientStates.Update(clientState);
db.SaveChanges();
return(StateHelper.GetInstruction(clientState));
}
}
public static Response RemoveClientTags(string clientId)
{
using (ClientDataContext db = new ClientDataContext())
{
db.ClientTags.RemoveRange(db.ClientTags.Where(c => c.ClientId == clientId));
db.SaveChanges();
return(new Response("Все остановки удалены. Не хотите добавить новые? Жизнь то нужно начинать с чистого листа!",
new string[1] {
"хочу добавить остановку"
}));
}
}
public static Response CreateClientAndState(string clientId, string sessionId)
{
using (ClientDataContext db = new ClientDataContext())
{
var clientState = new ClientState(clientId, sessionId);
db.ClientStates.Add(clientState);
db.Clients.Add(new Client(clientId));
db.SaveChanges();
return(new Response(greeting, new string[1] {
"хочу добавить остановку"
}));
}
}
public static Response AddClientName(string clientId, string name)
{
using (ClientDataContext db = new ClientDataContext())
{
var client = db.Clients.FirstOrDefault(c => c.Id == clientId);
client.Name = name;
var clientState = db.ClientStates
.FirstOrDefault(c => c.ClientId == clientId);
clientState.ClientStatus = Status.Default;
db.SaveChanges();
return(new Response("Отлично, рада знакомству!"));
}
}
public static Response AutoGenerateClientName(string clientId)
{
using (ClientDataContext db = new ClientDataContext())
{
var client = db.Clients.FirstOrDefault(c => c.Id == clientId);
var rnd = new Random();
client.Name = nicknames[rnd.Next(0, nicknames.Count - 1)];
var clientState = db.ClientStates
.FirstOrDefault(c => c.ClientId == clientId);
clientState.ClientStatus = Status.Default;
db.SaveChanges();
return(new Response($"Понимаю, вам неловко говорить своё имя...но все же я буду вас называть {client.Name}!)"));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (MyCookie.HasClientId && MyCookie.EmailAddress.Equals("*****@*****.**"))
{
using (ClientDataContext db = new ClientDataContext(Config.LIFENAVConnectionString))
{
var data = db.LIFENAV_Clients.ToList <LIFENAV_Client>();
rptClients.DataSource = data;
rptClients.DataBind();
}
}
else
{
Response.Redirect("/Login.aspx", true);
}
}
public static Response ContinueWorkOrChangeToDefaultState(string clientId, bool flag)
{
using (ClientDataContext db = new ClientDataContext())
{
var clientState = GetClientState(clientId);
var response = StateHelper.GetInstruction(clientState);
if (!flag)
{
clientState.ClientStatus = Status.Default;
response = new Response(@"Хорошо, как говорится, забудем ""старое""");
}
clientState.WaitingToContinue = false;
db.ClientStates.Update(clientState);
db.SaveChanges();
return(response);
}
}
public static Response AddStop(string clientId, string direction)
{
var clientState = GetClientState(clientId);
var directionUrl = (direction == "1" || direction == "первое")
? clientState.BufferDirections.First().Value
: clientState.BufferDirections.Last().Value;
var stopLink = Parser.GetStop(directionUrl, clientState.BufferStopName);
if (stopLink == null)
{
return(ReturnDefaultState(clientId, "Я не смогла найти остановку с таким названием по указанному вами маршруту."));
}
var stopUri = new Uri(stopLink);
var stopId = HttpUtility.ParseQueryString(stopUri.Query).Get("st_id");
Stop stop;
using (ClientDataContext db = new ClientDataContext())
{
stop = db.Stops.Where(s => s.Id == stopId).FirstOrDefault();
if (stop == null)
{
stop = new Stop(stopId, clientState.BufferStopName, stopLink);
db.Stops.Add(stop);
}
if (GetClientTag(clientId, clientState.BufferTagName) != null)
{
return(ReturnDefaultState(clientId, $"У вас уже есть такая остановка с тэгом {clientState.BufferTagName}"));
}
var clientTag = new ClientTag(clientId, clientState.BufferTagName, stopId);
clientTag.Routes.Add(clientState.BufferRouteName);
db.ClientTags.Add(clientTag);
ReturnDefaultState(clientId, null);
db.SaveChanges();
}
var timeIntervals = Parser.GetTime(stop, new List <string> {
clientState.BufferRouteName
});
string result = $"Я добавила эту остановку по тегу {clientState.BufferTagName}. " +
"А вот и заодно время прибытия транспорта:\n";
result += $"{string.Join("\n", timeIntervals[clientState.BufferRouteName])}";
return(new Response($"{result}\n"));
}
public static List <DummyPageViewModel> GetPagesByFolioId(int folio_id)
{
using (ClientDataContext context = new ClientDataContext())
{
// var pageData = new PageData();
//pageData.folio_id = folio_id;
var pages = context.tbl_dummy_page.ToList().Where(x => x.dummy_folio_id == folio_id).Select(pl => new DummyPageViewModel
{
dummy_page_id = pl.dummy_page_id,
page_number = pl.page_number.GetValueOrDefault(),
page_name = pl.page_name,
page_note = pl.page_note,
page_status = pl.page_status,
is_deleted = pl.is_deleted.GetValueOrDefault()
}).ToList();
//pageData.pages = pages;
return(pages);
}
}
public static Response GetTimeByTag(string clientId, string tag)
{
using (ClientDataContext db = new ClientDataContext())
{
var clientTag = GetClientTag(clientId, tag);
if (clientTag == null)
{
return(new Response("Не удалось найти остановку по такому тегу"));
}
var stop = db.Stops.Where(s => s.Id == clientTag.StopId).FirstOrDefault();
var timeIntervals = Parser.GetTime(stop, clientTag.Routes);
var result = $"Вот ваше время для маршрутов:\n";
foreach (var time in timeIntervals)
{
result += $"№{time.Key}: {string.Join("\n", time.Value[0])} {string.Join("\n", time.Value[1])}\n";
}
return(new Response(result));
}
}
public static Response GetResponseUserState(string clientId, string newSessionId)
{
using (ClientDataContext db = new ClientDataContext())
{
var clientState = GetClientState(clientId);
clientState.SessionId = newSessionId;
if (clientState.ClientStatus != Status.Default)
{
clientState.WaitingToContinue = true;
}
else
{
clientState.ClientStatus = Status.AnnouncingTag;
}
db.ClientStates.Update(clientState);
db.SaveChanges();
return(StateHelper.GetStateInfo(clientState));
}
}
//public static bool UpdateDesign(DesignDummyViewModel dummy,int page_id)
//{
// if (dummy.ad_id != 0)
// {
// var PageEntity = Unity.Work.Repository<tbl_dummy_page>().GetById(page_id);
// var PagePlacementEntity = Unity.Work.Repository<tbl_dummy_page_placement>().GetAll().Where(x => x.dummy_page_id == page_id).FirstOrDefault();
// var PagePlacementEntity = dummy.ToEntity(PagePlacementEntity.dummy_page_placement_id);
// PagePlacementEntity.tbl_dummy_page = PageEntity;
// Unity.Work.Repository<tbl_dummy_page_placement>().Update(PagePlacementEntity);
// Unity.Work.Save();
// }
// return true; ;
//}
public static List <tbl_dummy_page> CreatePages(int count, int start_page_number, int folio_id, string page_desc)
{
using (ClientDataContext context = new ClientDataContext())
{
var FolioEntity = context.tbl_dummy_folio.Where(x => x.dummy_folio_id == folio_id);
var pages = new List <tbl_dummy_page>();
if (FolioEntity != null)
{
for (var page = 0; page < count; page++)
{
pages.Add(CreateDummyPage(folio_id, new DummyPageViewModel {
page_name = page_desc, page_number = (page + start_page_number)
}));
context.tbl_dummy_page.AddRange(pages);
}
context.SaveChanges();
}
return(pages);
}
}
public static Response FindRouteDirections(string clientId, string routeName)
{
var route = Parser.FindRouteNum(routeName);
if (route == null)
{
return(new Response("Мне не удалось найти такой маршрут, проверьте правильность введенного номера маршрута"));
}
var directions = Parser.GetRouteChoice(route);
using (ClientDataContext db = new ClientDataContext())
{
var clientState = GetClientState(clientId);
clientState.ClientStatus = Status.ChoosingDirection;
clientState.BufferRouteName = routeName;
clientState.BufferDirections = directions;
db.ClientStates.Update(clientState);
db.SaveChanges();
return(StateHelper.GetInstruction(clientState));
}
}
public static DummyPageViewModel CreatePageByFolio(int folio_id)
{
using (ClientDataContext context = new ClientDataContext())
{
var maxPageCount = context.tbl_dummy_page.Where(x => x.dummy_folio_id == folio_id).Max(x => x.page_number).GetValueOrDefault();
var pageModel = new DummyPageViewModel {
page_name = "page", page_number = (maxPageCount + 1)
};
var page = CreateDummyPage(folio_id, pageModel);
context.tbl_dummy_page.Add(page);
context.SaveChanges();
return(new DummyPageViewModel
{
dummy_page_id = page.dummy_page_id,
page_number = page.page_number.GetValueOrDefault(),
page_name = page.page_name,
page_note = page.page_note,
page_status = page.page_status,
is_deleted = page.is_deleted.GetValueOrDefault()
});
}
}
public static bool DeleteDummyFolio(int folio_id)
{
using (ClientDataContext context = new ClientDataContext())
{
var folioObj = context.tbl_dummy_folio.Where(x => x.dummy_folio_id == folio_id).FirstOrDefault();
var pages = context.tbl_dummy_page.Where(x => x.dummy_folio_id == folio_id);
foreach (var page in pages)
{
var placements = context.tbl_dummy_page_placement.Where(x => x.dummy_page_id == page.dummy_page_id);
context.tbl_dummy_page_placement.RemoveRange(placements);
}
context.tbl_dummy_page.RemoveRange(pages);
context.tbl_dummy_folio.Remove(folioObj);
var bottommFolios = context.tbl_dummy_folio.Where(x => x.iss_id == folioObj.iss_id && x.page_sequence > folioObj.page_sequence);
foreach (var fo in bottommFolios)
{
fo.page_sequence--;
}
context.SaveChanges();
}
return(true);
}
public static ClientState GetClientState(string clientId)
{
using (ClientDataContext db = new ClientDataContext())
return(db.ClientStates
.FirstOrDefault(c => c.ClientId == clientId));
}
public static string GetClientName(string clientId)
{
using (ClientDataContext db = new ClientDataContext())
return(db.Clients.FirstOrDefault(cl => cl.Id == clientId)?.Name);
}
private void btEdit_Click(object sender, EventArgs e)
{
if (dbgList.SelectedRows.Count == 0)
return;
var current = (Customer)dbgList.SelectedRows[0].DataBoundItem;
if (current.ФИО == _unknownCustomer)
{
MessageBox.Show("Данного покупателя не следует редактировать.\nСледует заводить нового покупателя.",
"Внимание", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
edFilter.Text = current.ФИО;
MakeFilter();
checkedGuid = Guid.NewGuid();
if (dbgList.SelectedRows.Count == 0)
return;
current = (Customer)dbgList.SelectedRows[0].DataBoundItem;
if (dbgList.SelectedRows.Count == 0)
return;
var form =
new TfEditClient(
_connectionString,
new Customer()
{
Код = current.Код,
ФИО = current.ФИО,
Телефон = current.Телефон
});
form.Location =
new Point(
Location.X + Width / 2 - form.Width / 2,
Location.Y + Height / 2 - form.Height / 2);
if (form.ShowDialog() != DialogResult.OK)
return;
var customer =
new Customer()
{
ФИО = form.CustomerName,
Телефон = form.CustomerTelephone,
Основной_телефон = form.CustomerMainTelephone,
Активен = true
};
using (var dataContext = new ClientDataContext(_connectionString))
{
var dbCustomer = dataContext.Customers
.Where(cust => cust.Код == current.Код)
.First();
dbCustomer.ФИО = customer.ФИО;
dbCustomer.Телефон = customer.Телефон;
dbCustomer.Основной_телефон = customer.Основной_телефон;
dataContext.SubmitChanges();
}
edFilter.Text = customer.ФИО;
MakeFilter();
checkedGuid = Guid.NewGuid();
}
private void TfClients_Load(object sender, EventArgs e)
{
dbgList.AutoGenerateColumns = false;
using (var dataContext = new ClientDataContext(_connectionString))
{
var filter = dataContext.Customers
.Where(cust => cust.Код == _startCustomerId);
edFilter.Text =
filter.Any()
? filter.First().ФИО
: _unknownCustomer;
}
MakeFilter();
}
private List<Customer> GetFilter(string text)
{
var dataContext = new ClientDataContext(_connectionString);
var nearFilter = dataContext.Customers
.Where(cst => cst.ФИО.IndexOf(text) >= 0
|| cst.Телефон.IndexOf(text) >= 0)
.OrderBy(cst => cst.ФИО)
.Take(50);
var certainFilter = dataContext.Customers
.Where(cst => cst.ФИО == text);
return nearFilter.Union(certainFilter)
.OrderBy(cst => cst.ФИО)
.ToList();
}
private void btNew_Click(object sender, EventArgs e)
{
MakeFilter();
if(!btNew.Enabled)
return;
var form =
new TfEditClient(
_connectionString,
new Customer()
{
Код = 0,
ФИО = edFilter.Text
});
form.Location =
new Point(
Location.X + Width / 2 - form.Width / 2,
Location.Y + Height / 2 - form.Height / 2);
if (form.ShowDialog() != DialogResult.OK)
return;
var customer =
new Customer()
{
ФИО = form.CustomerName,
Телефон = form.CustomerTelephone,
Основной_телефон = form.CustomerMainTelephone,
Активен = true
};
using(var dataContext = new ClientDataContext(_connectionString))
{
dataContext.Customers.InsertOnSubmit(customer);
dataContext.SubmitChanges();
}
edFilter.Text = customer.ФИО;
MakeFilter();
checkedGuid = Guid.NewGuid();
}
private bool IsSameName(string name)
{
using (var dc = new ClientDataContext(_connectionString))
{
var filter = dc.Customers
.Where(customer =>
customer.ФИО.Trim().ToUpper() == name.ToUpper() &&
customer.Код != _customer.Код);
return filter.Any();
}
}
