private int DeleteTerritory() { Cursor.Current = Cursors.WaitCursor; SalesTerritory st = new SalesTerritory(); int terrID = 0; try { terrID = Int32.Parse(lblTerritoryID.Text); } catch { MessageBox.Show("Select a territory to delete", "Sales Territory", MessageBoxButtons.OK, MessageBoxIcon.Error); Cursor.Current = Cursors.Default; return(0); } try { st.RemoveSalesTerritory(terrID); } catch (Exception ex) { MessageBox.Show(ex.Message, "Sales Territory", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { st = null; Cursor.Current = Cursors.Default; } return(terrID); }
///<summary> /// Returns a Typed SalesTerritoryHistory Entity with mock values. ///</summary> static public SalesTerritoryHistory CreateMockInstance_Generated(TransactionManager tm) { SalesTerritoryHistory mock = new SalesTerritoryHistory(); mock.StartDate = TestUtility.Instance.RandomDateTime(); mock.EndDate = TestUtility.Instance.RandomDateTime(); mock.ModifiedDate = TestUtility.Instance.RandomDateTime(); //OneToOneRelationship SalesPerson mockSalesPersonBySalesPersonId = SalesPersonTest.CreateMockInstance(tm); DataRepository.SalesPersonProvider.Insert(tm, mockSalesPersonBySalesPersonId); mock.SalesPersonId = mockSalesPersonBySalesPersonId.SalesPersonId; //OneToOneRelationship SalesTerritory mockSalesTerritoryByTerritoryId = SalesTerritoryTest.CreateMockInstance(tm); DataRepository.SalesTerritoryProvider.Insert(tm, mockSalesTerritoryByTerritoryId); mock.TerritoryId = mockSalesTerritoryByTerritoryId.TerritoryId; // create a temporary collection and add the item to it TList <SalesTerritoryHistory> tempMockCollection = new TList <SalesTerritoryHistory>(); tempMockCollection.Add(mock); tempMockCollection.Remove(mock); return((SalesTerritoryHistory)mock); }
private void PopulateTerritories(int selectedID) { SalesTerritory st = new SalesTerritory(); colTerritories = new SalesTerritoryCollection(); try { colTerritories = st.GetAllSalesTerritoryCollection(); gridTerritory.DataSource = colTerritories; gridTerritory.Columns.Remove("ModifiedDate"); gridTerritory.Columns["TerritoryID"].Visible = false; gridTerritory.Columns.Remove("CountryRegionCode"); int index = 0; foreach (SalesTerritory t in colTerritories) { if (t.TerritoryID == selectedID) { gridTerritory.Rows[index].Selected = true; gridTerritory.FirstDisplayedScrollingRowIndex = index; break; } index++; } } catch (Exception ex) { MessageBox.Show(ex.Message, "Sales Territory", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private int AddTerritory() { Cursor.Current = Cursors.WaitCursor; SalesTerritory st = new SalesTerritory(); int id = 0; try { string territory = txtTerritory.Text.Trim(); st.Name = territory; st.ModifiedDate = DateTime.Now; st.CountryRegionCode = string.Empty; id = st.AddSalesTerritory(st); } catch (Exception ex) { Cursor.Current = Cursors.Default; MessageBox.Show(ex.Message, "Sales Territory", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { Cursor.Current = Cursors.Default; } return(id); }
public void SaveSalesTerritory(SalesTerritory salesTerritory) { string connectionString = ConfigurationManager.ConnectionStrings["CustomerDatabase"].ConnectionString; // Test to see if there is a valid database connection. // Return null if there isn't. // Since this is a demo app, the users should be able to use it whether or not a valid database exists or not. SqlConnection testConnection = new SqlConnection(connectionString); try { testConnection.Open(); } catch (Exception ex) { logger.Fatal(ex.ToString()); testConnection.Close(); return; } testConnection.Close(); try { SaveSalesTerritoryADO("dbo.SaveSalesTerritory", salesTerritory); } catch (Exception ex) { logger.Fatal(ex.ToString()); throw; } return; }
public void ExportTerritories() { SqlCompactConnection conn = new SqlCompactConnection(); SalesTerritory ter = new SalesTerritory(); try { SalesTerritoryCollection colTerr = ter.GetAllSalesTerritoryCollection(); conn.SynchForm = this; conn.DropSalesTerritoryTable(); conn.CreateTerritoryTable(); conn.AddSalesTerritory(colTerr); ter = null; colTerr = null; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.CloseDatabase(); conn = null; } }
public IHttpActionResult PutSalesTerritory(int id, SalesTerritory salesTerritory) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != salesTerritory.TerritoryID) { return(BadRequest()); } db.Entry(salesTerritory).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!SalesTerritoryExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public TerritoryData(SalesTerritory st) { this.TerritoryID = st.TerritoryID; this.Name = st.Name; this.CountryRegionCode = st.CountryRegionCode; this.Group = st.Group; }
private SalesTerritory SaveSalesTerritoryADO(string queryString, SalesTerritory salesTerritory) { // Create and open the connection in a using block. This // ensures that all resources will be closed and disposed // when the code exits. using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(queryString, connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@TerritoryID", salesTerritory.territoryID); command.Parameters.AddWithValue("@Name", salesTerritory.region); command.Parameters.AddWithValue("@Country", salesTerritory.country); command.Parameters.AddWithValue("@Group", salesTerritory.group); command.Parameters.AddWithValue("@SalesYTD", salesTerritory.salesYTD); command.Parameters.AddWithValue("@SalesLastYear", salesTerritory.salesLastYear); command.Parameters.AddWithValue("@CostYTD", salesTerritory.costYTD); command.Parameters.AddWithValue("@CostLastYear", salesTerritory.costLastYear); try { connection.Open(); salesTerritory.territoryID = (int)command.ExecuteScalar(); } catch (Exception ex) { logger.Fatal(ex.ToString()); throw; } } return(salesTerritory); }
public int AddSalesTerritory(SalesTerritory ST) { IDBManager dbm = new DBManager(); try { dbm.CreateParameters(4); dbm.AddParameters(0, "@Name", ST.Name); dbm.AddParameters(1, "@CountryRegionCode", ST.CountryRegionCode); dbm.AddParameters(2, "@ModifiedDate", DateTime.Now); dbm.AddParameters(3, "@TerritoryID", ST.TerritoryID); dbm.Parameters[3].Direction = ParameterDirection.Output; dbm.ExecuteNonQuery(CommandType.StoredProcedure, "InsertSalesTerritory"); ST.TerritoryID = Int32.Parse(dbm.Parameters[3].Value.ToString()); } catch (Exception ex) { log.Write(ex.Message, "InsertSalesTerritory"); throw (ex); } finally { dbm.Dispose(); } return(ST.TerritoryID); }
private void LoadTerritoris() { SalesTerritory terr = new SalesTerritory(); SalesTerritoryCollection terrCol = new SalesTerritoryCollection(); try { terrCol = terr.GetAllSalesTerritoryCollection(); terr.TerritoryID = 0; terr.Name = "All"; terr.ModifiedDate = DateTime.Now; terrCol.Insert(0, terr); cmbTerritory.DataSource = terrCol; cmbTerritory.DisplayMember = "Name"; cmbTerritory.ValueMember = "TerritoryID"; } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { terr = null; } }
public SalesTerritory GetSalesTerritory(int TerritoryID) { IDBManager dbm = new DBManager(); SalesTerritory ST = new SalesTerritory(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@TerritoryID", TerritoryID); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesTerritory"); while (reader.Read()) { ST.TerritoryID = Int32.Parse(reader["TerritoryID"].ToString()); ST.Name = reader["Name"].ToString(); ST.CountryRegionCode = reader["CountryRegionCode"].ToString(); ST.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); } } catch (Exception ex) { log.Write(ex.Message, "GetSalesTerritory"); throw (ex); } finally { dbm.Dispose(); } return(ST); }
public SalesTerritoryCollection GetAllSalesTerritorysDynamicCollection(string whereExpression, string orderBy) { IDBManager dbm = new DBManager(); SalesTerritoryCollection cols = new SalesTerritoryCollection(); try { dbm.CreateParameters(2); dbm.AddParameters(0, "@WhereCondition", whereExpression); dbm.AddParameters(1, "@OrderByExpression", orderBy); IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesTerritorysDynamic"); while (reader.Read()) { SalesTerritory ST = new SalesTerritory(); ST.TerritoryID = Int32.Parse(reader["TerritoryID"].ToString()); ST.Name = reader["Name"].ToString(); ST.CountryRegionCode = reader["CountryRegionCode"].ToString(); ST.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(ST); } } catch (Exception ex) { log.Write(ex.Message, "GetAllSalesTerritorysDynamicCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public SalesTerritoryCollection GetAllSalesTerritorysCollection() { IDBManager dbm = new DBManager(); SalesTerritoryCollection cols = new SalesTerritoryCollection(); try { IDataReader reader = dbm.ExecuteReader(CommandType.StoredProcedure, "SelectSalesTerritoryAll"); while (reader.Read()) { SalesTerritory ST = new SalesTerritory(); ST.TerritoryID = Int32.Parse(reader["TerritoryID"].ToString()); ST.Name = reader["Name"].ToString(); ST.CountryRegionCode = reader["CountryRegionCode"].ToString(); ST.ModifiedDate = DateTime.Parse(reader["ModifiedDate"].ToString()); cols.Add(ST); } } catch (Exception ex) { log.Write(ex.Message, "GetAllSalesTerritorysCollection"); throw (ex); } finally { dbm.Dispose(); } return(cols); }
public async Task <IActionResult> Edit(int id, [Bind("TerritoryId,Name,CountryRegionCode,Group,SalesYtd,SalesLastYear,CostYtd,CostLastYear,Rowguid,ModifiedDate")] SalesTerritory salesTerritory) { if (id != salesTerritory.TerritoryId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(salesTerritory); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SalesTerritoryExists(salesTerritory.TerritoryId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["CountryRegionCode"] = new SelectList(_context.CountryRegion, "CountryRegionCode", "CountryRegionCode", salesTerritory.CountryRegionCode); return(View(salesTerritory)); }
/// <summary> /// Deep load all SalesTerritory children. /// </summary> private void Step_03_DeepLoad_Generated() { using (TransactionManager tm = CreateTransaction()) { int count = -1; mock = CreateMockInstance(tm); mockCollection = DataRepository.SalesTerritoryProvider.GetPaged(tm, 0, 10, out count); DataRepository.SalesTerritoryProvider.DeepLoading += new EntityProviderBaseCore <SalesTerritory, SalesTerritoryKey> .DeepLoadingEventHandler( delegate(object sender, DeepSessionEventArgs e) { if (e.DeepSession.Count > 3) { e.Cancel = true; } } ); if (mockCollection.Count > 0) { DataRepository.SalesTerritoryProvider.DeepLoad(tm, mockCollection[0]); System.Console.WriteLine("SalesTerritory instance correctly deep loaded at 1 level."); mockCollection.Add(mock); // DataRepository.SalesTerritoryProvider.DeepSave(tm, mockCollection); } //normally one would commit here //tm.Commit(); //IDisposable will Rollback Transaction since it's left uncommitted } }
/// <summary> /// Test Find using the Query class /// </summary> private void Step_30_TestFindByQuery_Generated() { using (TransactionManager tm = CreateTransaction()) { //Insert Mock Instance SalesTerritory mock = CreateMockInstance(tm); bool result = DataRepository.SalesTerritoryProvider.Insert(tm, mock); Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed"); SalesTerritoryQuery query = new SalesTerritoryQuery(); query.AppendEquals(SalesTerritoryColumn.TerritoryId, mock.TerritoryId.ToString()); query.AppendEquals(SalesTerritoryColumn.Name, mock.Name.ToString()); query.AppendEquals(SalesTerritoryColumn.CountryRegionCode, mock.CountryRegionCode.ToString()); query.AppendEquals(SalesTerritoryColumn.Group, mock.Group.ToString()); query.AppendEquals(SalesTerritoryColumn.SalesYtd, mock.SalesYtd.ToString()); query.AppendEquals(SalesTerritoryColumn.SalesLastYear, mock.SalesLastYear.ToString()); query.AppendEquals(SalesTerritoryColumn.CostYtd, mock.CostYtd.ToString()); query.AppendEquals(SalesTerritoryColumn.CostLastYear, mock.CostLastYear.ToString()); query.AppendEquals(SalesTerritoryColumn.Rowguid, mock.Rowguid.ToString()); query.AppendEquals(SalesTerritoryColumn.ModifiedDate, mock.ModifiedDate.ToString()); TList <SalesTerritory> results = DataRepository.SalesTerritoryProvider.Find(tm, query); Assert.IsTrue(results.Count == 1, "Find is not working correctly. Failed to find the mock instance"); } }
public async void Get() { var mock = new ServiceMockFacade <ISalesTerritoryRepository>(); var record = new SalesTerritory(); mock.RepositoryMock.Setup(x => x.Get(It.IsAny <int>())).Returns(Task.FromResult(record)); var service = new SalesTerritoryService(mock.LoggerMock.Object, mock.RepositoryMock.Object, mock.ModelValidatorMockFactory.SalesTerritoryModelValidatorMock.Object, mock.BOLMapperMockFactory.BOLSalesTerritoryMapperMock, mock.DALMapperMockFactory.DALSalesTerritoryMapperMock, mock.BOLMapperMockFactory.BOLCustomerMapperMock, mock.DALMapperMockFactory.DALCustomerMapperMock, mock.BOLMapperMockFactory.BOLSalesOrderHeaderMapperMock, mock.DALMapperMockFactory.DALSalesOrderHeaderMapperMock, mock.BOLMapperMockFactory.BOLSalesPersonMapperMock, mock.DALMapperMockFactory.DALSalesPersonMapperMock, mock.BOLMapperMockFactory.BOLSalesTerritoryHistoryMapperMock, mock.DALMapperMockFactory.DALSalesTerritoryHistoryMapperMock); ApiSalesTerritoryResponseModel response = await service.Get(default(int)); response.Should().NotBeNull(); mock.RepositoryMock.Verify(x => x.Get(It.IsAny <int>())); }
public SalesTerritory GetSalesTerritoryBySalesTerritoryID(int SalesTerritoryID) { SalesTerritoryBO salesTerritoryBO = new SalesTerritoryBO(); SalesTerritory salesTerritory = salesTerritoryBO.GetSalesTerritoryBySalesTerritoryID(SalesTerritoryID); return(salesTerritory); }
///<summary> /// Update the Typed SalesTerritory Entity with modified mock values. ///</summary> static public void UpdateMockInstance(TransactionManager tm, SalesTerritory mock) { SalesTerritoryTest.UpdateMockInstance_Generated(tm, mock); // make any alterations necessary // (i.e. for DB check constraints, special test cases, etc.) SetSpecialTestData(mock); }
public ActionResult DeleteConfirmed(int id) { SalesTerritory salesTerritory = db.SalesTerritory.Find(id); db.SalesTerritory.Remove(salesTerritory); db.SaveChanges(); return(RedirectToAction("Index")); }
public SalesTerritory SaveSalesTerritory(SalesTerritory salesTerritory) { SalesTerritoryBO salesTerritoryBO = new SalesTerritoryBO(); salesTerritoryBO.SaveSalesTerritory(salesTerritory); return(salesTerritory); }
/// <summary> /// Check the foreign key dal methods. /// </summary> private void Step_10_FK_Generated() { using (TransactionManager tm = CreateTransaction()) { SalesTerritory entity = CreateMockInstance(tm); bool result = DataRepository.SalesTerritoryProvider.Insert(tm, entity); Assert.IsTrue(result, "Could Not Test FK, Insert Failed"); } }
public ActionResult Edit([Bind(Include = "TerritoryID,Name,CountryRegionCode,Group,SalesYTD,SalesLastYear,CostYTD,CostLastYear,rowguid,ModifiedDate")] SalesTerritory salesTerritory) { if (ModelState.IsValid) { db.Entry(salesTerritory).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(salesTerritory)); }
/// <summary> /// Test methods exposed by the EntityHelper class. /// </summary> private void Step_20_TestEntityHelper_Generated() { using (TransactionManager tm = CreateTransaction()) { mock = CreateMockInstance(tm); SalesTerritory entity = mock.Copy() as SalesTerritory; entity = (SalesTerritory)mock.Clone(); Assert.IsTrue(SalesTerritory.ValueEquals(entity, mock), "Clone is not working"); } }
///<summary> /// Update the Typed SalesTerritory Entity with modified mock values. ///</summary> static public void UpdateMockInstance_Generated(TransactionManager tm, SalesTerritory mock) { mock.Name = TestUtility.Instance.RandomString(24, false);; mock.CountryRegionCode = TestUtility.Instance.RandomString(3, false);; mock.Group = TestUtility.Instance.RandomString(24, false);; mock.SalesYtd = TestUtility.Instance.RandomShort(); mock.SalesLastYear = TestUtility.Instance.RandomShort(); mock.CostYtd = TestUtility.Instance.RandomShort(); mock.CostLastYear = TestUtility.Instance.RandomShort(); mock.ModifiedDate = TestUtility.Instance.RandomDateTime(); }
public IHttpActionResult GetSalesTerritory(int id) { SalesTerritory salesTerritory = db.SalesTerritories.Find(id); if (salesTerritory == null) { return(NotFound()); } return(Ok(salesTerritory)); }
///<summary> /// Returns a Typed SalesTerritory Entity with mock values. ///</summary> static public SalesTerritory CreateMockInstance(TransactionManager tm) { // get the default mock instance SalesTerritory mock = SalesTerritoryTest.CreateMockInstance_Generated(tm); // make any alterations necessary // (i.e. for DB check constraints, special test cases, etc.) SetSpecialTestData(mock); // return the modified object return(mock); }
// PUT api/awbuildversion/5 public void Put(SalesTerritory value) { var GetActionType = Request.Headers.Where(x => x.Key.Equals("ActionType")).FirstOrDefault(); if (GetActionType.Key != null) { if (GetActionType.Value.ToList()[0].Equals("DELETE")) adventureWorks_BC.SalesTerritoryDelete(value); if (GetActionType.Value.ToList()[0].Equals("UPDATE")) adventureWorks_BC.SalesTerritoryUpdate(value); } }
public IHttpActionResult PostSalesTerritory(SalesTerritory salesTerritory) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.SalesTerritories.Add(salesTerritory); db.SaveChanges(); return(CreatedAtRoute("DefaultApi", new { id = salesTerritory.TerritoryID }, salesTerritory)); }
public async Task <IActionResult> Create([Bind("TerritoryId,Name,CountryRegionCode,Group,SalesYtd,SalesLastYear,CostYtd,CostLastYear,Rowguid,ModifiedDate")] SalesTerritory salesTerritory) { if (ModelState.IsValid) { _context.Add(salesTerritory); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["CountryRegionCode"] = new SelectList(_context.CountryRegion, "CountryRegionCode", "CountryRegionCode", salesTerritory.CountryRegionCode); return(View(salesTerritory)); }
private StateProvince GivenStateProvince(string code, string name, bool isOnlyStateProvince, CountryRegion country, SalesTerritory territory) { var state = new StateProvince { Code = code, Name = name, IsOnlyStateProvince = isOnlyStateProvince, SalesTerritory = territory, Country = country }; Inject(state); return state; }
/// <summary> /// There are no comments for SalesTerritory in the schema. /// </summary> public void AddToSalesTerritory(SalesTerritory salesTerritory) { base.AddObject("SalesTerritory", salesTerritory); }
/// <summary> /// Create a new SalesTerritory object. /// </summary> /// <param name="territoryID">Initial value of TerritoryID.</param> /// <param name="name">Initial value of Name.</param> /// <param name="countryRegionCode">Initial value of CountryRegionCode.</param> /// <param name="group">Initial value of Group.</param> /// <param name="salesYTD">Initial value of SalesYTD.</param> /// <param name="salesLastYear">Initial value of SalesLastYear.</param> /// <param name="costYTD">Initial value of CostYTD.</param> /// <param name="costLastYear">Initial value of CostLastYear.</param> /// <param name="rowguid">Initial value of rowguid.</param> /// <param name="modifiedDate">Initial value of ModifiedDate.</param> public static SalesTerritory CreateSalesTerritory(int territoryID, string name, string countryRegionCode, string group, decimal salesYTD, decimal salesLastYear, decimal costYTD, decimal costLastYear, global::System.Guid rowguid, global::System.DateTime modifiedDate) { SalesTerritory salesTerritory = new SalesTerritory(); salesTerritory.TerritoryID = territoryID; salesTerritory.Name = name; salesTerritory.CountryRegionCode = countryRegionCode; salesTerritory.Group = group; salesTerritory.SalesYTD = salesYTD; salesTerritory.SalesLastYear = salesLastYear; salesTerritory.CostYTD = costYTD; salesTerritory.CostLastYear = costLastYear; salesTerritory.rowguid = rowguid; salesTerritory.ModifiedDate = modifiedDate; return salesTerritory; }
// POST api/awbuildversion public void Post(SalesTerritory value) { adventureWorks_BC.SalesTerritoryAdd(value); }