public ActionResult InitDraft()
{
//if (Session[CHubConstValues.SessionUser] == null)
// return RedirectToAction("Login", "Account");
string appUser = Session[CHubConstValues.SessionUser].ToString();
CHubEntities db = new CHubEntities();
TS_OR_HEADER_STAGE_BLL hStageBLL = new TS_OR_HEADER_STAGE_BLL();
List <TS_OR_HEADER_STAGE> hStageList = hStageBLL.GetHeaderStageByUser(appUser);
return(Json(hStageList));
}
public ActionResult DeleteDraft(decimal orderSeq, decimal shipFrom)
{
try
{
CHubEntities db = new CHubEntities();
TS_OR_HEADER_STAGE_BLL hStageBLL = new TS_OR_HEADER_STAGE_BLL();
hStageBLL.DeleteDraft(orderSeq, shipFrom);
return(Content("Success"));
}
catch (Exception ee)
{
Response.StatusCode = (int)HttpStatusCode.InternalServerError;
return(Content(ee.Message));
}
}
public ActionResult InitOrder(decimal orderSeq)
{
//if (Session[CHubConstValues.SessionUser] == null)
// return RedirectToAction("Login", "Account");
using (CHubEntities db = new CHubEntities())
{
string appUser = Session[CHubConstValues.SessionUser].ToString();
ExVAliasAddr priAddr = null;
ExVAliasAddr AltAddr = null;
List <OrderLineItem> olReslut = new List <OrderLineItem>();
bool isSaved = false;
bool splInd = true;
string poNum = "";
string dueDate = "";
string note = "";
V_ALIAS_ADDR_DFLT_BLL dfltBLL = new V_ALIAS_ADDR_DFLT_BLL(db);
V_ALIAS_ADDR_SPL_BLL splBLL = new V_ALIAS_ADDR_SPL_BLL(db);
TS_OR_HEADER_BLL hBLL = new TS_OR_HEADER_BLL(db);
List <TS_OR_HEADER> hList = hBLL.GetHeadersBySeq(orderSeq);
if (hList != null && hList.Count > 0)
{
isSaved = true;
//Get primary addr and Alt addr
foreach (var item in hList)
{
//special ship
if (item.SPL_IND == CHubConstValues.IndY)
{
splInd = true;
if (item.SHIPFROM_SEQ == 0)
{
poNum = item.CUSTOMER_PO_NO;
dueDate = item.DUE_DATE.ToString("yyyy-MM-dd");
note = item.ORDER_NOTES;
priAddr = splBLL.GetSpecifyAliasAddrSPL(item.ALIAS_NAME, item.TO_SYSTEM, item.CUSTOMER_NO, item.BILL_TO_LOCATION, item.SHIP_TO_LOCATION, item.DEST_LOCATION);
}
if (item.SHIPFROM_SEQ == 1)
{
AltAddr = splBLL.GetSpecifyAliasAddrSPL(item.ALIAS_NAME, item.TO_SYSTEM, item.CUSTOMER_NO, item.BILL_TO_LOCATION, item.SHIP_TO_LOCATION, item.DEST_LOCATION);
}
}
else
{
splInd = false;
if (item.SHIPFROM_SEQ == 0)
{
poNum = item.CUSTOMER_PO_NO;
dueDate = item.DUE_DATE.ToString("yyyy-MM-dd");
note = item.ORDER_NOTES;
priAddr = dfltBLL.GetSpecifyAliasAddrDFLT(item.ALIAS_NAME, item.TO_SYSTEM, item.CUSTOMER_NO, item.BILL_TO_LOCATION, item.SHIP_TO_LOCATION);
}
if (item.SHIPFROM_SEQ == 1)
{
AltAddr = dfltBLL.GetSpecifyAliasAddrDFLT(item.ALIAS_NAME, item.TO_SYSTEM, item.CUSTOMER_NO, item.BILL_TO_LOCATION, item.SHIP_TO_LOCATION);
}
}
}
TS_OR_DETAIL_BLL dBLL = new TS_OR_DETAIL_BLL(db);
List <TS_OR_DETAIL> dList = dBLL.GetDetailsBySeq(orderSeq);
//change detail ot orderLine
OrderLineCheckArg arg = new OrderLineCheckArg();
arg.primarySysID = priAddr.SysID;
arg.primaryWareHouse = priAddr.WareHouse;
arg.customerNo = priAddr.CustomerNo;
if (AltAddr != null)
{
arg.altSysID = AltAddr.SysID;
arg.altWareHosue = AltAddr.WareHouse;
}
foreach (var item in dList)
{
arg.olItem = new OrderLineItem();
arg.olItem.CustomerPartNo = item.CUSTOMER_PART_NO;
arg.olItem.Qty = item.BUY_QTY;
arg.olItem.OrderLineNo = item.ORDER_LINE_NO;
CheckOrderLineItemAction(arg);
olReslut.Add(arg.olItem);
}
}
else
{
TS_OR_HEADER_STAGE_BLL hsBLL = new TS_OR_HEADER_STAGE_BLL(db);
List <TS_OR_HEADER_STAGE> hsList = hsBLL.GetHeaderStageBySeq(orderSeq);
if (hsList != null && hsList.Count > 0)
{
isSaved = false;
//Get primary addr and Alt addr stage
foreach (var item in hsList)
{
//special ship
if (item.SPL_IND == CHubConstValues.IndY)
{
splInd = true;
if (item.SHIPFROM_SEQ == 0)
{
poNum = item.CUSTOMER_PO_NO;
dueDate = item.DUE_DATE.ToString("yyyy-MM-dd");
note = item.ORDER_NOTES;
priAddr = splBLL.GetSpecifyAliasAddrSPL(item.ALIAS_NAME, item.TO_SYSTEM, item.CUSTOMER_NO, item.BILL_TO_LOCATION, item.SHIP_TO_LOCATION, item.DEST_LOCATION);
}
}
else
{
splInd = false;
if (item.SHIPFROM_SEQ == 0)
{
poNum = item.CUSTOMER_PO_NO;
dueDate = item.DUE_DATE.ToString("yyyy-MM-dd");
note = item.ORDER_NOTES;
priAddr = dfltBLL.GetSpecifyAliasAddrDFLT(item.ALIAS_NAME, item.TO_SYSTEM, item.CUSTOMER_NO, item.BILL_TO_LOCATION, item.SHIP_TO_LOCATION);
}
}
}
TS_OR_DETAIL_STAGE_BLL dsBLL = new TS_OR_DETAIL_STAGE_BLL(db);
List <TS_OR_DETAIL_STAGE> dsList = dsBLL.GetDetailsStageByOrderSeq(orderSeq);
//change detail ot orderLine
OrderLineCheckArg arg = new OrderLineCheckArg();
arg.primarySysID = priAddr.SysID;
arg.primaryWareHouse = priAddr.WareHouse;
arg.customerNo = priAddr.CustomerNo;
arg.altSysID = null;
arg.altWareHosue = null;
foreach (var item in dsList)
{
arg.olItem = new OrderLineItem();
arg.olItem.CustomerPartNo = item.CUSTOMER_PART_NO;
arg.olItem.Qty = item.BUY_QTY;
arg.olItem.OrderLineNo = item.ORDER_LINE_NO;
CheckOrderLineItemAction(arg);
olReslut.Add(arg.olItem);
}
}
else
{
this.Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(Content("Wrong Order Seq"));
}
}
var obj = new
{
priAddr = priAddr,
altAddr = AltAddr,
orderLines = olReslut,
isSaved = isSaved,
splInd = splInd,
poNum = poNum,
dueDate = dueDate,
note = note
};
return(Json(obj));
}
}
public ActionResult SaveDraft(OrderSaveArg arg)
{
try
{
if (arg.headInfo == null)
{
return(Content("fail"));
}
string appUser = Session[CHubConstValues.SessionUser].ToString();
CHubEntities db = new CHubEntities();
TS_OR_HEADER_STAGE_BLL bll = new TS_OR_HEADER_STAGE_BLL(db);
//Header part
TS_OR_HEADER_STAGE orHeaderStage = ManualClassConvert.ConvertExAliaAddr2HeaderStage(arg.headInfo, arg.seq, arg.dueDate, arg.orderType, arg.shipCompFlag, arg.customerPONO, arg.orderNote, arg.isSpecialShip, appUser);
TS_OR_HEADER_STAGE altORHeaderStage = null;
if (arg.altHeadInfo != null)
{
altORHeaderStage = ManualClassConvert.ConvertExAliaAddr2HeaderStage(arg.altHeadInfo, arg.seq, arg.dueDate, arg.orderType, arg.shipCompFlag, arg.customerPONO, arg.orderNote, arg.isSpecialShip, appUser, true);
}
//Detail Part
List <TS_OR_DETAIL_STAGE> dStageList = null;
if (arg.olList != null && arg.olList.Count > 0)
{
dStageList = new List <TS_OR_DETAIL_STAGE>();
foreach (var item in arg.olList)
{
//ignore wrong lines
if (string.IsNullOrEmpty(item.PartNo) || string.IsNullOrEmpty(item.PriAVLCheckColor))
{
continue;
}
TS_OR_DETAIL_STAGE dStage = ManualClassConvert.ConvertOLItem2DetailStage(item, arg.seq, appUser);
dStageList.Add(dStage);
}
}
decimal seq = 0;
if (string.IsNullOrEmpty(arg.seq))
{
seq = bll.AddHeadersWithDetailsStage(orHeaderStage, altORHeaderStage, dStageList);
}
else
{
seq = bll.UpdateHeadersWithDetailsStage(orHeaderStage, altORHeaderStage, dStageList);
}
if (seq != 0.00M)
{
return(Content(seq.ToString()));
}
else
{
Response.StatusCode = (int)HttpStatusCode.InternalServerError;
return(Content("Fail to save draft"));
}
}
catch (Exception ee)
{
//log ee
Response.StatusCode = (int)HttpStatusCode.InternalServerError;
return(Content(ee.Message));
}
}
