public ActionResult SearchAddrs(string shipName, string addr, string aliasName, bool isSpecialShip, string destName, long?destLocation)
{
try
{
List <ExVAliasAddr> list = new List <ExVAliasAddr>();
CHubEntities db = new CHubEntities();
if (isSpecialShip)
{
V_ALIAS_ADDR_SPL_BLL bll = new V_ALIAS_ADDR_SPL_BLL();
list = bll.GetAliasAddrSPL(shipName.Trim(), addr.Trim(), destName.Trim(), destLocation, aliasName);
}
else
{
V_ALIAS_ADDR_DFLT_BLL bll = new V_ALIAS_ADDR_DFLT_BLL();
list = bll.GetAliasAddrDFLT(aliasName);
}
//Get from parameter table***
if (list.Count > 20)
{
return(Json(new RequestResult(false, string.Format("Result has {0} items, Make Condition more strict", list.Count.ToString()))));
}
if (list.Count == 0)
{
return(Json(new RequestResult(false, "No result")));
}
return(Json(new RequestResult(list)));
}
catch (Exception ee)
{
return(Json(new RequestResult(false, ee.Message)));
}
}
public ActionResult GetStrictAddrs(string shipName, string addr, string aliasName, bool isSpecialShip)
{
try
{
List <ExVAliasAddr> list = new List <ExVAliasAddr>();
CHubEntities db = new CHubEntities();
if (isSpecialShip)
{
V_ALIAS_ADDR_SPL_BLL bll = new V_ALIAS_ADDR_SPL_BLL();
list = bll.GetStrictAliasAddrSPL(shipName.Trim(), addr.Trim(), aliasName);
}
else
{
V_ALIAS_ADDR_DFLT_BLL bll = new V_ALIAS_ADDR_DFLT_BLL();
list = bll.GetStrictAliasAddrDFLT(shipName.Trim(), addr.Trim(), aliasName);
}
return(Json(list));
}
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));
}
}
