public bool Add(Salesman salesman)
{
try
{
string sql = "INSERT INTO salesman values(?SalesmanId,?Account,?PassWord,?Name,?AliAccount)";
MySqlParameter[] parameter = new MySqlParameter[] {
new MySqlParameter("?SalesmanId", salesman.SalesmanId),
new MySqlParameter("?Account", salesman.Account),
new MySqlParameter("?PassWord", salesman.PassWord) ,
new MySqlParameter("?Name", salesman.Name) ,
new MySqlParameter("?AliAccount", salesman.AliAccount)
};
return MySqlHelper.ExecuteNonQuery(CommandType.Text, sql, parameter) == 1;
}
catch (Exception e)
{
MySqlHelper.CloseDBConnection();
throw e;
}
finally
{
}
}
static void Main(string[] args)
{
int noSalesMen;
Console.Write("Enter the number of salesmen: ");
noSalesMen = int.Parse(Console.ReadLine());
// Create a new Salesman object with the number of sales men in the array
Salesman salesman = new Salesman(noSalesMen);
// Enter the details about each salesman
for (int i = 0; i < noSalesMen; i++)
{
Console.Write("Enter the name of the salesman " + (i + 1) + ": ");
salesman.Names[i] = Console.ReadLine();
Console.Write("Enter the sales made by this salesman: ");
salesman.Sales[i] = Convert.ToDouble(Console.ReadLine());
}
// Calculating total sales and selecting the best salesman updates
// the instance variables of 'salesman' which can then be accessed
// using properties
salesman.calcTotalSales();
salesman.bestSalesMan();
Console.WriteLine(String.Format("\nThe total sales is {0:0.00}", salesman.TotalSales));
Console.WriteLine("The best salesman is " + salesman.BestSalesMan);
}
/// <summary>
///
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public Salesman GetFirstSalesman(int pageIndex, int pageSize)
{
var instance = new Salesman(false) { Name = "ciccio", Surname = "pasticcio", Email = "*****@*****.**", IdentityCode = 255 };
instance.GetType().GetProperty("ID")
.SetValue(instance, 100L, null);
return instance;
}
public ActionResult Edit(Salesman salesman)
{
try
{
_salesmanRepository.SaveOrUpdate(salesman);
return RedirectToAction("Index");
}
catch
{
return View();
}
}
public void PrototypeMembersShouldOnlyBeInherited()
{
dynamic person = new Person();
dynamic emp = new Employee();
dynamic sales = new Salesman();
dynamic mgr = new Manager();
emp.Prototype.Name = "Josh";
Assert.Equal("Josh", sales.Name);
Assert.Equal("Josh", mgr.Name);
Assert.Equal(Proto.Undefined, person.NoWhereElse);
}
public void PrototypeMembersShouldBeAvailableToDerivedTypes()
{
dynamic obj = new ProtoObject();
obj.Prototype.Name = "Josh";
dynamic person = new Person();
dynamic emp = new Employee();
dynamic sales = new Salesman();
dynamic mgr = new Manager();
Assert.Equal("Josh", person.Name);
Assert.Equal("Josh", emp.Name);
Assert.Equal("Josh", sales.Name);
Assert.Equal("Josh", mgr.Name);
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public TradeContract GetContract(int id)
{
var sal = new Salesman(false) { Name = "Craig", Surname = "Davis", Email = "*****@*****.**", IdentityCode = 255 };
sal.GetType().GetProperty("ID")
.SetValue(sal, Convert.ToInt64(id), null);
TradeContract instance = new CarContract
{
BeginDate = new DateTime(2010, 10, 1),
BrandName = "Porsche",
Description = "fattura di test",
Number = 12000000,
Owner = sal,
Price = 50500
};
return instance;
}
void RunRouteChangedCommand()
{
using (var container = NestedContainer)
{
ISalesmanRouteRepository _salesmanRouteService = Using<ISalesmanRouteRepository>(container);
Salesmen.Clear();
var salesman = new Salesman {Id = Guid.Empty, Username = "******"};
Salesmen.Add(salesman);
SelectedSalesman = salesman;
OverallRecipient = salesman;
if (SelectedRoute != null && SelectedRoute.Id != Guid.Empty)
{
string[] salesmenwarehouses =
_salesmanRouteService.GetAll().Where(n => n.Route != null && n.Route.Id == SelectedRoute.Id).
Select(
c => c.DistributorSalesmanRef.Id.ToString()).ToArray();
_allSalesmen.Where(u => salesmenwarehouses.Contains(u.CostCentre.ToString())).ToList().ForEach(
n => Salesmen.Add(new Salesman {Id = n.Id, Username = n.Username}));
}
else
{
if (OrderedSalesmen != null)
OrderedSalesmen.ForEach(n => Salesmen.Add(n));
}
}
}
/// <summary>
///
/// </summary>
/// <param name="instance"></param>
/// <param name="code"></param>
/// <returns></returns>
public Salesman UpdateCode(Salesman instance, int code)
{
if (instance == null)
return null;
instance.IdentityCode = code;
return instance;
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Salesman GetSalesman(long id)
{
var instance = new Salesman(false) { Name = "Craig", Surname = "Davis", Email = "*****@*****.**", IdentityCode = 255 };
instance.GetType().GetProperty("ID")
.SetValue(instance, id, null);
return instance;
}
public void FailedMakePersistentSave2Test()
{
/*
* NOTA:
* This test tries to save an transient instance which properties state is copied by a persistent instance.
* So.. in a few words, the calling of MakePersistent method tries to update the given instance (if this one is persistent)
* otherwise MakePersistent method tries to save it, but It can throw an exception if the given transient state instance
* is equals to an existing persistent state into data store.
*/
SessionProvider.BeginTransaction(IsolationLevel.ReadCommitted);
Salesman cons = CurrentPagedDAO.ExecuteExpression<Salesman, Salesman>(saleswoman => saleswoman.First());
Salesman cons2 = new Salesman
{
//ID = cons.ID,
IdentityCode = cons.IdentityCode,
Name = cons.Name,
Surname = cons.Surname,
Email = cons.Email
};
cons2.UpdateId(cons);
cons2.UpdateVersion(cons);
try
{
CurrentPagedDAO.MakePersistent(cons2);
SessionProvider.CommitTransaction();
}
catch (Exception)
{
SessionProvider.RollbackTransaction();
DiscardCurrentSession();
throw;
}
}
public void MakePersistentSaveTest()
{
SessionProvider.BeginTransaction(IsolationLevel.ReadCommitted);
Salesman cons = new Salesman
{
Name = "Maria",
Surname = "Bonita",
IdentityCode = 450,
Email = "*****@*****.**"
};
CurrentPagedDAO.MakePersistent(cons);
Assert.IsTrue(CurrentPagedDAO.IsCached(cons));
CurrentPagedDAO.Evict(cons);
SessionProvider.RollbackTransaction();
}
static void GetSalesmenAndRoutes()
{
bool boolSessionBegun = false;
QBSessionManager sessionManager = new QBSessionManager();
try
{
IMsgSetRequest requestMsgSet;
IMsgSetResponse responseMsgSet;
sessionManager.OpenConnection("", _appName);
sessionManager.BeginSession(qdbpath, ENOpenMode.omDontCare);
boolSessionBegun = true;
requestMsgSet = GetLatestMsgSetRequest(sessionManager);
requestMsgSet.Attributes.OnError = ENRqOnError.roeStop;
// ISalesTaxCodeRetList
ISalesRepQuery repsQuery = requestMsgSet.AppendSalesRepQueryRq();
// repsQuery.ORListQuery.FullNameList.Add(name);
responseMsgSet = sessionManager.DoRequests(requestMsgSet);
IResponse response = responseMsgSet.ResponseList.GetAt(0);
ISalesRepRetList repsList = response.Detail as ISalesRepRetList;
var salemen = new List<Salesman>();
if (repsList != null && repsList.Count > 0)
{
var company = GetCurrentCompany();
for (var i = 0; i < repsList.Count; i++)
{
ISalesRepRet rep = repsList.GetAt(i);
if (rep != null && rep.IsActive.GetValue())
{
var result = new Salesman()
{
distributrCode =company!=null?company.CompanyName.GetValue(): "",
name = rep.SalesRepEntityRef != null ? rep.Initial.GetValue() : "",//rep.SalesRepEntityRef != null ? rep.SalesRepEntityRef.FullName.GetValue() : "",
salesmanCode = rep.SalesRepEntityRef != null ? rep.Initial.GetValue() : "",
mobileNumber =""
};
salemen.Add(result);
}
}
}
sessionManager.EndSession();
boolSessionBegun = false;
sessionManager.CloseConnection();
if (salemen.Any())
{
DumpExportFilesAsync(salemen.ToCsv(), MasterDataCollective.DistributorSalesman.ToString());
var routes = salemen.Select(n=>new
{
Name=n.name,
Code = n.salesmanCode,
Region="default" //todo=>Figute out how to determine regions for each route
}).ToCsv();
DumpExportFilesAsync(routes, MasterDataCollective.Route.ToString());
}
}
catch (Exception ex)
{
if (boolSessionBegun)
{
sessionManager.EndSession();
sessionManager.CloseConnection();
}
string error = (ex.Message.ToString() + "\nStack Trace: \n" + ex.StackTrace + "\nExiting the application");
Log(error);
MessageBox.Show(error);
}
}
protected List<Bills> GeListByDt(DataTable dt, string name)
{
var list = new List<Bills>();
try
{
var productRepository = ComMethod.GetRepository<Products>();
var saleManRepository = ComMethod.GetRepository<Salesman>();
var merchantRepository = ComMethod.GetRepository<Merchants>();
var billsRepository = ComMethod.GetRepository<Bills>();
foreach (DataRow row in dt.Rows)
{
var productName = row["产品"].ToString();
var merchantNo = row["商户编号"].ToString();
var product = productRepository.Table.FirstOrDefault(p => p.Name == productName);
var saleMan = saleManRepository.Table.FirstOrDefault(p => p.Name == name);
var merchant = merchantRepository.Table.FirstOrDefault(p => p.MerchantNo == merchantNo);
if (product == null)
{
product = new Products() { Name = productName };
productRepository.Insert(product);
product = productRepository.Table.FirstOrDefault(p => p.Name == productName);
}
if (saleMan == null)
{
saleMan = new Salesman() { Name = name };
saleManRepository.Insert(saleMan);
saleMan = saleManRepository.Table.FirstOrDefault(p => p.Name == name);
}
if (merchant == null)
{
merchant = new Merchants()
{
MerchantNo = merchantNo,
Name = row["商户"].ToString()
};
merchantRepository.Insert(merchant);
merchant = merchantRepository.Table.FirstOrDefault(p => p.MerchantNo == merchantNo);
}
var model = new Bills
{
Product = product,
ProductId = product.Id,
ChargeSource = row["计费来源"].ToString(),
Salesman = saleMan,
SalesmanId = saleMan.Id,
ServiceRequestNo = row["业务请求编号"].ToString(),
Merchant = merchant,
MerchantId = merchant.Id,
Amount = decimal.Parse(row["计费金额"].ToString()),
TradingTime = DateTime.Parse(row["交易时间"].ToString().ComTime()),
CompletionTime = DateTime.Parse(row["完成时间"].ToString().ComTime()),
ProductExpense = decimal.Parse(row["产品费用"].ToString()),
CompleteState = row["状态"].ToString() == "已完成"
};
billsRepository.Insert(model);
}
}
catch (Exception ex)
{
//写入日志
}
return list;
}
private Order CreateOrder(string deliveryCountry)
{
var customer = new Customer("Luis", "Palacios", "54115678654");
var salesman = new Salesman("Alberto", "Martinez", 4000, 4);
return new Order(customer, salesman, "Los claveles 452", "New York", deliveryCountry, DateTime.Now);
}
/// <summary>
///
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public IEnumerable<TradeContract> GetPagedContract(int pageIndex, int pageSize)
{
var sal1 = new Salesman(false) { Name = "Craig", Surname = "Davis", Email = "*****@*****.**", IdentityCode = 255 };
sal1.GetType().GetProperty("ID")
.SetValue(sal1, 100L, null);
TradeContract instance1 = new CarContract
{
BeginDate = new DateTime(2010, 10, 1),
BrandName = "Porsche",
Description = "fattura di test",
Number = 12000000,
Owner = sal1,
Price = 50500
};
var sal2 = new Salesman(false) { Name = "james", Surname = "hold", Email = "*****@*****.**", IdentityCode = 255 };
sal2.GetType().GetProperty("ID")
.SetValue(sal1, 115L, null);
TradeContract instance2 = new CarContract
{
BeginDate = new DateTime(2011, 10, 1),
BrandName = "Porsche",
Description = "fattura di test",
Number = 12000000,
Owner = sal2,
Price = 50500
};
return new List<TradeContract> { instance1, instance2 };
}
static void Main(string[] args) {
Salesman salesIsLikeABoxOfChocolates = new Salesman(10000, 40000, 0.001);
salesIsLikeABoxOfChocolates.Run();
}
public bool Update(Salesman salesman)
{
try
{
string sql = "UPDATE salesman SET Account=?Account,PassWord=?PassWord,Name=?Name,AliAccount=?AliAccount WHERE SalesmanId=?SalesmanId ";
MySqlParameter[] parameter = new MySqlParameter[] {
new MySqlParameter("?SalesmanId", salesman.SalesmanId),
new MySqlParameter("?Account", salesman.Account),
new MySqlParameter("?PassWord", salesman.PassWord) ,
new MySqlParameter("?Name", salesman.Name) ,
new MySqlParameter("?AliAccount", salesman.AliAccount)
};
return MySqlHelper.ExecuteNonQuery(CommandType.Text, sql, parameter) == 1;
}
catch (Exception e)
{
MySqlHelper.CloseDBConnection();
throw e;
}
finally
{
}
}
public Bills()
{
Salesman=new Salesman();
Product=new Products();
Merchant=new Merchants();
}
private void LoadSalesmen()
{
Salesmen.Clear();
var salesmanNullo = new Salesman
{
UserId = Guid.Empty,
CostCentreId = Guid.Empty,
Username = "******"
};
Salesmen.Add(salesmanNullo);
using (StructureMap.IContainer c = NestedContainer)
{
Using<IUserRepository>(c).GetAll()
.Where(n => n.UserType == UserType.DistributorSalesman)
.Select(n => new Salesman
{
UserId = n.Id,
CostCentreId = n.CostCentre,
Username = n.Username
})
.ToList().ForEach(n => Salesmen.Add(n));
}
SelectedSalesman = salesmanNullo;
}
public void LoadDefaultSalesman()
{
using (var container = NestedContainer)
{
ISalesmanRouteRepository _salesmanRouteService = Using<ISalesmanRouteRepository>(container);
IUserRepository _userService = Using<IUserRepository>(container);
Salesmen.Clear();
var salesman = new Salesman
{
Id = Guid.Empty,
Username = GetLocalText("sl.dispatchorders.salesman.default")
/*"--Please Select a Salesman--"*/
};
Salesmen.Add(salesman);
SelectedSalesman = salesman;
OverallRecipient = salesman;
string[] salesmenwarehouses =
_salesmanRouteService.GetAll().Where(n => n.Route.Id == SelectedRoute.Id).Select(
c => c.DistributorSalesmanRef.Id.ToString()).ToArray();
_userService.GetAll().Where(u => salesmenwarehouses.Contains(u.CostCentre.ToString())).ToList().ForEach(
n => Salesmen.Add(new Salesman {Id = n.Id, Username = n.Username}));
}
}
public void should_get_salesman_quota()
{
var salesman = new Salesman();
Assert.Equal(100, salesman.GetSalesmanQuota());
}
void LoadAllSalesmen()
{
using (var container = NestedContainer)
{
IUserRepository _userService = Using<IUserRepository>(container);
Salesmen.Clear();
var salesman = new Salesman {Id = Guid.Empty, Username = "******"};
Salesmen.Add(salesman);
SelectedSalesman = salesman;
OverallRecipient = salesman;
_userService.GetAll().Where(n => n.UserType == UserType.DistributorSalesman).ToList().ForEach(
n => Salesmen.Add(new Salesman {Id = n.Id, Username = n.Username}));
}
}
bool CheckRecipientIsActive(Salesman salesman)
{
using (var container = NestedContainer)
{
IUserRepository _userService = Using<IUserRepository>(container);
var salesmanUser = _userService.GetById(salesman.Id, true);
if (salesmanUser != null && salesmanUser._Status == EntityStatus.Active)
return true;
return false;
}
}
public void TestCriteriaCompiled()
{
ICriteriaBuilder criteriaBuilder = new CriteriaBuilder(SessionFactory.GetClassMetadata);
Salesman instance = new Salesman(1);
ICriteriaCompiled criteriaCompiled = null;
criteriaCompiled = criteriaBuilder.MakeCriteria(instance as object);
Assert.AreEqual(criteriaCompiled.RootAlias, "salesman");
Assert.AreEqual(criteriaCompiled.RootType, typeof(Salesman));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 1);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.IsTrue(lista.Count == 1);
}
criteriaCompiled = criteriaBuilder.MakeCriteria(instance as object, "sal");
Assert.AreEqual(criteriaCompiled.RootAlias, "sal");
Assert.AreEqual(criteriaCompiled.RootType, typeof(Salesman));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 1);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.IsTrue(lista.Count == 1);
}
criteriaCompiled = criteriaBuilder.MakeCriteria(instance);
Assert.AreEqual(criteriaCompiled.RootAlias, "salesman");
Assert.AreEqual(criteriaCompiled.RootType, typeof(Salesman));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 1);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.IsTrue(lista.Count == 1);
}
criteriaCompiled = criteriaBuilder.MakeCriteria(instance, "sal");
Assert.AreEqual(criteriaCompiled.RootAlias, "sal");
Assert.AreEqual(criteriaCompiled.RootType, typeof(Salesman));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 1);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.IsTrue(lista.Count == 1);
}
criteriaCompiled = criteriaBuilder.MakeCriteria(typeof(Salesman), instance);
Assert.AreEqual(criteriaCompiled.RootAlias, "salesman");
Assert.AreEqual(criteriaCompiled.RootType, typeof(Salesman));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 1);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.IsTrue(lista.Count == 1);
}
criteriaCompiled = criteriaBuilder.MakeCriteria(typeof(Salesman), instance, "sal");
Assert.AreEqual(criteriaCompiled.RootAlias, "sal");
Assert.AreEqual(criteriaCompiled.RootType, typeof(Salesman));
Assert.AreEqual(criteriaCompiled.Restrictions.Count(), 1);
using (ISession session = SessionFactory.OpenSession())
{
var lista = criteriaCompiled.Criteria.GetExecutableCriteria(session).List();
Assert.IsTrue(lista.Count == 1);
}
}
