// PUT api/awbuildversion/5 public void Put(SalesTerritoryHistory 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.SalesTerritoryHistoryDelete(value); if (GetActionType.Value.ToList()[0].Equals("UPDATE")) adventureWorks_BC.SalesTerritoryHistoryUpdate(value); } }
public bool SalesTerritoryHistoryUpdate(SalesTerritoryHistory salesterritoryhistory) { return(Execute <bool>(dal => { SalesTerritoryHistory salesterritoryhistoryUpdate = dal.SalesTerritoryHistory.Where(x => x.BusinessEntityID == salesterritoryhistory.BusinessEntityID).FirstOrDefault(); if (salesterritoryhistoryUpdate != null) { salesterritoryhistoryUpdate.BusinessEntityID = salesterritoryhistory.BusinessEntityID; salesterritoryhistoryUpdate.TerritoryID = salesterritoryhistory.TerritoryID; salesterritoryhistoryUpdate.StartDate = salesterritoryhistory.StartDate; salesterritoryhistoryUpdate.EndDate = salesterritoryhistory.EndDate; salesterritoryhistoryUpdate.rowguid = salesterritoryhistory.rowguid; salesterritoryhistoryUpdate.ModifiedDate = salesterritoryhistory.ModifiedDate; dal.SubmitChanges(); return true; } return false; })); }
public bool DeleteSalesTerritoryHistory(SalesTerritoryHistory STH) { IDBManager dbm = new DBManager(); try { dbm.CreateParameters(1); dbm.AddParameters(0, "@SalesPersonID", STH.SalesPersonID); dbm.ExecuteNonQuery(CommandType.StoredProcedure, "DeleteSalesTerritoryHistory"); } catch (Exception ex) { log.Write(ex.Message, "DeleteSalesTerritoryHistory"); throw (ex); } finally { dbm.Dispose(); } return(true); }
public bool UpdateSalesTerritoryHistory(SalesTerritoryHistory STH) { IDBManager dbm = new DBManager(); try { dbm.CreateParameters(3); dbm.AddParameters(0, "@ID", STH.ID); dbm.AddParameters(1, "@EndDate", STH.EndDate); dbm.AddParameters(2, "@ModifiedDate", DateTime.Now); dbm.ExecuteNonQuery(CommandType.StoredProcedure, "UpdateSalesTerritoryHistory"); } catch (Exception ex) { log.Write(ex.Message, "UpdateSalesTerritoryHistory"); throw (ex); } finally { dbm.Dispose(); } return(true); }
// POST api/awbuildversion public void Post(SalesTerritoryHistory value) { adventureWorks_BC.SalesTerritoryHistoryAdd(value); }
/// <summary> /// Create a new SalesTerritoryHistory object. /// </summary> /// <param name="salesPersonID">Initial value of SalesPersonID.</param> /// <param name="territoryID">Initial value of TerritoryID.</param> /// <param name="startDate">Initial value of StartDate.</param> /// <param name="rowguid">Initial value of rowguid.</param> /// <param name="modifiedDate">Initial value of ModifiedDate.</param> public static SalesTerritoryHistory CreateSalesTerritoryHistory(int salesPersonID, int territoryID, global::System.DateTime startDate, global::System.Guid rowguid, global::System.DateTime modifiedDate) { SalesTerritoryHistory salesTerritoryHistory = new SalesTerritoryHistory(); salesTerritoryHistory.SalesPersonID = salesPersonID; salesTerritoryHistory.TerritoryID = territoryID; salesTerritoryHistory.StartDate = startDate; salesTerritoryHistory.rowguid = rowguid; salesTerritoryHistory.ModifiedDate = modifiedDate; return salesTerritoryHistory; }
/// <summary> /// There are no comments for SalesTerritoryHistory in the schema. /// </summary> public void AddToSalesTerritoryHistory(SalesTerritoryHistory salesTerritoryHistory) { base.AddObject("SalesTerritoryHistory", salesTerritoryHistory); }
/// <summary> /// Make any alterations necessary (i.e. for DB check constraints, special test cases, etc.) /// </summary> /// <param name="mock">Object to be modified</param> static private void SetSpecialTestData(SalesTerritoryHistory mock) { //Code your changes to the data object here. mock.EndDate = mock.StartDate.AddDays(1); }
private void btnSave_Click(object sender, EventArgs e) { SalesTerritory st = new SalesTerritory(); SalesTerritoryHistory hist = new SalesTerritoryHistory(); try { if (txtName.Text.Trim() == String.Empty) { MessageBox.Show("Please enter territory name", "MICS", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } if (cmbSalesPerson.Items.Count == 0) { btnSave.Enabled = false; } else { btnSave.Enabled = true; } if (cmbSalesPerson.SelectedIndex == 0) { MessageBox.Show("Please select a sale person", "MICS", MessageBoxButtons.OK, MessageBoxIcon.Stop); return; } st.Name = txtName.Text; st.CountryRegionCode = txtCounty.Text; if (txtTerritoryID.Text.Trim() == String.Empty) { //new record hist.TerritoryID = st.AddSalesTerritory(st); hist.SalesPersonID = Int32.Parse(cmbSalesPerson.SelectedValue.ToString()); hist.StartDate = dtStartDate.Value; //hist.EndDate = null; hist.AddSalesTerritoryHistory(hist); MessageBox.Show("Record saved successfully", "MICS", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { //existing record, update territory and territory history st.TerritoryID = Int32.Parse(txtTerritoryID.Text); st.UpdateSalesTerritory(st); hist.ID = m_currentHistoryId; hist.SalesPersonID = Int32.Parse(cmbSalesPerson.SelectedValue.ToString()); hist.TerritoryID = st.TerritoryID; hist.StartDate = dtStartDate.Value; //hist.EndDate = dtEndDate.Value; hist.UpdateSalesTerritoryHistory(hist); //hist.AddSalesTerritoryHistory(hist); MessageBox.Show("Record saved successfully", "MICS", MessageBoxButtons.OK, MessageBoxIcon.Information); } RefreshForm(); } catch (Exception ex) { MessageBox.Show(ex.Message, "MICS", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { st = null; } }