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;
}
