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