protected void btnSave_Click(object sender, EventArgs e)
{
SendOrderReportData ds = new SendOrderReportData();
DataTable SendOrderHeader = ds.Tables["SendOrderHeader"];
DataTable SendOrderDetail = ds.Tables["SendOrderDetail"];
DataTable SendOrderFooter = ds.Tables["SendOrderFooter"];
var cmd = new OrderService();
ORDER item = cmd.Select(Convert.ToInt32(ViewState["orderId"]));
var cmdStore = new StoreService();
item.STORE = cmdStore.Select(item.STORE_ID);
var cmdOrderdetail = new OrderDetailService();
item.ORDER_DETAIL = cmdOrderdetail.GetALLInclude(item.ORDER_ID);
DataRow drSendOrderHeader = SendOrderHeader.NewRow();
drSendOrderHeader["STORE_NAME"] = item.STORE.STORE_NAME;
drSendOrderHeader["STORE_ADDR"] = item.STORE.STORE_ADDR1;
drSendOrderHeader["STORE_TEL"] = item.STORE.STORE_TEL1;
if (item.STORE.STORE_TEL2 != "")
{
drSendOrderHeader["STORE_TEL"] += ("," + item.STORE.STORE_TEL2);
}
drSendOrderHeader["STORE_CODE"] = item.STORE.STORE_CODE;
drSendOrderHeader["ORDER_DATE"] = item.ORDER_DATE.Value.ToShortDateString();
drSendOrderHeader["SEND_DATE"] = DateTime.Now.ToShortDateString();
drSendOrderHeader["ZONE_NAME"] = item.STORE.ZONE.ZONE_NAME;
drSendOrderHeader["VEHICLE_REG"] = ddlVehicle.SelectedItem.Text;
SendOrderHeader.Rows.Add(drSendOrderHeader);
int seq = 1;
decimal sumWeight = 0;
foreach (ORDER_DETAIL od in item.ORDER_DETAIL)
{
DataRow drSendOrderDetail = SendOrderDetail.NewRow();
drSendOrderDetail["SEQ"] = seq.ToString();
drSendOrderDetail["NAME"] = od.PRODUCT.PRODUCT_NAME;
drSendOrderDetail["QTY"] = (od.PRODUCT_QTY - od.PRODUCT_SEND_QTY).ToString();
drSendOrderDetail["PACKAGE"] = od.PRODUCT.PRODUCT_PACKING_DESC;
drSendOrderDetail["WEIGHT"] = od.PRODUCT.PRODUCT_WEIGHT;
drSendOrderDetail["SUM_WEIGHT"] = (od.PRODUCT.PRODUCT_WEIGHT * (od.PRODUCT_QTY - od.PRODUCT_SEND_QTY)).ToString();
sumWeight += (od.PRODUCT.PRODUCT_WEIGHT * (od.PRODUCT_QTY - od.PRODUCT_SEND_QTY)).Value;
SendOrderDetail.Rows.Add(drSendOrderDetail);
seq++;
}
DataRow drSendOrderFooter = SendOrderFooter.NewRow();
drSendOrderFooter["SUM_WEIGHT_TH"] = ThaiBaht(sumWeight.ToString());
drSendOrderFooter["SUM_WEIGHT_NUMBER"] = sumWeight.ToString();
SendOrderFooter.Rows.Add(drSendOrderFooter);
Session["SendOrderReportData"] = ds;
Response.Redirect("../Reports/SendOrder.aspx");
}
protected void btnSave_Click(object sender, EventArgs e)
{
SendOrderReportData ds = new SendOrderReportData();
DataTable SendOrderHeader = ds.Tables["SendOrderHeader"];
DataTable SendOrderDetail = ds.Tables["SendOrderDetail"];
DataTable SendOrderFooter = ds.Tables["SendOrderFooter"];
var cmd = new OrderService();
ORDER item = cmd.Select(Convert.ToInt32(ViewState["orderId"]));
var cmdStore = new StoreService();
item.STORE = cmdStore.Select(item.STORE_ID);
var cmdOrderdetail = new OrderDetailService();
item.ORDER_DETAIL = cmdOrderdetail.GetALLInclude(item.ORDER_ID);
DataRow drSendOrderHeader = SendOrderHeader.NewRow();
drSendOrderHeader["STORE_NAME"] = item.STORE.STORE_NAME;
drSendOrderHeader["STORE_ADDR"] = item.STORE.STORE_ADDR1;
drSendOrderHeader["STORE_TEL"] = item.STORE.STORE_TEL1;
if (item.STORE.STORE_TEL2 != "")
{
drSendOrderHeader["STORE_TEL"] += ("," + item.STORE.STORE_TEL2);
}
drSendOrderHeader["STORE_CODE"] = item.STORE.STORE_CODE;
drSendOrderHeader["ORDER_DATE"] = item.ORDER_DATE.Value.ToShortDateString();
drSendOrderHeader["SEND_DATE"] = DateTime.Now.ToShortDateString();
drSendOrderHeader["ZONE_NAME"] = item.STORE.ZONE.ZONE_NAME;
drSendOrderHeader["VEHICLE_REG"] = ddlVehicle.SelectedItem.Text;
SendOrderHeader.Rows.Add(drSendOrderHeader);
int seq = 1;
decimal sumWeight = 0;
foreach (ORDER_DETAIL od in item.ORDER_DETAIL)
{
DataRow drSendOrderDetail = SendOrderDetail.NewRow();
drSendOrderDetail["SEQ"] = seq.ToString();
drSendOrderDetail["NAME"] = od.PRODUCT.PRODUCT_NAME;
drSendOrderDetail["QTY"] = (od.PRODUCT_QTY - od.PRODUCT_SEND_QTY).ToString();
drSendOrderDetail["PACKAGE"] = od.PRODUCT.PRODUCT_PACKING_DESC;
drSendOrderDetail["WEIGHT"] = od.PRODUCT.PRODUCT_WEIGHT;
drSendOrderDetail["SUM_WEIGHT"] = (od.PRODUCT.PRODUCT_WEIGHT * (od.PRODUCT_QTY - od.PRODUCT_SEND_QTY)).ToString();
sumWeight += (od.PRODUCT.PRODUCT_WEIGHT * (od.PRODUCT_QTY - od.PRODUCT_SEND_QTY)).Value;
SendOrderDetail.Rows.Add(drSendOrderDetail);
seq++;
}
DataRow drSendOrderFooter = SendOrderFooter.NewRow();
drSendOrderFooter["SUM_WEIGHT_TH"] = ThaiBaht(sumWeight.ToString());
drSendOrderFooter["SUM_WEIGHT_NUMBER"] = sumWeight.ToString();
SendOrderFooter.Rows.Add(drSendOrderFooter);
Session["SendOrderReportData"] = ds;
Response.Redirect("../Reports/SendOrder.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
SendOrderReportData ds = new SendOrderReportData();
if (Session["SendOrderReportData"] != null)
{
ds = Session["SendOrderReportData"] as SendOrderReportData;
}
SendOrderReport objRpt = new SendOrderReport();
objRpt.SetDataSource(ds);
this.CrystalReportViewer1.ReportSource = objRpt;
this.CrystalReportViewer1.RefreshReport();
}
protected void Page_Load(object sender, EventArgs e)
{
SendOrderReportData ds = new SendOrderReportData();
if (Session["SendOrderReportData"] != null)
{
ds = Session["SendOrderReportData"] as SendOrderReportData;
}
SendOrderReport objRpt = new SendOrderReport();
objRpt.SetDataSource(ds);
this.CrystalReportViewer1.ReportSource = objRpt;
this.CrystalReportViewer1.RefreshReport();
}
protected void btnSave_Click(object sender, EventArgs e)
{
int orderId = Convert.ToInt32(ViewState["orderId"]);
var cmd = new OrderDetailService();
DataSouceDetail = cmd.GetALLInclude().Where(x => x.ORDER_ID == orderId && x.PRODUCT_QTY != x.PRODUCT_SEND_QTY).ToList();
int i = 0;
int index = 0;
DELIVERY_ORDER od = new DELIVERY_ORDER();
od.DELIVERY_ORDER_DETAIL = new List<DELIVERY_ORDER_DETAIL>();
var cmdDO = new DeliveryOrderService(od);
foreach (ORDER_DETAIL item in DataSouceDetail)
{
if (Convert.ToInt32(((TextBox)gridProductDetail.Rows[i].Cells[4].FindControl("txtQty")).Text) > 0)
{
item.PRODUCT_SEND_QTY += Convert.ToInt32(((TextBox)gridProductDetail.Rows[i].Cells[4].FindControl("txtQty")).Text);
DELIVERY_ORDER_DETAIL dod = new DELIVERY_ORDER_DETAIL();
dod.PRODUCT_ID = item.PRODUCT_ID;
dod.PRODUCT_PRICE = item.PRODUCT_PRICE;
dod.PRODUCT_QTY = item.PRODUCT_QTY;
dod.PRODUCT_SEND_QTY = Convert.ToInt32(((TextBox)gridProductDetail.Rows[i].Cells[4].FindControl("txtQty")).Text);
dod.PRODUCT_SEQ = (++index);
dod.PRODUCT_TOTAL = item.PRODUCT_TOTAL;
dod.CREATE_DATE = DateTime.Now;
dod.CREATE_EMPLOYEE_ID = 0;
dod.UPDATE_DATE = DateTime.Now;
dod.UPDATE_EMPLOYEE_ID = 0;
dod.SYE_DEL = true;
od.DELIVERY_ORDER_DETAIL.Add(dod);
}
i++;
}
od.DELORDER_DATE = DateTime.Now;
od.DELORDER_STEP = "1";
od.ORDER_ID = orderId;
od.VEHICLE_ID = Convert.ToInt32(ddlVehicle.SelectedValue);
od.CREATE_DATE = DateTime.Now;
od.CREATE_EMPLOYEE_ID = 0;
od.UPDATE_DATE = DateTime.Now;
od.UPDATE_EMPLOYEE_ID = 0;
od.SYE_DEL = true;
cmdDO.Add();
od.DELORDER_CODE = "IV" + od.DELORDER_ID;
cmdDO.Edit();
cmd = new OrderDetailService(DataSouceDetail);
cmd.UpdateList();
SendOrderReportData ds = new SendOrderReportData();
DataTable SendOrderHeader = ds.Tables["SendOrderHeader"];
DataTable SendOrderDetail = ds.Tables["SendOrderDetail"];
DataTable SendOrderFooter = ds.Tables["SendOrderFooter"];
var cmdOrder = new OrderService();
ORDER Order = cmdOrder.Select(orderId);
var cmdStore = new StoreService();
od.STORE = cmdStore.Select(Order.STORE_ID);
var cmdOrderdetail = new DeliveryOrderDetailService();
od.DELIVERY_ORDER_DETAIL = cmdOrderdetail.GetALLInclude(od.DELORDER_ID);
DataRow drSendOrderHeader = SendOrderHeader.NewRow();
drSendOrderHeader["STORE_NAME"] = od.STORE.STORE_NAME;
drSendOrderHeader["STORE_ADDR"] = od.STORE.STORE_ADDR1;
drSendOrderHeader["STORE_TEL"] = od.STORE.STORE_TEL1;
if (od.STORE.STORE_TEL2 != "")
{
drSendOrderHeader["STORE_TEL"] += ("," + od.STORE.STORE_TEL2);
}
drSendOrderHeader["STORE_CODE"] = od.STORE.STORE_CODE;
drSendOrderHeader["ORDER_DATE"] = od.DELORDER_DATE.Value.ToShortDateString();
drSendOrderHeader["SEND_DATE"] = DateTime.Now.ToShortDateString();
drSendOrderHeader["ZONE_NAME"] = od.STORE.ZONE.ZONE_NAME;
drSendOrderHeader["VEHICLE_REG"] = ddlVehicle.SelectedItem.Text;
SendOrderHeader.Rows.Add(drSendOrderHeader);
int seq = 1;
decimal sumWeight = 0;
foreach (DELIVERY_ORDER_DETAIL dodItem in od.DELIVERY_ORDER_DETAIL)
{
if (dodItem.PRODUCT_SEND_QTY > 0)
{
DataRow drSendOrderDetail = SendOrderDetail.NewRow();
drSendOrderDetail["SEQ"] = seq.ToString();
drSendOrderDetail["NAME"] = dodItem.PRODUCT.PRODUCT_NAME;
drSendOrderDetail["QTY"] = dodItem.PRODUCT_SEND_QTY.ToString();
drSendOrderDetail["PACKAGE"] = dodItem.PRODUCT.PRODUCT_PACKING_DESC;
drSendOrderDetail["WEIGHT"] = dodItem.PRODUCT.PRODUCT_WEIGHT;
drSendOrderDetail["SUM_WEIGHT"] = (dodItem.PRODUCT.PRODUCT_WEIGHT * dodItem.PRODUCT_SEND_QTY).ToString();
sumWeight += (dodItem.PRODUCT.PRODUCT_WEIGHT * dodItem.PRODUCT_SEND_QTY).Value;
SendOrderDetail.Rows.Add(drSendOrderDetail);
seq++;
}
}
DataRow drSendOrderFooter = SendOrderFooter.NewRow();
drSendOrderFooter["SUM_WEIGHT_TH"] = ThaiBaht(sumWeight.ToString());
drSendOrderFooter["SUM_WEIGHT_NUMBER"] = sumWeight.ToString();
SendOrderFooter.Rows.Add(drSendOrderFooter);
Session["SendOrderReportData"] = ds;
Response.Redirect("../Reports/SendOrder.aspx");
}
protected void btnSave_Click(object sender, EventArgs e)
{
int orderId = Convert.ToInt32(ViewState["orderId"]);
var cmd = new OrderDetailService();
DataSouceDetail = cmd.GetALLInclude().Where(x => x.ORDER_ID == orderId && x.PRODUCT_QTY != x.PRODUCT_SEND_QTY).ToList();
int i = 0;
int index = 0;
DELIVERY_ORDER od = new DELIVERY_ORDER();
od.DELIVERY_ORDER_DETAIL = new List<DELIVERY_ORDER_DETAIL>();
var cmdDO = new DeliveryOrderService(od);
foreach (ORDER_DETAIL item in DataSouceDetail)
{
if (Convert.ToInt32(((TextBox)gridProductDetail.Rows[i].Cells[4].FindControl("txtQty")).Text) > 0)
{
item.PRODUCT_SEND_QTY += Convert.ToInt32(((TextBox)gridProductDetail.Rows[i].Cells[4].FindControl("txtQty")).Text);
DELIVERY_ORDER_DETAIL dod = new DELIVERY_ORDER_DETAIL();
dod.PRODUCT_ID = item.PRODUCT_ID;
dod.PRODUCT_PRICE = item.PRODUCT_PRICE;
dod.PRODUCT_QTY = item.PRODUCT_QTY;
dod.PRODUCT_SEND_QTY = Convert.ToInt32(((TextBox)gridProductDetail.Rows[i].Cells[4].FindControl("txtQty")).Text);
dod.PRODUCT_SEQ = (++index);
dod.PRODUCT_TOTAL = item.PRODUCT_TOTAL;
dod.CREATE_DATE = DateTime.Now;
dod.CREATE_EMPLOYEE_ID = 0;
dod.UPDATE_DATE = DateTime.Now;
dod.UPDATE_EMPLOYEE_ID = 0;
dod.SYE_DEL = true;
od.DELIVERY_ORDER_DETAIL.Add(dod);
}
i++;
}
od.DELORDER_DATE = DateTime.Now;
od.DELORDER_STEP = "1";
od.ORDER_ID = orderId;
od.VEHICLE_ID = Convert.ToInt32(ddlVehicle.SelectedValue);
od.CREATE_DATE = DateTime.Now;
od.CREATE_EMPLOYEE_ID = 0;
od.UPDATE_DATE = DateTime.Now;
od.UPDATE_EMPLOYEE_ID = 0;
od.SYE_DEL = true;
cmdDO.Add();
od.DELORDER_CODE = "IV" + od.DELORDER_ID;
cmdDO.Edit();
cmd = new OrderDetailService(DataSouceDetail);
cmd.UpdateList();
SendOrderReportData ds = new SendOrderReportData();
DataTable SendOrderHeader = ds.Tables["SendOrderHeader"];
DataTable SendOrderDetail = ds.Tables["SendOrderDetail"];
DataTable SendOrderFooter = ds.Tables["SendOrderFooter"];
var cmdOrder = new OrderService();
ORDER Order = cmdOrder.Select(orderId);
var cmdStore = new StoreService();
od.STORE = cmdStore.Select(Order.STORE_ID);
var cmdOrderdetail = new DeliveryOrderDetailService();
od.DELIVERY_ORDER_DETAIL = cmdOrderdetail.GetALLInclude(od.DELORDER_ID);
DataRow drSendOrderHeader = SendOrderHeader.NewRow();
drSendOrderHeader["STORE_NAME"] = od.STORE.STORE_NAME;
drSendOrderHeader["STORE_ADDR"] = od.STORE.STORE_ADDR1;
drSendOrderHeader["STORE_TEL"] = od.STORE.STORE_TEL1;
if (od.STORE.STORE_TEL2 != "")
{
drSendOrderHeader["STORE_TEL"] += ("," + od.STORE.STORE_TEL2);
}
drSendOrderHeader["STORE_CODE"] = od.STORE.STORE_CODE;
drSendOrderHeader["ORDER_DATE"] = od.DELORDER_DATE.Value.ToShortDateString();
drSendOrderHeader["SEND_DATE"] = DateTime.Now.ToShortDateString();
drSendOrderHeader["ZONE_NAME"] = od.STORE.ZONE.ZONE_NAME;
drSendOrderHeader["VEHICLE_REG"] = ddlVehicle.SelectedItem.Text;
SendOrderHeader.Rows.Add(drSendOrderHeader);
int seq = 1;
decimal sumWeight = 0;
foreach (DELIVERY_ORDER_DETAIL dodItem in od.DELIVERY_ORDER_DETAIL)
{
if (dodItem.PRODUCT_SEND_QTY > 0)
{
DataRow drSendOrderDetail = SendOrderDetail.NewRow();
drSendOrderDetail["SEQ"] = seq.ToString();
drSendOrderDetail["NAME"] = dodItem.PRODUCT.PRODUCT_NAME;
drSendOrderDetail["QTY"] = dodItem.PRODUCT_SEND_QTY.ToString();
drSendOrderDetail["PACKAGE"] = dodItem.PRODUCT.PRODUCT_PACKING_DESC;
drSendOrderDetail["WEIGHT"] = dodItem.PRODUCT.PRODUCT_WEIGHT;
drSendOrderDetail["SUM_WEIGHT"] = (dodItem.PRODUCT.PRODUCT_WEIGHT * dodItem.PRODUCT_SEND_QTY).ToString();
sumWeight += (dodItem.PRODUCT.PRODUCT_WEIGHT * dodItem.PRODUCT_SEND_QTY).Value;
SendOrderDetail.Rows.Add(drSendOrderDetail);
seq++;
}
}
DataRow drSendOrderFooter = SendOrderFooter.NewRow();
drSendOrderFooter["SUM_WEIGHT_TH"] = ThaiBaht(sumWeight.ToString());
drSendOrderFooter["SUM_WEIGHT_NUMBER"] = sumWeight.ToString();
SendOrderFooter.Rows.Add(drSendOrderFooter);
Session["SendOrderReportData"] = ds;
Response.Redirect("../Reports/SendOrder.aspx");
}
