// 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);
}
// POST api/awbuildversion
public void Post(SalesTerritoryHistory value)
{
adventureWorks_BC.SalesTerritoryHistoryAdd(value);
}
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;
}
}
