private void ViewOrderInfo()
{
salesOrder = SalesOrderDataAccess.GetSalesOrderById(orderId);
if (salesOrder != null)
{
cmbCustomer.Text = keyValues[salesOrder.Customer].ToString();
txtDescription.Text = salesOrder.Description;
txtPrice.Text = string.Format("{0: 0.00}", salesOrder.Price).Trim();
txtDiscount.Text = string.Format("{0: 0.00}", salesOrder.Discount * 100).Trim();
dateSalesOrder.Value = salesOrder.SalesOrderDate.Date;
chkPaid.Checked = salesOrder.IsPaid;
if (chkPaid.Checked && salesOrder.PaidDate != null)
{
datePaid.Value = salesOrder.PaidDate.Value;
}
else
{
datePaid.Format = DateTimePickerFormat.Custom;
datePaid.CustomFormat = " ";
}
setPayType(salesOrder.PayType);
setStockStatus(salesOrder.SalesStatus);
}
}
private int AddUpdateOrder()
{
var checkedSalesStatus = grpSalesStatus.Controls.OfType <RadioButton>().FirstOrDefault(r => r.Checked);
int stockStatus = (int)(SalesStatus)Enum.Parse(typeof(SalesStatus), checkedSalesStatus.Text);
var checkedPayType = grpPayType.Controls.OfType <RadioButton>().FirstOrDefault(r => r.Checked);
int payType = (int)(PayType)Enum.Parse(typeof(PayType), checkedPayType.Text);
if (salesOrder != null && salesOrder.Id > 0)
{
salesOrder.Id = orderId;
salesOrder.Customer = cmbCustomer.SelectedIndex + 1;
salesOrder.Description = txtDescription.Text;
salesOrder.Price = Convert.ToDecimal(txtPrice.Text);
salesOrder.Discount = Convert.ToDecimal(txtDiscount.Text);
salesOrder.SalesOrderDate = dateSalesOrder.Value;
salesOrder.IsPaid = chkPaid.Checked;
salesOrder.UpdatedBy = userId;
salesOrder.PayType = payType;
salesOrder.SalesStatus = stockStatus;
if (chkPaid.Checked)
{
salesOrder.PaidDate = datePaid.Value;
}
else
{
salesOrder.PaidDate = null;
}
return(SalesOrderDataAccess.UpdateSalesOrder(salesOrder));
}
else
{
var salesOrder = new SalesOrderDTO()
{
Description = txtDescription.Text,
Customer = cmbCustomer.SelectedIndex + 1,
Price = Convert.ToDecimal(txtPrice.Text),
Discount = Convert.ToDecimal(txtDiscount.Text),
SalesOrderDate = dateSalesOrder.Value,
IsPaid = chkPaid.Checked,
PayType = payType,
SalesStatus = stockStatus,
CreatedBy = userId
};
if (chkPaid.Checked)
{
salesOrder.PaidDate = datePaid.Value;
}
else
{
salesOrder.PaidDate = null;
}
return(SalesOrderDataAccess.AddSalesOrder(salesOrder));
}
}
protected void Page_Load(object sender, EventArgs e)
{
SalesOrderDataAccess db = new SalesOrderDataAccess();
var orders = db.GetAllOrders();
var customers = orders.Select(order => order.CustomerName).ToArray();
var netAmount = orders.Select(order => order.TotalSum).ToList();
var netTax = orders.Select(order => order.Tax).ToList();
List <object> amount = new List <object>();
List <object> tax = new List <object>();
List <object> categories = new List <object>();
netAmount.ForEach(delegate(decimal net)
{
amount.Add((object)net);
});
netTax.ForEach(delegate(decimal net)
{
tax.Add((object)net);
});
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart")
.InitChart(new Chart
{
Height = 300,
Width = 600,
DefaultSeriesType = ChartTypes.Line,
ClassName = "chart"
})
.SetTitle(new Title
{
Text = "Sales Orders By Company",
X = -20
})
.SetXAxis(new XAxis
{
Categories = customers
})
.SetYAxis(new YAxis
{
Title = new YAxisTitle {
Text = "In Dollars"
},
})
.SetSeries(new Series[]
{
new Series {
Name = "Amount", Data = new Data(amount.ToArray())
},
new Series {
Name = "Tax", Data = new Data(tax.ToArray())
},
});
ltrChart.Text = chart.ToHtmlString();
}
protected void Page_Load(object sender, EventArgs e)
{
SalesOrderDataAccess db = new SalesOrderDataAccess();
var orders = db.GetAllOrders();
var customers = orders.Select(order => order.CustomerName).ToArray();
var netAmount = orders.Select(order => order.TotalSum).ToList();
var netTax = orders.Select(order => order.Tax).ToList();
List<object> amount = new List<object>();
List<object> tax = new List<object>();
List<object> categories = new List<object>();
netAmount.ForEach(delegate(decimal net)
{
amount.Add((object)net);
});
netTax.ForEach(delegate(decimal net)
{
tax.Add((object)net);
});
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart")
.InitChart(new Chart
{
Height = 300,
Width = 600,
DefaultSeriesType = ChartTypes.Line,
ClassName = "chart"
})
.SetTitle(new Title
{
Text = "Sales Orders By Company",
X = -20
})
.SetXAxis(new XAxis
{
Categories = customers
})
.SetYAxis(new YAxis
{
Title = new YAxisTitle { Text = "In Dollars" },
})
.SetSeries(new Series[]
{
new Series { Name = "Amount", Data = new Data(amount.ToArray()) },
new Series { Name = "Tax", Data = new Data(tax.ToArray()) },
});
ltrChart.Text = chart.ToHtmlString();
}
public void frmSalesOrders_Load(object sender, EventArgs e)
{
salesOrderTable = SalesOrderDataAccess.GetSalesOrders();
if (salesOrderTable != null)
{
this.salesOrderGridView.DataSource = salesOrderTable;
FormatGrid(ref this.salesOrderGridView);
}
if (cmbPayType.Items.Count < 1)
{
var payTypes = Enum.GetValues(typeof(PayType));
cmbPayType.Items.Add("All");
foreach (var item in payTypes)
{
cmbPayType.Items.Add(item.ToString());
}
}
}
