private object LoadForm(long HeaderId)
{
ReportDocument rptDoc = ReportFactory.GetReport();
var dc = DCFactory.GetDataContext<PartDataContext>();
header = OrderDAO.GetOrderHeader(HeaderId);
if (header != null)
{
rptDoc.Load(HttpContext.Current.Server.MapPath(@"~/Part/Report/Crystal/VMEPOrderSheet.rpt"));
IList<PartOrderItem> data = header.OrderDetails
.Join(dc.Parts.Where(p => p.DatabaseCode == header.Dealer.DatabaseCode),
od => od.PartCode, p => p.PartCode,
(od, p) => new PartOrderItem(od) { PartName = p.VietnamName })
.ToList();
rptDoc.SetDataSource(data);
string dealer = header.Dealer.DealerName;
rptDoc.SetParameterValue("OrderDate", header.OrderDate);
rptDoc.SetParameterValue("Address", header.Warehouse.Address);
rptDoc.SetParameterValue("Dealer", dealer);
}
return rptDoc;
}
private void detach_OrderHeaders1(OrderHeader entity)
{
this.SendPropertyChanging();
entity.OrderHeader2 = null;
}
private void attach_OrderHeaders1(OrderHeader entity)
{
this.SendPropertyChanging();
entity.OrderHeader2 = this;
}
private void attach_OrderHeaders(OrderHeader entity)
{
this.SendPropertyChanging();
entity.Dealer = this;
}
private void detach_OrderHeaders(OrderHeader entity)
{
this.SendPropertyChanging();
entity.Warehouse = null;
}
private void detach_OrderHeaders(OrderHeader entity)
{
this.SendPropertyChanging();
entity.SystemData = null;
}
protected void cmdSave_Click(object sender, EventArgs e)
{
if (!Page.IsValid) return;
UpdateOrderData();
if (!CheckPartNo(true)) return;
var db = DCFactory.GetDataContext<PartDataContext>();
db.SubmitChanges();
if (_commandName == CommandName.Create)
{
if (PartOrderDAO.Parts.Count(p => p.Quantity > 0) == 0) return;
PartOrderDAO.CleanUp();
PartOrderDAO.Merge();
PartOrderDAO.InitPrice();
PartOrderDAO.GetPrice();
CheckQuantityForPacking();
DateTime d = UserHelper.ParseDate(txtOrderDate.Text, true);
var h = new OrderHeader
{
CreatedDate = DateTime.Now,
CreatedBy = UserHelper.Username,
Status = OrderStatus.OrderOpen,
OrderType = "N",
OrderSource = "V",
ToDealer = ddlDealer.SelectedValue,
DealerCode = UserHelper.DealerCode,
ToLocation = int.Parse(ddlWH.SelectedValue),
OrderDate = d,
CanUndoAutoReceive = true,
ChangeRemark = "N",
TipTopProcessed = "N",
Amount = 0,
SentWarningOverQuotation = false,
SentWarningOverShipping = false,
AlreadyInStock = false
};
int line = 1;
foreach (var item in PartOrderDAO.Parts)
{
var obj = new OrderDetail
{
LineNumber = line++,
PartCode = item.PartCode,
OrderQuantity = item.Quantity,
QuotationQuantity = 0,
UnitPrice = item.UnitPrice,
ModifyFlag = "N",
Note = DateTime.Now.ToString(),
OrderHeader = h,
OriginalQty = item.Quantity,
Quo_Status = PartOrderQuoStatus.OrderNew
};
}
db.OrderHeaders.InsertOnSubmit(h);
db.SubmitChanges();
PartOrderDAO.LoadFromDB(h.OrderHeaderId);
}
else
{
// check if tip-top has process
var oh = db.OrderHeaders.Single(p => p.OrderHeaderId == OrderId);
if (oh.TipTopProcessed == "Y")
{
lblTipTopProcessed.Visible = true;
PartOrderDAO.LoadFromDB(OrderId);
gv1.DataBind();
DisableButton();
return;
}
oh.OrderDate = UserHelper.ParseDate(txtOrderDate.Text, true);
oh.ToDealer = ddlDealer.SelectedValue;
oh.ToLocation = int.Parse(ddlWH.SelectedValue);
db.SubmitChanges();
PartOrderDAO.CleanUp();
PartOrderDAO.Merge();
PartOrderDAO.InitPrice();
PartOrderDAO.GetPrice();
int line = 1;
var od = db.OrderDetails.Where(d => d.OrderHeaderId == OrderId).ToList();
db.OrderDetails.DeleteAllOnSubmit(db.OrderDetails.Where(d => d.OrderHeaderId == OrderId));
foreach (var item in PartOrderDAO.Parts)
{
//if (item.OrderDetailId != 0)
//{
// var od = db.OrderDetails.SingleOrDefault(p => p.OrderDetailId == item.OrderDetailId);
// if (string.IsNullOrEmpty(item.PartCode) || item.Quantity == 0)
// db.OrderDetails.DeleteOnSubmit(od);
// else
// {
// od.LineNumber = line++;
// od.PartCode = item.PartCode;
// od.OrderQuantity = item.Quantity;
// od.Note = od.Note + ";" + DateTime.Now.ToString();
// };
//}
//else
{
OrderDetail tod = new OrderDetail
{
LineNumber = line++,
PartCode = item.PartCode,
OrderQuantity = item.Quantity,
QuotationQuantity = 0,
UnitPrice = item.UnitPrice,
ModifyFlag = "N",
Note = DateTime.Now.ToString(),
OrderHeaderId = OrderId
};
if (oh.Status == OrderStatus.OrderOpen)
{
tod.OriginalQty = item.Quantity;
tod.Quo_Status = PartOrderQuoStatus.OrderNew;
}
else
{
OrderDetail odd = od.SingleOrDefault(d => d.LineNumber == item.Line && d.PartCode == item.PartCode);
if (odd != null)
{
if (odd.OrderQuantity == item.Quantity)
{
tod.OriginalQty = odd.OriginalQty;
tod.Quo_Status = odd.Quo_Status;
}
else
{
tod.OriginalQty = odd.OriginalQty;
tod.Quo_Status = PartOrderQuoStatus.OrderEditByDealer;
}
}
else
{
tod.OriginalQty = item.Quantity;
tod.Quo_Status = PartOrderQuoStatus.OrderNew;
}
}
db.OrderDetails.InsertOnSubmit(tod);
}
db.SubmitChanges();
}
if (oh.Status == OrderStatus.OrderSent)
OrderDAO.SendOrder(OrderId, true);
PartOrderDAO.LoadFromDB(oh.OrderHeaderId);
}
gv1.DataBind();
PartOrderDAO.Clear();
lblSaveOk.Visible = true;
DisableButton();
}
private void attach_OrderHeaders(OrderHeader entity)
{
this.SendPropertyChanging("OrderHeaders");
entity.Warehouse = this;
}
private void attach_OrderHeaders(OrderHeader entity)
{
this.SendPropertyChanging("OrderHeaders");
entity.SystemData = this;
}
private void detach_OrderHeaders(OrderHeader entity)
{
this.SendPropertyChanging("OrderHeaders");
entity.OrderHeader1 = null;
}