public void FillChart()
{
DataBase.Command.cmdClass cmd = new DataBase.Command.cmdClass();
List <WeekOrederDTO> lsAllWeeks = cmd.GetWeekOrders();
ltrWeekToatalLineChart.Text = Charts.cLine.WeeklyTotalOrders(ThisWeekData(lsAllWeeks), lastWeekData(lsAllWeeks), YearDat(cmd.GetYearAvg())).ToHtmlString();
}
protected void Timer1_Tick(object sender, EventArgs e)
{
DataBase.Command.cmdClass cmd = new DataBase.Command.cmdClass();
List <TopQuantityOrdered> lstopQuantityorder = new List <TopQuantityOrdered>();
lstopQuantityorder = cmd.GetTop5SkuQuantityOrder();
if (lstopQuantityorder.Count > 0)
{
ltrStackedColumnTop5SKU.Text = cStackedBar.GetTop_5_SKU_By_Ordered(lstopQuantityorder).ToHtmlString();
}
}
private void Stacked()
{
DataBase.Command.cmdClass cmd = new DataBase.Command.cmdClass();
List <TopPartnerDTO> lstopPartnerByOrder = new List <TopPartnerDTO>();
List <TopPartnerDTO> lstopPartner = new List <TopPartnerDTO>();
lstopPartner = cmd.GetTop5ParnerSale();
lstopPartnerByOrder = cmd.GetTop5ParnerByOrder();
if (lstopPartnerByOrder.Count > 0)
{
ltrTOPPartnerByOrder.Text = cStackedBar.GetTop_5_Partner_By_OrderCount(lstopPartnerByOrder).ToHtmlString();
}
if (lstopPartner.Count > 0)
{
ltrStackedColumnTop5Partner.Text = cStackedBar.GetTop_5_Partner_By_Sales(lstopPartner).ToHtmlString();
}
}
private void FillInternal_Ticker()
{
try
{
blTicker _ticker = new blTicker();
//string newShipment = "http://internal.kraususa.net/result.php?type=new";
List <int> lsneworder = _ticker.GetNewOrder();
Literal1.Text = cGuage.GetNewShipmentGuage(Convert.ToInt32(lsneworder[0].ToString())).ToHtmlString();
List <int> lSYSProcess = _ticker.GetSYSProcessingTicker();
//String SYSInProcess = "http://internal.kraususa.net/result.php?type=processed_nywt";
ltrInProcessSOS.Text = cGuage.GetGreenSYS(Convert.ToInt32(lSYSProcess[0].ToString())).ToHtmlString();
//String SYSShipped = "http://internal.kraususa.net/result.php?type=shipped_nywt";
ltrShippedSYS.Text = cGuage.GetPurplSYS(Convert.ToInt32(_ticker.GetSYSShippedTicker()[0].ToString())).ToHtmlString();
//String PWInProcess = "http://internal.kraususa.net/result.php?type=processed";
ltrInprocessNyWH.Text = cGuage.GetGreenWT((Convert.ToInt32(_ticker.GetNYWHProcessingTicker()[0].ToString()))).ToHtmlString();
//String PWShipped = "http://internal.kraususa.net/result.php?type=shipped_nywh";
ltrShippedNYWH.Text = cGuage.GetPurplWT((Convert.ToInt32(_ticker.GetNYWHShippedTicker()[0].ToString()))).ToHtmlString();
DataBase.Command.cmdClass cmd = new DataBase.Command.cmdClass();
List <double> lsshipped = new List <double>();
lsshipped = cmd.GetShipped();
lblHoldOrder.Text = cmd.GetNoOfHoldOrders().ToString();
int ShippingInt = 0;
string Ship = Math.Round(lsshipped.ToShippedpercentage(), 0).ToString();
int.TryParse(Ship, out ShippingInt);
lblship.Text = ShippingInt.ToString();
lblOrdersToday.Text = cmd.GetTodaysOrder().ToString();
lblToatalYesterday.Text = cmd.GetYesterdayOrder().ToString();
}
catch (Exception)
{
}
}
public void FillDonut()
{
DataBase.Command.cmdClass cmd = new DataBase.Command.cmdClass();
List <OrderDTO> lsOrderCount = new List <OrderDTO>();
lsOrderCount = cmd.GetQuantityOrderedCategory();
if (lsOrderCount.Count > 0)
{
lblNewOrderNH.Text = (Convert.ToInt32(lsOrderCount.ToTotalOrderCount())).ToString();
ltrChart.Text = cDonut.OrderCategory(lsOrderCount.RemoveLessThenZero()).ToHtmlString();
}
List <AmountOrderDTO> lsOrderAmount = new List <AmountOrderDTO>();
lsOrderAmount = cmd.GetAmountCategoryOrdred();
if (lsOrderCount.Count > 0)
{
lbltotalamount.Text = "$" + (Convert.ToInt32(lsOrderAmount.ToTotalOrderAmount())).ToString();
litOrderAmount.Text = cDonut.RegularOrder(lsOrderAmount.RemoveLessThanZeroAmountOrder()).ToHtmlString();
}
}
