/// <summary>
/// LoadData
/// </summary>
private void LoadData()
{
Facade.DeliveryWindow facDeliveryWindowSetup = new Orchestrator.Facade.DeliveryWindow();
DataSet ds = facDeliveryWindowSetup.GetMatrix();
RadGrid1.DataSource = ds;
}
/// <summary>
/// Delete Button pressed
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnDelete_Click(object sender, EventArgs e)
{
// Delete the current window
Facade.DeliveryWindow facDeliveryWindowSetup = new Orchestrator.Facade.DeliveryWindow();
facDeliveryWindowSetup.DeleteWindow(SelectedMatrix);
// redirect back to list page
Response.Redirect(string.Format("Matrix.aspx?id={0}", SelectedWindow));
}
/// <summary>
/// Populate Delivery Matrix
/// </summary>
private void PopulateDeliveryMatrix()
{
Facade.DeliveryWindow facDeliveryWindowSetup = new Orchestrator.Facade.DeliveryWindow();
DataSet ds = facDeliveryWindowSetup.GetMatrix();
cboDeliveryPeriod.DataSource = ds.Tables[0];
cboDeliveryPeriod.DataTextField = "ZoneDescDropDown";
cboDeliveryPeriod.DataValueField = "DeliveryWindowMatrixID";
cboDeliveryPeriod.DataBind();
}
public static int CreateDeliveryWindow(string description, int zoneMapID)
{
var facDeliveryWindow = new Orchestrator.Facade.DeliveryWindow();
if (facDeliveryWindow.CheckMatrix(description, zoneMapID) > 0)
{
throw new Exception("Zone and Description already exist");
}
var deliveryWindowID = facDeliveryWindow.AddMatrix(description, zoneMapID, HttpContext.Current.User.Identity.Name);
return(deliveryWindowID);
}
/// <summary>
/// Page_Load
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
Orchestrator.WebUI.Security.Authorise.EnforceAuthorisation(eSystemPortion.AddEditRate);
switch (Mode)
{
case "Delete":
Facade.DeliveryWindow facDeliveryWindowSetup = new Orchestrator.Facade.DeliveryWindow();
facDeliveryWindowSetup.DeleteMatrix(SelectedWindow, HttpContext.Current.User.Identity.Name);
break;
}
LoadStaticData();
LoadData();
}
protected void btnAddEffectiveDate_Click(object sender, EventArgs e)
{
SetEditScreen(true);
dteEffectiveFrom.SelectedDate = DateTime.Now.Date;
Facade.DeliveryWindow facDeliveryWindowSetup = new Orchestrator.Facade.DeliveryWindow();
int sundayAdjustmentHours = SafeParse(txtSundayAdjustmentHours.Text, 0);
int mondayAdjustmentHours = SafeParse(txtMondayAdjustmentHours.Text, 0);
int multiCollectTransitionHours = SafeParse(txtMultiCollectionTime.Text, 1);
string description = txtDescription.Text;
var deliveryWindowType = (eDeliveryWindowType)int.Parse(cboDeliveryWindowType.SelectedValue);
DateTime effectiveDate = dteEffectiveFrom.SelectedDate.Value;
SelectedMatrix = facDeliveryWindowSetup.AddDeliveryWindowDetails(SelectedWindow, sundayAdjustmentHours, mondayAdjustmentHours, multiCollectTransitionHours, deliveryWindowType, effectiveDate, Page.User.Identity.Name);
GetHeader(SelectedWindow);
}
/// <summary>
/// GetHeader
/// </summary>
/// <param name="matrixId"></param>
protected void GetHeader(int matrixId)
{
Facade.DeliveryWindow facDeliveryWindowSetup = new Orchestrator.Facade.DeliveryWindow();
DataSet ds = facDeliveryWindowSetup.GetMatrixDetails(this.SelectedWindow, SelectedMatrix);
txtDescription.Text = GetColumnValue(ds, "Description");
txtZone.Text = GetColumnValue(ds, "ZoneMap");
ddlEffectiveDates.DataSource = ds.Tables[1];
ddlEffectiveDates.DataTextField = "EffectiveDate";
ddlEffectiveDates.DataValueField = "DeliveryWindowId";
ddlEffectiveDates.DataBind();
GenerateScreenFromDataSet(ds, true);
}
/// <summary>
/// Save data
/// </summary>
private void SaveData()
{
Table currentTable = tblDelWindow;
String updates = hidDelWindowChanges.Value;
// create otherwise an update
Facade.DeliveryWindow facDeliveryWindowSetup = new Orchestrator.Facade.DeliveryWindow();
try
{
int sundayAdjustmentHours = int.Parse(txtSundayAdjustmentHours.Text);
int mondayAdjustmentHours = int.Parse(txtMondayAdjustmentHours.Text);
int multiCollectTransitionHours = int.Parse(txtMultiCollectionTime.Text);
var deliveryWindowType = (eDeliveryWindowType)int.Parse(cboDeliveryWindowType.SelectedValue);
DateTime effectiveDate = dteEffectiveFrom.SelectedDate.Value;
// Validate the delivery Window is correct
if (facDeliveryWindowSetup.CheckDeliveryWindow(effectiveDate, SelectedWindow, SelectedMatrix))
{
ClientMessage("You can only use an effective date once");
}
else
{
facDeliveryWindowSetup.UpdateDeliveryWindow(SelectedMatrix,
sundayAdjustmentHours, mondayAdjustmentHours, multiCollectTransitionHours, txtDescription.Text, deliveryWindowType, effectiveDate, true, Page.User.Identity.Name);
// check to see if there are any updates
if (updates.Length > 0)
{
UpdateCells(updates);
}
}
GetHeader(SelectedWindow);
}
catch (Exception ex)
{
String newError = string.Format("Unexpected error {0} {1}", ex.Message, ex.InnerException);
ClientMessage(newError);
}
}
/// <summary>
/// Process which cells have been changed and update the database
/// </summary>
/// <param name="updates"></param>
private void UpdateCells(String updates)
{
Facade.DeliveryWindow facDeliveryWindowSetup = new Orchestrator.Facade.DeliveryWindow();
//
string[] cellIds = updates.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string updateCommand in cellIds)
{
string data = this.Request.Form[updateCommand];
int timeData = 0;
string[] cellDetail = updateCommand.Split(new char[] { ':' }, StringSplitOptions.RemoveEmptyEntries);
Int32 zoneId = Int32.Parse(cellDetail[1]);
Int32 timeWindow = Int32.Parse(cellDetail[2]);
String updateCell = cellDetail[0].Substring(cellDetail[0].Length - 1); // get last character
switch (updateCell)
{
case "H":
timeData = int.Parse(data);
facDeliveryWindowSetup.UpdateDeliveryTimes(SelectedMatrix, zoneId, timeWindow, timeData, null, null, Page.User.Identity.Name);
break;
case "M":
timeData = int.Parse(data);
facDeliveryWindowSetup.UpdateDeliveryTimes(SelectedMatrix, zoneId, timeWindow, null, timeData, null, Page.User.Identity.Name);
break;
case "B":
if (data == null)
{
data = string.Empty;
}
Boolean adjustMonday = data.ToUpper() == "ON" ? true : false;
facDeliveryWindowSetup.UpdateDeliveryTimes(SelectedMatrix, zoneId, timeWindow, null, null, adjustMonday, Page.User.Identity.Name);
break;
}
}
hidDelWindowChanges.Value = string.Empty;
}
