private void PopulateStaticControls()
{
Facade.ExtraType facExtraType = new Orchestrator.Facade.ExtraType();
//cboExtraType.DataSource = facExtraType.GetForIsEnabled(getActiveExtraTypes); // Enum.GetNames(typeof(eExtraType));
//Get all Extras that apply to Subbies AND Pallet Networks
//At present this will only be the Hub Charge and at some point the Network and Subby Extras
//may need to be dealt with seperately
cboExtraType.DataSource = facExtraType.GetForAppliesTo(new List <eExtraAppliesTo>
{
eExtraAppliesTo.SubContractor, eExtraAppliesTo.Network
});
cboExtraType.DataValueField = "ExtraTypeId";
cboExtraType.DataTextField = "Description";
cboExtraType.DataBind();
cboExtraType.Items.Insert(0, "");
cboSelectExtraState.DataSource = Enum.GetNames(typeof(eExtraState));
cboSelectExtraState.DataBind();
cboSelectExtraState.Items.RemoveAt((int)eExtraState.Invoiced - 1);
cboSelectExtraState.Items.Insert(0, "");
if (m_IdentityId != 0)
{
//Get the Client name for id.
Facade.IOrganisation facOrg = new Facade.Organisation();
string name = facOrg.GetNameForIdentityId(m_IdentityId);
cboSubContractor.SelectedValue = m_IdentityId.ToString();
cboSubContractor.Text = name;
}
}
private void PopulateStaticControls()
{
Facade.ExtraType facExtraType = new Orchestrator.Facade.ExtraType();
bool? getActiveExtraTypes = true;
cboExtraType.DataSource = facExtraType.GetForIsEnabled(getActiveExtraTypes); // Enum.GetNames(typeof(eExtraType));
cboExtraType.DataValueField = "ExtraTypeId";
cboExtraType.DataTextField = "Description";
cboExtraType.DataBind();
cboExtraType.Items.Insert(0, "");
cboSelectExtraState.DataSource = Enum.GetNames(typeof(eExtraState));
cboSelectExtraState.DataBind();
cboSelectExtraState.Items.RemoveAt((int)eExtraState.Invoiced - 1);
cboSelectExtraState.Items.Insert(0, "");
if (m_IdentityId != 0)
{
//Get the Client name for id.
Facade.IOrganisation facOrg = new Facade.Organisation();
string name = facOrg.GetNameForIdentityId(m_IdentityId);
cboClient.SelectedValue = m_IdentityId.ToString();
cboClient.Text = name;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Facade.ExtraType facExtraType = new Orchestrator.Facade.ExtraType();
grdExtraTypes.DataSource = facExtraType.GetForIsEnabled(new bool?());
}
}
//------------------------------------------------------------------------------------
#endregion
//------------------------------------------------------------------------------------
#region Buttons
//------------------------------------------------------------------------------------
protected void btnExport_Click(object sender, EventArgs e)
{
int importedInvoiceId = 0;
int.TryParse(this.cboFile.SelectedValue, out importedInvoiceId);
int businessTypeId = 0;
int.TryParse(cboBusinessType.SelectedValue, out businessTypeId);
List <int> selectedOrderIDs = new List <int>();
selectedOrderIDs = this.GetOrderIdsForExport();
List <int> importedInvoiceItemIDsToExclude = new List <int>();
importedInvoiceItemIDsToExclude = this.GetImportedInvoiceItemIDsToExclude();
if (selectedOrderIDs.Count > 0)
{
Facade.ImportedInvoice facimportedInvoice = new Facade.ImportedInvoice();
DataSet ds = facimportedInvoice.GetOrdersForMatchingExport(importedInvoiceId, businessTypeId, selectedOrderIDs, importedInvoiceItemIDsToExclude);
Facade.ExtraType facExtraTypes = new Orchestrator.Facade.ExtraType();
List <Entities.ExtraType> extraTypes = facExtraTypes.GetForIsEnabled(true);
foreach (Entities.ExtraType et in extraTypes)
{
ds.Tables[0].Columns.Add("[" + et.Description + "]", typeof(decimal));
}
// Extra data
foreach (DataRow dr in ds.Tables[0].Rows)
{
DataRow[] extraRows = ds.Tables[1].Select("OrderID = " + dr["OrderID"]);
foreach (DataRow extra in extraRows)
{
if (dr.Table.Columns.Contains("[" + extra["ExtraType"] + "]"))
{
dr["[" + extra["ExtraType"] + "]"] = extra["ExtraAmount"];
}
}
}
Session["__ExportDS"] = ds.Tables[0];
Response.Redirect("../reports/csvexport.aspx?filename=InvoiceMatchingExport.CSV");
}
else
{
this.lblStatus.Text = "0 Orders could be exported.";
}
}
private void PopulateStaticControls()
{
// Load the Customers for this instruction
Facade.IOrder facOrder = new Facade.Order();
DataSet dsclients = facOrder.GetOrdersForInstructionID(this.InstructionID);
cboClient.DataSource = dsclients;
cboClient.DataBind();
List <String> Clients = new List <string>();
foreach (DataRow row in dsclients.Tables[0].Rows)
{
if (!Clients.Contains(row["CustomerOrganisationName"].ToString()))
{
Clients.Add(row["CustomerOrganisationName"].ToString());
}
}
if (Clients.Count == 1)
{
cboClient.Enabled = false;
cboClient.Items[0].Selected = true;
}
Facade.ExtraType facExtraType = new Orchestrator.Facade.ExtraType();
bool? getActiveExtraTypes = true;
cboExtraType.DataSource = facExtraType.GetForIsEnabled(getActiveExtraTypes);
cboExtraType.DataValueField = "ExtraTypeId";
cboExtraType.DataTextField = "Description";
cboExtraType.DataBind();
cboExtraState.DataSource = Utilities.UnCamelCase(Enum.GetNames(typeof(eExtraState)));
cboExtraState.DataBind();
if (m_demurrage)
{
cboExtraType.Items.FindByText(eExtraType.Demurrage.ToString()).Selected = true;
cboExtraType.Enabled = false;
pnlDemurrageComments.Visible = true;
}
else
{
cboExtraType.Items.RemoveAt(((int)eExtraType.Demurrage));
}
}
void gvPreInvoices_ItemCommand(object source, GridCommandEventArgs e)
{
if (e.CommandName == "Export")
{
List <int> orderIDs = new List <int>();
int preInvoiceId = (int)e.Item.OwnerTableView.ParentItem.GetDataKeyValue("PreInvoiceID");
if (preInvoiceId > 0)
{
foreach (GridDataItem item in e.Item.OwnerTableView.Items)
{
HtmlAnchor lnkOrder = item.FindControl("lnkOrderId") as HtmlAnchor;
if (lnkOrder != null)
{
int orderId = 0;
int.TryParse(lnkOrder.InnerHtml, out orderId);
orderIDs.Add(orderId);
}
}
Facade.IOrder facOrder = new Facade.Order();
DataSet dsOrdersToExport = facOrder.GetOrdersForPreInvoiceExport(orderIDs);
Facade.ExtraType facExtraTypes = new Orchestrator.Facade.ExtraType();
List <Entities.ExtraType> extraTypes = facExtraTypes.GetForIsEnabled(true);
foreach (Entities.ExtraType et in extraTypes)
{
dsOrdersToExport.Tables[0].Columns.Add("[" + et.Description + "]", typeof(decimal));
}
// Extra data
foreach (DataRow dr in dsOrdersToExport.Tables[0].Rows)
{
DataRow[] extraRows = dsOrdersToExport.Tables[1].Select("OrderID = " + dr["OrderID"]);
foreach (DataRow extra in extraRows)
{
if (dr.Table.Columns.Contains("[" + extra["ExtraType"] + "]"))
{
dr["[" + extra["ExtraType"] + "]"] = extra["ExtraAmount"];
}
}
}
Session["__ExportDS"] = dsOrdersToExport.Tables[0];
Response.Redirect("/reports/csvexport.aspx?filename=PreInvoiceExport.CSV");
}
}
}
public List <Surcharge> GetSurcharges()
{
Orchestrator.Facade.ExtraType facExtraType = new Orchestrator.Facade.ExtraType();
List <Entities.ExtraType> extraTypes = facExtraType.GetForIsDisplayedOnAddUpdateOrder();
List <Surcharge> retVal = new List <Surcharge>();
foreach (var extraType in extraTypes)
{
var currentSurCharge = new Surcharge()
{
ExtraTypeID = extraType.ExtraTypeId, Description = extraType.ShortDescription
};
retVal.Add(currentSurCharge);
}
return(retVal);
}
private List <Surcharge> GetSurcharges(int OrderID)
{
EF.VigoOrder vigoOrder = EF.DataContext.Current.VigoOrderSet.Include("VigoOrderExtras.ExtraType").FirstOrDefault(v => v.OrderId == OrderID);
Orchestrator.Facade.ExtraType facExtraType = new Orchestrator.Facade.ExtraType();
List <Entities.ExtraType> extraTypes = facExtraType.GetForIsDisplayedOnAddUpdateOrder();
List <Surcharge> retVal = new List <Surcharge>();
foreach (var extraType in extraTypes)
{
var currentSurCharge = new Surcharge()
{
ExtraTypeID = extraType.ExtraTypeId, Description = extraType.ShortDescription
};
if (vigoOrder.VigoOrderExtras.FirstOrDefault(e => e.ExtraType.ExtraTypeId == extraType.ExtraTypeId) != null)
{
currentSurCharge.IsSelected = true;
}
retVal.Add(currentSurCharge);
}
return(retVal);
}
//-----------------------------------------------------------------------------------------------------------
protected void grdOrders_ItemDataBound(object sender, GridItemEventArgs e)
{
if (e.Item is GridDataItem)
{
DataRowView row = (DataRowView)e.Item.DataItem;
int orderId = int.Parse(row["OrderID"].ToString());
string runId = row["JobId"].ToString();
using (CheckBox chk = (CheckBox)e.Item.FindControl("chkSelectOrder"))
{
chk.Attributes.Add("onClick", string.Format("javascript:HandleSelection(this, {0});",
e.Item.ItemIndex));
chk.Attributes.Add("OrderId", orderId.ToString());
}
orderCount++;
totalPalletCount += (int)row["NoPallets"];
totalPalletSpaces += Convert.ToDouble(row["PalletSpaces"]);
totalWeight += Convert.ToDouble(row["Weight"]);
QtrPalletsTotal += Convert.ToDouble(row["QtrPallets"]);
HalfPalletsTotal += Convert.ToDouble(row["HalfPallets"]);
FullPalletsTotal += Convert.ToDouble(row["FullPallets"]);
OverPalletsTotal += Convert.ToDouble(row["OverPallets"]);
OrderRateTotal += (row["ForeignRate"] != DBNull.Value) ? Convert.ToDouble(row["ForeignRate"]) : 0.00;
SubContractCostTotal += (row["SubContractRate"] != DBNull.Value) ? Convert.ToDouble(row["SubContractRate"]) : 0.00;
HubChargeTotal += (row["SubContractRate"] != DBNull.Value) ? Convert.ToDouble(row["HubCharge"]) : 0.00;
// Delivery At column
Label lblDeliverAt = (Label)e.Item.FindControl("lblDeliverAt");
DateTime delFrom = Convert.ToDateTime(row["DeliveryFromDateTime"].ToString());
DateTime delBy = Convert.ToDateTime(row["DeliveryDateTime"].ToString());
if (lblDeliverAt != null)
{
if (delFrom == delBy)
{
// Timed booking... only show a single date.
lblDeliverAt.Text = GetDate(Convert.ToDateTime(row["DeliveryDateTime"].ToString()), false);
}
else
{
// If the times span from mignight to 23:59 on the same day then
// it's an 'anytime' window.
if (delFrom.Date == delBy.Date && delFrom.Hour == 0 && delFrom.Minute == 0 && delBy.Hour == 23 && delBy.Minute == 59)
{
// It's anytime
lblDeliverAt.Text = GetDate(Convert.ToDateTime(row["DeliveryDateTime"].ToString()), true);
}
else
{
// It's a booking window
lblDeliverAt.Text = GetDate(Convert.ToDateTime(row["DeliveryFromDateTime"].ToString()), false) + " to " + GetDate(Convert.ToDateTime(row["DeliveryDateTime"].ToString()), false);
}
}
}
//if (row["IsTariffOverride"] != DBNull.Value && Convert.ToBoolean(row["IsTariffOverride"]))
// e.Item.Cells[grdOrders.Columns.FindByUniqueName("Rate").OrderIndex].BackColor = System.Drawing.Color.Yellow;
if (row["MessageStateId"] != DBNull.Value)
{
eMessageState messageState = (eMessageState)row["MessageStateId"];
switch (messageState)
{
case eMessageState.Unprocessed:
e.Item.BackColor = System.Drawing.Color.Pink;
break;
case eMessageState.Processed:
case eMessageState.NotProcessed:
e.Item.BackColor = System.Drawing.Color.Violet;
break;
case eMessageState.Error:
e.Item.BackColor = System.Drawing.Color.Red;
break;
}
}
CheckBoxList cblsurcharges = e.Item.FindControl("cblSurcharges") as CheckBoxList;
EF.VigoOrder vigoOrder = EF.DataContext.Current.VigoOrderSet.Include("VigoOrderExtras.ExtraType").FirstOrDefault(v => v.OrderId == orderId);
Orchestrator.Facade.ExtraType facExtraType = new Orchestrator.Facade.ExtraType();
List <Entities.ExtraType> extraTypes = facExtraType.GetForIsDisplayedOnAddUpdateOrder();
cblsurcharges.DataSource = extraTypes.OrderBy(et => et.ShortDescription);
cblsurcharges.DataTextField = "ShortDescription";
cblsurcharges.DataValueField = "ExtraTypeId";
cblsurcharges.DataBind();
//Tick the PalletForce Surcharge checkboxes for each VigoOrderExtra
foreach (var extra in vigoOrder.VigoOrderExtras)
{
ListItem item = cblsurcharges.Items.FindByValue(extra.ExtraType.ExtraTypeId.ToString());
if (item != null)
{
item.Selected = true;
}
}
}
else if (e.Item is GridEditableItem)
{
DataRowView row = (DataRowView)e.Item.DataItem;
RadNumericTextBox txtRate = e.Item.FindControl("txtRate") as RadNumericTextBox;
if (txtRate != null)
{
CultureInfo culture = new CultureInfo(int.Parse(row["LCID"].ToString()));
txtRate.Culture = culture;
//if (row["TariffRateId"] == null)
//{
// txtRate.BackColor = System.Drawing.Color.Yellow;
//}
}
}
}
void grdExtraTypes_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
Facade.ExtraType facExtraType = new Orchestrator.Facade.ExtraType();
grdExtraTypes.DataSource = facExtraType.GetForIsEnabled(new bool?());
}