private void FillOrdersCollection(string[] columns) { int.TryParse(columns[1], out int id); if (id == 0 || Orders.FirstOrDefault(o => o.Id == id) != null) { return; } var order = new Order { Id = id, Salesman = Salesmen.FirstOrDefault(c => c.Name.Equals(columns[3])), Customer = columns.Length >= 5 ? Customers.FirstOrDefault(c => c.Name.Equals(columns[4])) : null }; var columnWithoutBrackets = Regex.Replace(columns[2], "[[]", string.Empty); columnWithoutBrackets = Regex.Replace(columnWithoutBrackets, "[]]", string.Empty); var lineItems = Regex.Split(columnWithoutBrackets, "[,]"); foreach (var lineItem in lineItems) { var columnItems = Regex.Split(lineItem, "[-]"); FillOrderItemsCollection(order, columnItems); } Orders.Add(order); }
public void RemoveLastSalesman() { if (Salesmen.Count == 1) { return; } Salesmen.RemoveAt(Salesmen.Count - 1); }
public ReportsViewModel(Context context) { _context = context; SalesmanReportCommand = new DelegateCommand(SalesmanReport, () => ThroughDate >= FromDate && SelectedSalesman != null); GeneralReportCommand = new DelegateCommand(GeneralReport, () => ThroughDate >= FromDate); FromDate = DateTime.Today.AddDays(-14); ThroughDate = DateTime.Today.AddDays(1); Salesmen = context.Salesmen.ToList().Select(x => new SalesmanViewModel(x)).ToList(); SelectedSalesman = Salesmen.FirstOrDefault(); }
protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e) { GridEditFormItem gdItem = (e.Item as GridEditFormItem); var editableItem = ((GridEditableItem)e.Item); Salesmen S = new Salesmen(); Hashtable values = new Hashtable(); editableItem.ExtractValues(values); try { var upiCode = values["UpiCode"] as string; var channelName = values["ChannelName"] as string; if (string.IsNullOrEmpty(channelName) && string.IsNullOrEmpty(upiCode)) { ShowErrorMessage(Pharma.Provide_info_to_insert__please); e.Canceled = true; } else { if (upiCode == null || string.IsNullOrEmpty(upiCode.Trim()) || channelName == null || string.IsNullOrEmpty(channelName.Trim())) { ShowErrorMessage(Pharma.Provide_full_name_to_save__please); e.Canceled = true; } else { var cboParentChannel = gdItem.FindControl("ddlParentChannel") as RadComboBox; if (cboParentChannel != null) { var result = channelRepo.Insert(upiCode, channelName, int.Parse(cboParentChannel.SelectedValue)); if(!result) { ShowErrorMessage("UPI code and Channel name are unique, please change to another one."); e.Canceled = true; } } } } } catch (System.Exception ex) { ShowErrorMessage(Pharma.Administrator_Default_RadGrid1_InsertCommand_can_not_add__please_try_again_later_or_contact_admnistrator_); e.Canceled = true; } }
public void AddRandomSalesman() { var r = new Random(); var values = new List <double>(); for (var i = 0; i < Salesmen[0].PrimaryValues.Count; i++) { values.Add(r.Next(0, 10)); } Salesmen.Add(new BarSeries { Title = _names[r.Next(0, _names.Count() - 1)], PrimaryValues = new ObservableCollection <double>(values) }); }
public SalesmanStatitic GetWorstSalesman() { var result = Sales .GroupBy(s => s.Salesman) .Select(s => new { Salesman = s.Key, Total = s.Sum(s => s.Total) }) .OrderBy(s => s.Total) .FirstOrDefault(); return(new SalesmanStatitic() { Salesman = Salesmen.FirstOrDefault(s => s.Name.Equals(result.Salesman, StringComparison.InvariantCultureIgnoreCase)), Total = result.Total }); }
private void LoadCollections(string data, bool reset = false) { if (reset) { Customers.Clear(); Salesmen.Clear(); Orders.Clear(); } var lines = Regex.Split(data, "\r\n|\r|\n"); foreach (var line in lines) { try { var lineWithoutBreak = Regex.Replace(line, "\r\n|\r|\n", string.Empty); var columns = Regex.Split(lineWithoutBreak, "[ç]"); var lineType = LineTypeHelper.StringToLineType(columns[0]); switch (lineType) { case Enums.LineType.Customer: FillCustomersCollection(columns); break; case Enums.LineType.Salesman: FillSalesmenCollection(columns); break; case Enums.LineType.Order: FillOrdersCollection(columns); break; } } catch (Exception) { //no momento, o único tratamento será um bypass } } }
private void FillSalesmenCollection(string[] columns) { var cpf = columns[1]; if (Salesmen.FirstOrDefault(s => s.CPF.Equals(cpf)) != null) { return; } var salesman = new Salesman() { CPF = cpf, Name = columns[2], Salary = decimal.TryParse(columns[3], NumberStyles.Any, _decimalConversionCulture, out decimal salary) ? salary : 0 }; Salesmen.Add(salesman); }
protected void RadGrid1_InsertCommand(object source, GridCommandEventArgs e) { GridEditFormItem gdItem = (e.Item as GridEditFormItem); var editableItem = ((GridEditableItem)e.Item); Salesmen S = new Salesmen(); Hashtable values = new Hashtable(); editableItem.ExtractValues(values); try { if (((RadComboBox)gdItem.FindControl("ddlFunctions")).SelectedIndex == 0) { repo.Add((string)values["FunctionName"], null, (string)values["Action"]); } else { repo.Add((string)values["FunctionName"], Convert.ToInt32(((RadComboBox)gdItem.FindControl("ddlFunctions")).SelectedValue), (string)values["Action"]); } } catch (System.Exception ex) { ShowErrorMessage(ex.Message); } }
private void detach_Salesmens(Salesmen entity) { this.SendPropertyChanging(); entity.Role = null; }
partial void InsertSalesmen(Salesmen instance);
private void DeterminePocPos(Salesmen salesmen) { if (salesmen.RoleId.HasValue) { switch (salesmen.RoleId.Value) { case (int)SalesmenRole.EROM: cboEROM.Visible = false; litEROM.Visible = false; cboPSS1.Visible = true; cboPSR1.Visible = true; // Load data for PSS1 var pss1 = _sRepo.GetSalesmenByRoleIdAndManagerId((int)SalesmenRole.PSS1, salesmen.Id); LoadListSalesmenToCombo(pss1, cboPSS1, "Select a PSS1"); UtilitiesHelpers.Instance.ClearComboData(cboPSR1); litPOC.Visible = true; litPOS.Visible = false; HideComboBox(0); break; case (int)SalesmenRole.PSS1: cboEROM.Visible = false; cboPSS1.Visible = false; litEROM.Visible = false; litPSS1.Visible = false; cboPSR1.Visible = true; UtilitiesHelpers.Instance.ClearComboData(cboPSR1); // Load data for PSS1 var psr1 = _sRepo.GetSalesmenByRoleIdAndManagerId((int)SalesmenRole.PSR1, salesmen.Id); LoadListSalesmenToCombo(psr1, cboPSR1, "Select a PSR1"); litPOC.Visible = true; litPOS.Visible = false; HideComboBox(0); break; case (int)SalesmenRole.PSR1: cboEROM.Visible = false; cboPSS1.Visible = false; litEROM.Visible = false; litPSS1.Visible = false; cboPSR1.Visible = false; litPSR1.Visible = false; UtilitiesHelpers.Instance.ClearComboData(cboPSR1); var itemPsr1 = new RadComboBoxItem(salesmen.FullName, salesmen.Id.ToString()); cboPSR1.Items.Insert(0, itemPsr1); litPOC.Visible = true; litPOS.Visible = false; // hide EROM2 and TROM HideComboBox(0); break; // EROM 2 case (int)SalesmenRole.EROM2: cboEROM2.Visible = false; litEROM2.Visible = false; cboPSR2.Visible = true; cboPSR2.Visible = true; // Load data for PSS2 var pss2 = _sRepo.GetSalesmenByRoleIdAndManagerId((int)SalesmenRole.PSS2, salesmen.Id); LoadListSalesmenToCombo(pss2, cboPSS2, "Select a PSS2"); UtilitiesHelpers.Instance.ClearComboData(cboPSR2); litPOC.Visible = true; litPOS.Visible = false; HideComboBox(2); break; case (int)SalesmenRole.PSS2: cboEROM2.Visible = false; cboPSS2.Visible = false; litEROM2.Visible = false; litPSS2.Visible = false; cboPSR2.Visible = true; UtilitiesHelpers.Instance.ClearComboData(cboPSR2); // Load data for PSR2 var psr2 = _sRepo.GetSalesmenByRoleIdAndManagerId((int)SalesmenRole.PSR2, salesmen.Id); LoadListSalesmenToCombo(psr2, cboPSR2, "Select a PSR2"); litPOC.Visible = true; litPOS.Visible = false; HideComboBox(2); break; case (int)SalesmenRole.PSR2: cboEROM2.Visible = false; cboPSS2.Visible = false; litEROM2.Visible = false; litPSS2.Visible = false; cboPSR2.Visible = false; litPSR2.Visible = false; UtilitiesHelpers.Instance.ClearComboData(cboPSR2); litPOC.Visible = true; litPOS.Visible = false; var itemPsr2 = new RadComboBoxItem(salesmen.FullName, salesmen.Id.ToString()); cboPSR2.Items.Insert(0, itemPsr2); HideComboBox(2); break; // TROM case (int)SalesmenRole.TROM: cboTROM.Visible = false; litTROM.Visible = false; cboTPS.Visible = true; // Load data for TPS var tps = _sRepo.GetSalesmenByRoleIdAndManagerId((int)SalesmenRole.TPS, salesmen.Id); LoadListSalesmenToCombo(tps, cboTPS, "Select a TPS"); UtilitiesHelpers.Instance.ClearComboData(cboTPR); litPOC.Visible = false; litPOS.Visible = true; HideComboBox(1); break; case (int)SalesmenRole.TPS: cboTROM.Visible = false; cboTPS.Visible = false; litTROM.Visible = false; litTPS.Visible = false; cboTPR.Visible = true; UtilitiesHelpers.Instance.ClearComboData(cboPSR2); // Load data for TPR var tpr = _sRepo.GetSalesmenByRoleIdAndManagerId((int)SalesmenRole.TPR, salesmen.Id); LoadListSalesmenToCombo(tpr, cboTPR, "Select a TPR"); litPOC.Visible = false; litPOS.Visible = true; HideComboBox(1); break; case (int)SalesmenRole.TPR: cboTROM.Visible = false; cboTPS.Visible = false; litTROM.Visible = false; litTPS.Visible = false; cboTPR.Visible = false; litTPR.Visible = false; UtilitiesHelpers.Instance.ClearComboData(cboTPR); var itemTpr = new RadComboBoxItem(salesmen.FullName, salesmen.Id.ToString()); cboTPR.Items.Insert(0, itemTpr); litPOC.Visible = false; litPOS.Visible = true; HideComboBox(1); break; } } }
partial void UpdateSalesmen(Salesmen instance);
partial void DeleteSalesmen(Salesmen instance);
public int ImportSalesmen(string UpiCode, string FullName, string Phone, int RoleId, int SmsQuota, DateTime ExpiredDate, int managerId) { try { if (CheckExistedSalesmen(FullName) == false) { Salesmen o = new Salesmen(); o.UpiCode = UpiCode; o.FullName = FullName; o.Phone = Phone; o.RoleId = RoleId; o.SmsQuota = SmsQuota; o.ExpiredDate = ExpiredDate; o.SalesmenManagerId = managerId; db.Salesmens.InsertOnSubmit(o); db.SubmitChanges(); return o.Id; } var s = (from l in db.Salesmens where l.FullName == FullName select l).SingleOrDefault(); if (s != null) return s.Id; return -1; } catch { return -1; } }
public bool Add(string upiCode, string fullName, string phone, int roleId, int smsQuota, DateTime expiredDate, int groupId, int regionId, int areaId, int localId) { try { if (CheckExistedSalemen(-1, phone)) return false; var o = new Salesmen { UpiCode = upiCode, FullName = fullName, Phone = phone, RoleId = roleId, SmsQuota = smsQuota, ExpiredDate = expiredDate }; db.Salesmens.InsertOnSubmit(o); db.SubmitChanges(); int salesMenId = o.Id; if (groupId != 0) { // insert Group to SaleGroup SalesGroup salesGroup = new SalesGroup(); salesGroup.GroupId = groupId; salesGroup.SalesmenId = salesMenId; db.SalesGroups.InsertOnSubmit(salesGroup); db.SubmitChanges(); } if (regionId != 0) { // insert region SalesRegion salesRegion = new SalesRegion(); salesRegion.SalesmenId = salesMenId; salesRegion.RegionId = regionId; db.SalesRegions.InsertOnSubmit(salesRegion); db.SubmitChanges(); } if (areaId != 0) { // insert area SalesArea salesArea = new SalesArea(); salesArea.SalesmenId = salesMenId; salesArea.AreaId = areaId; db.SalesAreas.InsertOnSubmit(salesArea); db.SubmitChanges(); } if (localId != 0) { // insert area SalesLocal salesLocal = new SalesLocal(); salesLocal.SalesmenId = salesMenId; salesLocal.LocalId = localId; db.SalesLocals.InsertOnSubmit(salesLocal); db.SubmitChanges(); } return true; } catch { return false; } }
private void attach_Salesmens(Salesmen entity) { this.SendPropertyChanging(); entity.Role = this; }