/// <summary> /// Add a customer charge for a customer /// </summary> /// <param name="customCharge">A CustomerChargePost object with the customer charge and customer code</param> /// <returns>A Customer object with the reflected custom charge</returns> public async Task <Customer> AddCustomCharge(CustomChargePost customCharge) { Customers customers = new Customers(); Customer editCustomer = new Customer(); try { string urlPath = $"/customers/set-item-quantity/productCode/{_config.productCode}/code/{customCharge.CustomerCode}/itemCode/{customCharge.ItemCode}"; string postParams = FormatFunctions.addParam("chargeCode", customCharge.ChargeCode) + FormatFunctions.addParam("quantity", customCharge.Quantity.ToString()) + FormatFunctions.addParam("eachAmount", customCharge.EachAmount.ToString()) + FormatFunctions.addParam("description", customCharge.Description); string result = await _httpService.postRequest(urlPath, postParams); XDocument newCustomerXML = XDocument.Parse(result); customers = getCustomerList(newCustomerXML); if (customers.CustomerList.Count > 0) { editCustomer = customers.CustomerList[0]; } } catch (Exception ex) { throw ex; } return(editCustomer); }
public void populateGroups(string result) { string[] input = FormatFunctions.SplitToPairs(result); this.pickerIndex = FormatFunctions.createValuePairs(input); GroupSelector.ItemsSource = this.pickerIndex["GroupName"]; GroupSelector.SelectedItem = 1; }
public void populateFields(string result) { Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); this.entryDict = new List <DataPair>(); if (dictionary.Count > 0) { for (int i = 0; i < dictionary["Index"].Count; i++) { DataPair dataPair = new DataPair(int.Parse(dictionary["IDKey"][i]), dictionary["Value"][i], dictionary["Index"][i]); dataPair.Value.Text = dictionary["Value"][i]; dataPair.Value.Placeholder = "Value here"; dataPair.Value.FontSize = Device.GetNamedSize(NamedSize.Medium, typeof(Label)); dataPair.Value.VerticalOptions = LayoutOptions.CenterAndExpand; dataPair.Value.HorizontalOptions = LayoutOptions.StartAndExpand; dataPair.Index.Text = dictionary["Index"][i]; dataPair.Index.Placeholder = "Index here"; dataPair.Index.FontSize = Device.GetNamedSize(NamedSize.Medium, typeof(Label)); dataPair.Index.VerticalOptions = LayoutOptions.CenterAndExpand; dataPair.Index.HorizontalOptions = LayoutOptions.EndAndExpand; ViewCell viewCell = new ViewCell(); StackLayout stackLayout = new StackLayout { Orientation = StackOrientation.Horizontal }; this.entryDict.Add(dataPair); List <View> list = new List <View>(); list.Add(dataPair.Value); list.Add(dataPair.Index); GridFiller.rapidFillPremadeObjects(list, TSection, new bool[] { true, true }); } } }
public void populateTardiGrid(string result) { GridFiller.PurgeHeader(TardiGrid); Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); int sick = 0; int tardy = 0; if (dictionary["IDKey"].Count > 0) { for (int i = 0; i < dictionary["IDKey"].Count; i++) { GridFiller.rapidFill(new string[] { dictionary["RecordType"][i], dictionary["Date"][i], dictionary["Note"][i] }, TardiGrid); if (dictionary["RecordType"][i] == "Sick") { sick++; } else if (dictionary["RecordType"][i] == "Tardy") { tardy++; } } } Sick.Content = "Sick Days: " + sick; Late.Content = "Late Days: " + tardy; }
public void populatePage(string result) { Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); entryDict = new List <DataPair>(); NameDisplay.Text = dictionary["Name"][0]; if (dictionary.Count > 0) { for (int i = 0; i < dictionary["Index"].Count; i++) { DataPair dataPair = new DataPair(int.Parse(dictionary["FID"][i]), dictionary["value"][i], dictionary["Index"][i]); dataPair.Value.Text = dictionary["value"][i]; dataPair.Value.Placeholder = "Value here"; dataPair.Value.FontSize = Device.GetNamedSize(NamedSize.Medium, typeof(Label)); dataPair.Value.VerticalOptions = LayoutOptions.CenterAndExpand; dataPair.Value.HorizontalOptions = LayoutOptions.StartAndExpand; dataPair.Index.Text = dictionary["Index"][i]; dataPair.Index.Placeholder = "Index here"; dataPair.Index.FontSize = Device.GetNamedSize(NamedSize.Medium, typeof(Label)); dataPair.Index.VerticalOptions = LayoutOptions.CenterAndExpand; dataPair.Index.HorizontalOptions = LayoutOptions.EndAndExpand; List <View> list = new List <View>() { dataPair.Index, dataPair.Value }; int[] space = new int[] { 2, 2 }; bool[] box = new bool[] { true, true }; GridFiller.rapidFillSpacedPremadeObjects(list, mainGrid, space, box); this.entryDict.Add(dataPair); } } this.populateFileList(); }
public void populateList(string result) { Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); for (int i = 0; i < dictionary["FName"].Count; i++) { string text = dictionary["FName"][i] ?? ""; Label item = new Label { Content = (text ?? ""), }; DataSwitch item2 = new DataSwitch(int.Parse(dictionary["IDKey"][i])) { }; DataSwitch item3 = new DataSwitch(int.Parse(dictionary["IDKey"][i])) { }; List <UIElement> list = new List <UIElement>() { item, item2, item3 }; GridFiller.rapidFillPremadeObjects(list, TSection, new bool[] { true, true, true }); Favorites.Add(item2); Group.Add(item3); } }
/// <summary> /// Update a customer /// </summary> /// <param name="customer">A CustomerPost object that represents the changes to be updated</param> /// <returns>An updated Customer object with the changes applied</returns> public async Task <Customer> UpdateCustomer(Customer customer) { Customers customers = new Customers(); Customer updatedCustomer = new Customer(); try { // Create the web request string urlPath = string.Format("/customers/edit-customer/productCode/{0}/code/{1}", _config.productCode, customer.Code); string postParams = FormatFunctions.addParam("firstName", customer.FirstName) + FormatFunctions.addParam("lastName", customer.LastName) + FormatFunctions.addParam("email", customer.Email) + FormatFunctions.addParam("company", customer.Company) + FormatFunctions.addParam("notes", customer.Notes) + FormatFunctions.addParam("remoteAddress", customer.RemoteAddress) + FormatFunctions.addMetaDataParams(customer.AdditionalMetaData); string result = await _httpService.postRequest(urlPath, postParams); XDocument newCustomerXML = XDocument.Parse(result); customers = getCustomerList(newCustomerXML); if (customers.CustomerList.Count > 0) { updatedCustomer = customers.CustomerList[0]; } } catch (Exception ex) { throw ex; } return(updatedCustomer); }
public void populateResults(string result) { this.PurgeCells(); Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result), true); if (dictionary.Count > 1) { for (int i = 0; i < dictionary["uniqueid"].Count; i++) { string text = dictionary["calldate"][i] + " : " + FormatFunctions.PrettyPhone(dictionary["cnam"][i]); SecurityButton dataButton = new SecurityButton(int.Parse(Regex.Replace(dictionary["uniqueid"][i], "^[^.]+.", "")), new string[] { "Manager" }) { Text = text, FontSize = Device.GetNamedSize(NamedSize.Medium, typeof(Label)), VerticalOptions = LayoutOptions.CenterAndExpand, HorizontalOptions = LayoutOptions.EndAndExpand }; dataButton.Clicked += onClicked; dataButton.String = dictionary["calldate"][i]; dataButton.String2 = dictionary["recordingfile"][i]; List <View> list = new List <View> { dataButton }; GridFiller.rapidFillPremadeObjects(list, TSection, new bool[] { true }); } } }
public void populateList(string result) { Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); Dictionary <string, SecurityButton> dictionary2 = new Dictionary <string, SecurityButton>(); if (dictionary.Count > 0) { for (int i = 0; i < dictionary["Name"].Count; i++) { if (!dictionary2.ContainsKey(dictionary["IDKey"][i])) { string text = FormatFunctions.PrettyDate(dictionary["Name"][i]) + " ," + FormatFunctions.PrettyDate(dictionary["Value"][i]); SecurityButton dataButton = new SecurityButton(int.Parse(dictionary["IDKey"][i]), new string[] { "Employee" }) { Content = text, Width = ClientData.sideFrame.Width * 0.925 }; dataButton.Click += this.onClicked; dataButton.Integer2 = int.Parse(dictionary["Stage"][i]); List <UIElement> list = new List <UIElement>() { dataButton }; bool[] box = new bool[] { false }; GridFiller.rapidFillPremadeObjectsStandardHeight(list, dataGrid, box, 25); dictionary2.Add(dictionary["IDKey"][i], dataButton); } else { SecurityButton dataButton2 = dictionary2[dictionary["IDKey"][i]]; dataButton2.Content = dataButton2.Content + " ," + dictionary["Value"][i]; } } } }
public void populateGrid(string result) { dp = new List <DataPair>(); Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); if (dictionary.Count > 0) { for (int i = 0; i < dictionary["IDKey"].Count; i++) { DataPair d = new DataPair(int.Parse(dictionary["IDKey"][i]), dictionary["Index"][i], dictionary["Value"][i]); List <UIElement> list = new List <UIElement>() { d.Index, d.Value }; d.Index.Text = FormatFunctions.PrettyDate(dictionary["Index"][i]); if (d.Index.Text.Contains("~")) { d.Value.Text = FormatFunctions.lookupAgentName(int.Parse(dictionary["Value"][i])); } else { d.Value.Text = FormatFunctions.PrettyDate(dictionary["Value"][i]); } GridFiller.rapidFillPremadeObjects(list, bodyGrid, new bool[] { true, true }); dp.Add(d); } } }
public void populateResults(string result) { this.PurgeCells(); Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result), true); if (dictionary.Count > 1) { for (int i = 0; i < dictionary["uniqueid"].Count; i++) { string text = dictionary["calldate"][i] + " : " + FormatFunctions.PrettyPhone(dictionary["cnam"][i]); SecurityButton dataButton = new SecurityButton(int.Parse(Regex.Replace(dictionary["uniqueid"][i], "^[^.]+.", "")), new string[] { "Manager" }) { Content = text }; dataButton.Click += onClicked; dataButton.String = dictionary["calldate"][i]; dataButton.String2 = dictionary["recordingfile"][i]; List <UIElement> list = new List <UIElement> { dataButton }; GridFiller.rapidFillPremadeObjects(list, TSection, new bool[] { true }); } } }
public void populateFields(string result) { Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); for (int i = 0; i < dictionary["Name"].Count; i++) { DataEntry item = new DataEntry(int.Parse(dictionary["IDKey"][i]), dictionary["Value"][i]) { Text = dictionary["Value"][i], FontSize = Device.GetNamedSize(NamedSize.Medium, typeof(Label)), VerticalOptions = LayoutOptions.CenterAndExpand, HorizontalOptions = LayoutOptions.StartAndExpand }; DataEntry item2 = new DataEntry(int.Parse(dictionary["IDKey"][i]), dictionary["Index"][i]) { Text = dictionary["Name"][i], FontSize = Device.GetNamedSize(NamedSize.Medium, typeof(Label)), VerticalOptions = LayoutOptions.CenterAndExpand, HorizontalOptions = LayoutOptions.EndAndExpand }; ViewCell viewCell = new ViewCell(); StackLayout stackLayout = new StackLayout { Orientation = StackOrientation.Horizontal }; stackLayout.Children.Add(item2); stackLayout.Children.Add(item); viewCell.View = stackLayout; this.TSection.Add(viewCell); this.Values.Add(item); this.Names.Add(item2); } }
public void populateStamps(string result) { GridFiller.PurgeHeader(HourCalcBody); Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); List <string> clockin = new List <string>(); List <string> clockout = new List <string>(); if (dictionary.Count > 0) { for (int i = 0; i < dictionary["IDKey"].Count; i++) { string[] y = new string[2]; y[0] = FormatFunctions.PrettyDate(dictionary["TimeStamp"][i]); y[1] = convertState(dictionary["State"][i]); if (dictionary["State"][i] == "True") { GridFiller.rapidFillColorized(y, HourCalcBody, true); clockin.Add(FormatFunctions.PrettyDate(dictionary["TimeStamp"][i])); } else if (dictionary["State"][i] == "False") { GridFiller.rapidFillColorized(y, HourCalcBody, false); clockout.Add(FormatFunctions.PrettyDate(dictionary["TimeStamp"][i])); } else { GridFiller.rapidFill(y, HourCalcBody); } } double x = calculateHours(clockin, clockout) / 60; HourDisplay.Text = "Total Hours: " + x; } }
public async void saveTaskFields(string result) { string text = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result))["IDKey"][0]; string text2 = "INSERT INTO taskfields (Index,Value,TaskID) VALUES "; for (int i = 0; i < this.Names.Count; i++) { if (!string.IsNullOrEmpty(this.Names[i].Text)) { text2 = string.Concat(new string[] { text2, "('", this.Names[i].Text, "', '", this.Values[i].Text, "', '", text, "')," }); } } text2 = text2 + "('', '', '" + text + "')"; DatabaseFunctions.SendToPhp(text2); TaskCallback c = new TaskCallback(this.voidCall); await PopupNavigation.Instance.PushAsync(new Notification_Popup("Your Task has been created", "OK", c), true); }
public void writeState(string result) { Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); if (dictionary.Count > 0) { PunchedIn = bool.Parse(dictionary["State"][0]); if (((PunchedIn && !createPunchOnResult) || (!PunchedIn && createPunchOnResult)) && !statelessPunch) { PunchButton.Background = new SolidColorBrush(ClientData.rotatingConfirmationColors[0]); ClockState.Content = "Current State: Clocked In"; } else if (!statelessPunch) { PunchButton.Background = new SolidColorBrush(ClientData.rotatingNegativeColors[0]); ClockState.Content = "Current State: Clocked Out"; } } if (createPunchOnResult) { createPunchOnResult = false; string sql = "INSERT INTO punchclock (AgentID,Timestamp,Coordinates,State,Note) VALUES('" + ClientData.AgentIDK + "','" + FormatFunctions.CleanDateNew(DateTime.Now.ToString("yyyy/M/d HH:mm:ss")) + "','Desktop','" + !PunchedIn + "','" + TextEntry.Text + "')"; DatabaseFunctions.SendToPhp(sql); } if (statelessPunch) { statelessPunch = false; string sql = "INSERT INTO punchclock (AgentID,Timestamp,Coordinates,State,Note) VALUES('" + ClientData.AgentIDK + "','" + FormatFunctions.CleanDateNew(DateTime.Now.ToString("yyyy/M/d HH:mm:ss")) + "','Desktop','less','" + TextEntry.Text + "')"; DatabaseFunctions.SendToPhp(sql); } getPunches(); }
public void populateList(string result) { //DatabaseFunctions.SendToDebug("Beginning populating daily tasks"); Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); if (dictionary.Count > 1) { for (int i = 0; i < dictionary["Name"].Count; i++) { string text = dictionary["Name"][i] ?? ""; SecurityButton dataButton = new SecurityButton(int.Parse(dictionary["IDKey"][i]), new string[] { "Employee" }) { Text = text, FontSize = Device.GetNamedSize(NamedSize.Medium, typeof(Label)), VerticalOptions = LayoutOptions.CenterAndExpand, HorizontalOptions = LayoutOptions.FillAndExpand }; dataButton.Clicked += this.onClicked; List <View> list = new List <View>(); list.Add(dataButton); GridFiller.rapidFillPremadeObjects(list, tasksList, new bool[] { true, true }); } } //DatabaseFunctions.SendToDebug("Finsihed populating daily tasks"); }
public void populatePage(string result) { Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); entryDict = new List <DataPair>(); NameDisplay.Content = FormatFunctions.PrettyDate(dictionary["Name"][0]); if (dictionary.Count > 0) { for (int i = 0; i < dictionary["Index"].Count; i++) { DataPair dataPair = new DataPair(int.Parse(dictionary["FID"][i]), dictionary["value"][i], dictionary["Index"][i]); dataPair.Value.Text = FormatFunctions.PrettyDate(dictionary["value"][i]); dataPair.Value.ToolTip = "Value here"; dataPair.Index.Text = FormatFunctions.PrettyDate(dictionary["Index"][i]); dataPair.Index.ToolTip = "Index here"; List <UIElement> list = new List <UIElement>() { dataPair.Index, dataPair.Value }; int[] space = new int[] { 2, 2 }; bool[] box = new bool[] { true, true }; GridFiller.rapidFillSpacedPremadeObjects(list, mainGrid, space, box); this.entryDict.Add(dataPair); } } //this.populateFileList(); }
public void populatePunches(string result) { Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); if (dictionary.Count > 0) { GridFiller.PurgeGrid(logGrid); string[] list = new string[3]; for (int i = 0; i < dictionary["IDKey"].Count; i++) { list[0] = FormatFunctions.PrettyDate(dictionary["Note"][i]); list[2] = FormatFunctions.PrettyDate(dictionary["State"][i]); list[1] = FormatFunctions.PrettyDate(dictionary["TimeStamp"][i]); if (list[2] != "less") { GridFiller.rapidFillColorized(list, logGrid, bool.Parse(list[2])); } else { list[2] = "Location Log"; GridFiller.rapidFill(list, logGrid); } } } }
public void onClicked(object sender, RoutedEventArgs e) { foreach (DataPair dataPair in this.entryDict) { if (dataPair.isNew) { DatabaseFunctions.SendToPhp(string.Concat(new object[] { "INSERT INTO cusfields (cusfields.Value,cusfields.Index,CusID) VALUES('", FormatFunctions.CleanDateNew(dataPair.Value.Text), "','", FormatFunctions.CleanDateNew(dataPair.Index.Text), "','", this.customer, "')" })); dataPair.isNew = false; } else if (dataPair.Index.Text != dataPair.Index.GetInit()) { DatabaseFunctions.SendToPhp(string.Concat(new object[] { "UPDATE cusfields SET Value = '", FormatFunctions.CleanDateNew(dataPair.Value.Text), "',Index='", FormatFunctions.CleanDateNew(dataPair.Index.Text), "' WHERE (IDKey= '", dataPair.Index.GetInt(), "');" })); } } }
public void populateChat(string result) { Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); if (dictionary.Count > 0) { for (int i = 0; i < dictionary["Message"].Count; i++) { Label item = new Label { Text = string.Concat(new string[] { FormatFunctions.PrettyDate(dictionary["Timestamp"][i]), ":", dictionary["FName"][i], ":", dictionary["Message"][i] }), FontSize = Device.GetNamedSize(NamedSize.Medium, typeof(Label)), VerticalOptions = LayoutOptions.Start, HorizontalOptions = LayoutOptions.Start }; ChatStack.Children.Add(item); } } }
/// <summary> /// Create a new customer based on the passed in CustomerPost object /// </summary> /// <param name="customer">A CustomerPost object that represents a customer to be created</param> /// <param name="returnUrl">The return url for PayPal transactions</param> /// <param name="cancelUrl">The cancel url for PayPal transactions</param> /// <returns>A newly created Customer object</returns> public async Task <Customer> CreateCustomerWithPayPal(CustomerPost customer, string returnUrl, string cancelUrl) { Customers customers = new Customers(); Customer newCustomer = new Customer(); try { string urlPath = $"/customers/new/productCode/{_config.productCode}"; string postParams = "subscription[method]=paypal" + FormatFunctions.addParam("code", customer.Code) + FormatFunctions.addParam("firstName", customer.FirstName) + FormatFunctions.addParam("lastName", customer.LastName) + FormatFunctions.addParam("email", customer.Email) + FormatFunctions.addParam("subscription[planCode]", customer.PlanCode) + FormatFunctions.addParam("subscription[ccFirstName]", customer.CCFirstName) + FormatFunctions.addParam("subscription[ccLastName]", customer.CCLastName) + FormatFunctions.addParam("subscription[returnUrl]", returnUrl) + FormatFunctions.addParam("subscription[cancelUrl]", cancelUrl) + FormatFunctions.addMetaDataParams(customer.AdditionalMetaData); string result = await _httpService.postRequest(urlPath, postParams); XDocument newCustomerXML = XDocument.Parse(result); customers = getCustomerList(newCustomerXML); if (customers.CustomerList.Count > 0) { newCustomer = customers.CustomerList[0]; } } catch (Exception ex) { throw ex; } return(newCustomer); }
public void setupBoxes(string result) { Labels = new List <Label>(); checkBoxes = new List <UIElement>(); Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); uniqueIDs = dictionary["IDKey"]; uniqueNames = dictionary["FName"]; foreach (string s in uniqueIDs) {//Possible roles are: Sales, Installer List <UIElement> elements = new List <UIElement>(); elements.Add(new Label() { Content = s }); elements.Add(new DataDoubleSwitch(int.Parse(s), 0) { HorizontalAlignment = HorizontalAlignment.Center }); //Sales elements.Add(new DataDoubleSwitch(int.Parse(s), 1) { HorizontalAlignment = HorizontalAlignment.Center }); //Installer checkBoxes.AddRange(elements); GridFiller.rapidFillPremadeObjects(elements, BodyGrid, new bool[] { true, false, false }); } checkBoxes = FormatFunctions.scrubOutUnlessWanted(checkBoxes, new DataDoubleSwitch(0, 0), Labels); for (int j = 0; j < uniqueNames.Count; j++) { Labels[j].Content = uniqueNames[j]; } }
public void populateCombo(string result) { Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); PriceGuidecombo.ItemsSource = dictionary["v"]; prices = dictionary["PriceSale"]; }
public void populateSalesCombo(string result) { Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result)); SalemanCombo.ItemsSource = dictionary["FName"]; salesmen = dictionary["IDKey"]; }
public void onClicked(object sender, RoutedEventArgs e) { List <string> batch = new List <string>(); foreach (DataPair dataPair in this.entryDict) { if (dataPair.isNew) { string s = "INSERT INTO cusfields (cusfields.Value,cusfields.Index,CusID) VALUES('" + FormatFunctions.CleanDateNew(dataPair.Value.Text) + "','" + FormatFunctions.CleanDateNew(dataPair.Index.Text) + "','" + this.customer + "')"; batch.Add(s); dataPair.isNew = false; } else if (!dataPair.Index.Text.Equals(dataPair.Index.GetInit()) || !dataPair.Value.Text.Equals(dataPair.Value.GetInit())) { string s = "UPDATE cusfields SET cusfields.Value = '" + FormatFunctions.CleanDateNew(dataPair.Value.Text) + "',cusfields.Index='" + FormatFunctions.CleanDateNew(dataPair.Index.Text) + "' WHERE (IDKey= '" + dataPair.Index.GetInt() + "');"; batch.Add(s); } } string sql = "UPDATE cusfields SET cusfields.value='" + FormatFunctions.CleanDateNew(noteLabel.Text) + "' WHERE cusfields.Index LIKE'%otes%' AND CusID= '" + customer + "'"; batch.Add(sql); string sql2 = "UPDATE cusindex SET Name='" + FormatFunctions.CleanDateNew(nameLabel.Text) + "' WHERE IDKey= '" + customer + "'"; batch.Add(sql2); string sql3 = "UPDATE cusfields SET cusfields.value='" + FormatFunctions.CleanDateNew(BookingDate.Text) + "' WHERE cusfields.Index LIKE '%ookin%' AND CusID= '" + customer + "'"; batch.Add(sql3); string sql4 = "UPDATE cusfields SET cusfields.value='" + FormatFunctions.CleanPhone(phoneLabel.Text) + "' WHERE cusfields.Index LIKE '%hone%' AND CusID= '" + customer + "'"; batch.Add(sql4); string sql5 = "UPDATE cusfields SET cusfields.value='" + FormatFunctions.CleanDateNew(DateTime.Now.ToString("yyyy/M/d h:mm:ss")) + "' WHERE cusfields.Index LIKE '%odified On%' AND CusID= '" + customer + "'";//'Modified On','" + FormatFunctions.CleanDateNew(DateTime.Now.ToString("yyyy/M/d h:mm:ss")) + "' batch.Add(sql5); DatabaseFunctions.SendBatchToPHP(batch); }
public void populateResults(string result) { this.views = new List <ViewCell>(); Dictionary <string, List <string> > dictionary = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result), true); if (dictionary.Count > 1) { for (int i = 0; i < dictionary["eventtime"].Count; i++) { string c; bool CC = false; if (dictionary["eventtype"][i] == "ANSWER") { c = "Yes"; CC = true; } else { c = "No"; } string[] s = new string[3] { FormatFunctions.PrettyPhone(dictionary["cid_num"][i]), dictionary["eventtime"][i], c }; GridFiller.rapidFillColorized(s, TSection, CC); } } }
public void saveTaskFields(string result) { string text = FormatFunctions.createValuePairs(FormatFunctions.SplitToPairs(result))["IDKey"][0]; string text2 = "INSERT INTO taskfields (taskfields.Index,taskfields.Value,TaskID) VALUES "; for (int i = 0; i < this.Names.Count; i++) { if (!string.IsNullOrEmpty(this.Names[i].Text)) { string stripped1 = FormatFunctions.CleanDateNew(Names[i].Text); string stripped2 = FormatFunctions.CleanDateNew(Values[i].Text); text2 = string.Concat(new string[] { text2, "('", stripped1, "', '", stripped2, "', '", text, "')," }); } } text2 = text2 + "('', '', '" + text + "')"; DatabaseFunctions.SendToPhp(text2); Tasks_Page page = new Tasks_Page(); ClientData.mainFrame.Navigate(page); }
public void onClickedCreate(object sender, RoutedEventArgs e) { string sql = "INSERT INTO tasks (Name,AgentID,Start) VALUES ('" + FormatFunctions.CleanDateNew(taskName.Text) + "','" + agent.getSelectID() + "','" + Datepick.Text + ");"; DatabaseFunctions.SendToPhp(sql); DatabaseFunctions.SendToPhp(false, "SELECT IDKey FROM tasks ORDER BY IDKey DESC LIMIT 1;", new TaskCallback(this.saveTaskFields)); }
public void onClicked(object sender, RoutedEventArgs e) { foreach (DataPair dataPair in entryDict) { if (dataPair.isNew) { DatabaseFunctions.SendToPhp(string.Concat(new object[] { "INSERT INTO cusfields (cusfields.Value,cusfields.Index,CusID) VALUES('", FormatFunctions.CleanDateNew(dataPair.Value.Text), "','", FormatFunctions.CleanDateNew(dataPair.Index.Text), "','", this.customer, "')" })); dataPair.isNew = false; } else if (!dataPair.Index.Text.Equals(dataPair.Index.GetInit()) || !dataPair.Value.Text.Equals(dataPair.Value.GetInit())) { DatabaseFunctions.SendToPhp(string.Concat(new object[] { "UPDATE cusfields SET Value = '", FormatFunctions.CleanDateNew(dataPair.Value.Text), "', Cusfields.Index='", FormatFunctions.CleanDateNew(dataPair.Index.Text), "' WHERE (IDKey= '", dataPair.Index.GetInt(), "');" })); } } string sql = "DELETE FROM cusfields WHERE CusID='" + customer + "' AND cusfields.Index='INVOICEFIELD'"; DatabaseFunctions.SendToPhp(sql); foreach (DataPair dp in entryDictQ) { if (dp.Value.Text != "" && dp.Index.Text != "") { string sql2 = "INSERT INTO cusfields(cusfields.Value,cusfields.Index,CusID,cusfields.AdvValue) VALUES ('" + FormatFunctions.CleanDateNew(dp.Value.Text) + "','INVOICEFIELD','" + customer + "','" + FormatFunctions.CleanDateNew(dp.Index.Text) + "')"; DatabaseFunctions.SendToPhp(sql2); } } List <string> batch = new List <string>(); string sql5 = "UPDATE cusfields SET cusfields.value='" + FormatFunctions.CleanDateNew(DateTime.Now.ToString("yyyy/M/d h:mm:ss")) + "' WHERE cusfields.Index LIKE '%odified On%' AND CusID= '" + customer + "'";//'Modified On','" + FormatFunctions.CleanDateNew(DateTime.Now.ToString("yyyy/M/d h:mm:ss")) + "' batch.Add(sql5); string sql3 = "UPDATE cusfields SET cusfields.value='" + FormatFunctions.CleanDateNew(contactLabel.Text) + "' WHERE cusfields.Index LIKE '%ookin%' AND CusID= '" + customer + "'"; batch.Add(sql3); string sql4 = "UPDATE cusfields SET cusfields.value='" + FormatFunctions.CleanPhone(phoneLabel.Text) + "' WHERE cusfields.Index LIKE '%hone%' AND CusID= '" + customer + "'"; batch.Add(sql4); string sql6 = "UPDATE cusfields SET cusfields.value='" + salesmen[SalemanCombo.SelectedIndex] + "' WHERE cusfields.Index LIKE '%alesman%' AND CusID= '" + customer + "'"; batch.Add(sql6); string sql7 = "UPDATE cusfields SET cusfields.value='" + FormatFunctions.CleanDateNew(DateTime.Now.ToString("yyyy/M/d h:mm:ss")) + "' WHERE cusfields.Index LIKE '%odified On%' AND CusID= '" + customer + "'";//'Modified On','" + FormatFunctions.CleanDateNew(DateTime.Now.ToString("yyyy/M/d h:mm:ss")) + "' batch.Add(sql7); string sql8 = "UPDATE cusindex SET Name='" + FormatFunctions.CleanDateNew(nameLabel.Text) + "' WHERE IDKey='" + customer + "'"; batch.Add(sql8); DatabaseFunctions.SendBatchToPHP(batch); Install_Page page = new Install_Page(customer, stage); ClientData.mainFrame.Navigate(page); }
public void onClickOverrideTime(object sender, RoutedEventArgs e) { DataButton b = (DataButton)sender; string sql = "UPDATE punchclock SET TimeStamp='" + FormatFunctions.CleanDateNew(Timepick.Text) + "' WHERE IDKey='" + b.GetInt() + "'"; DatabaseFunctions.SendToPhp(sql); b.Background = new SolidColorBrush(Color.FromRgb(213, 213, 213)); }