public void RecordResultAPI(string type, string code)
{
this.message = this.message.Replace("'", "\"");
string sql = string.Format("insert into MM_Error_ION (Type,Code,Message,ERROR_CODE,FileName,ADDDATE) values ('{0}','{1}','{2}','{3}','{4}','{5}')", type, code, this.message, this.errcode.ToString(), "", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
DAL.SELECT_SQL(sql);
}
public static DataTable GetNewToken()
{
string sql = string.Format("select AccessToken,EndTime from ION_TOKEN");
DataTable dtToken = DAL.SELECT_SQL(sql);
return(dtToken);
}
public JArray Create_ModelAltSku(string sku)
{
JArray altSkus = new JArray();
string sql = string.Format("PR_MM_BARCODE_ARTICLES_INFORMATION '{0}' , '{1}' ", "SOUTH", sku);
DataTable dt = DAL.SELECT_SQL(sql);
if (dt.Rows.Count > 0)
{
code = sku;
sku = sku.TrimStart('0');
int count = DAL.IntReturn(dt.Rows.Count);
for (int i = 0; i < count; i++)
{
try
{
AltSku altSku = new AltSku();
altSku.altsku = dt.Rows[i]["Barcode"].ToString();
altSku.storerkey = "OW9600";
altSku.sku = sku;
string output = JsonConvert.SerializeObject(altSku);
JObject objectAltSku = JObject.Parse(output);
altSkus.Add(objectAltSku);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_ALTSKU, "SOUTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
}
return(altSkus);
}
public void Handle_Error_Mapping(string code, string message, string step)
{
message = message.Replace("'", "\"").Replace("\r\n", " ").Replace("\n", " ");
string sql = string.Format("INSERT INTO MM_ERROR_MAPPING(CODE,Message,STEP,AddDate) VALUES ('{0}','{1}','{2}','{3}')", code, message, step, DateTime.Now);
DAL.SELECT_SQL(sql);
}
public IList <Receiptdetail> Create_ReceiptDetail(string pokey_infor, string pokey_mm, string receiptkey)
{
IList <Receiptdetail> receiptdetails = new List <Receiptdetail>();
string sql = string.Format("select * from MM_PO_DETAIL where Order_Number = '{0}' and STATUS_ASN='' and Warehouse_Number='90072' and Order_Number='00000202072040416' ", pokey_mm);
DataTable dt = DAL.SELECT_SQL(sql);
int count = DAL.IntReturn(dt.Rows.Count);
for (int i = 0; i < count; i++)
{
try
{
Receiptdetail receiptdetail = new Receiptdetail();
receiptdetail.receiptkey = receiptkey;
receiptdetail.storerkey = "N0528";
string sku = dt.Rows[i]["Article_Number"].ToString().Trim().TrimStart('0');
receiptdetail.sku = sku;
receiptdetail.qtyexpected = DAL.IntReturn(dt.Rows[i]["Order_Quantity"]);
receiptdetail.pokey = pokey_infor;
receiptdetail.addwho = "wmsadmin";
receiptdetail.editwho = "wmsadmin";
receiptdetails.Add(receiptdetail);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_ASN_DETAIL, "NORTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
return(receiptdetails);
}
public IList <Orderdetail> Create_OrderDetail(string orderkey_MM, string orderkey_Infor)
{
IList <Orderdetail> orderDetails = new List <Orderdetail>();
string sql = string.Format("select * from MM_ORDERS_DETAIL where Order_Number = '{0}' and STATUS=''", orderkey_MM);
DataTable dt = DAL.SELECT_SQL(sql);
int count = DAL.IntReturn(dt.Rows.Count);
for (int i = 0; i < count; i++)
{
Orderdetail orderDetail = new Orderdetail();
orderDetail.orderkey = orderkey_Infor;
orderDetail.storerkey = "OW0094";
orderDetail.sku = dt.Rows[i]["Article_Number"].ToString();
orderDetail.openqty = DAL.IntReturn(dt.Rows[i]["Order_Quantity"]);
orderDetail.originalqty = DAL.IntReturn(dt.Rows[i]["Order_Quantity"]);
orderDetail.newallocationstrategy = "N01";
orderDetail.susr2 = dt.Rows[i]["Article_Selling_Price"].ToString();
orderDetail.whseid = "wmwhse3";
orderDetail.addwho = "wmsadmin";
orderDetail.editwho = "wmsadmin";
orderDetails.Add(orderDetail);
}
return(orderDetails);
}
public DataTable Get_Receiptkey(int count, string warehouse, string type)
{
string sql = string.Format("Exec [PP_MM_CREATE_RECEIPTKEY] {0} ,'{1}','{2}'", count, warehouse, type);
DataTable dt = DAL.SELECT_SQL(sql);
return(dt);
}
public JArray Create_ModelPo_South()
{
JArray pos = new JArray();
string sqlHeader = string.Format("select * from MM_PO_HEADER where STATUS = ''");
DataTable dt = DAL.SELECT_SQL(sqlHeader);
int count = dt.Rows.Count;
DataTable dtPokey = this.Get_Pokey(count);
if (count > 0 && dtPokey.Rows.Count == count)
{
for (int i = 0; i < count; i++)
{
POInfor_Model po = new POInfor_Model();
IList <Podetail> podetails = new List <Podetail>();
string pokey_Infor = dtPokey.Rows[i][0].ToString();
po.pokey = pokey_Infor;
po.potype = "1";
po.storerkey = "ow9305";
po.externpokey = dt.Rows[i]["Order_Number"].ToString();
po.whseid = "wmwhse7";
po.addwho = "wmsadmin";
po.editwho = "wmsadmin";
podetails = this.Create_PoDetail(po.externpokey, pokey_Infor);
po.podetails = podetails;
string output = JsonConvert.SerializeObject(po);
JObject objectPo = JObject.Parse(output);
pos.Add(objectPo);
}
}
return(pos);
}
public DataTable Get_Pokey_South(int count)
{
string sql = string.Format("Exec [PP_Create_Pokey_MM] {0}", count);
DataTable dt = DAL.SELECT_SQL(sql);
return(dt);
}
public void Handle_Error_Sftp(string fileName, string message)
{
message = message.Replace("'", "\"").Replace("\r\n", " ").Replace("\n", " ");
string sql = string.Format("INSERT INTO MM_Error_SFTP(FileName,Message,AddDate) VALUES ('{0}','{1}','{2}')", fileName, message, DateTime.Now);
DAL.SELECT_SQL(sql);
}
public IList <Podetail> Create_PoDetail(string pokey_mm, string pokey_infor)
{
IList <Podetail> poDetails = new List <Podetail>();
string sql = string.Format("MM_GET_INFORMATION_PODETAIL '{0}'", pokey_mm);
DataTable dt = DAL.SELECT_SQL(sql);
int count = DAL.IntReturn(dt.Rows.Count);
for (int i = 0; i < count; i++)
{
try
{
Podetail poDetail = new Podetail();
poDetail.pokey = pokey_infor;
poDetail.storerkey = "OW9600";
string sku = dt.Rows[i]["Article_Number"].ToString().Trim().TrimStart('0');
poDetail.sku = sku;
poDetail.qtyordered = DAL.IntReturn(dt.Rows[i]["Order_Quantity"]);
poDetail.susr1 = dt.Rows[i]["Order_Quantity"].ToString();
poDetail.whseid = "wmwhse10";
poDetail.addwho = "wmsadmin";
poDetail.editwho = "wmsadmin";
poDetails.Add(poDetail);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_PODETAIL, "SOUTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
return(poDetails);
}
public DataTable Get_Orderkey_South(int count, string warehouse, string type)
{
string sql = string.Format("Exec PP_MM_Create_Orderkey {0} ,'{1}', '{2}'", count, warehouse, type);
DataTable dt = DAL.SELECT_SQL(sql);
return(dt);
}
public void HandleError(string fileName, string text, string message, string code, string category)
{
message = message.Replace("'", "\"");
string sql = string.Format("INSERT INTO MM_Error_Insert_Update(FILENAME,CODE,TEXT,MESSAGE,ADDDATE,CATEGORY) VALUES('{0}','{1}','{2}','{3}','{4}','{5}')", fileName, code, text, message, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), category);
DAL.SELECT_SQL(sql);
}
public IList <Podetail> Create_PoDetail(string pokey_mm, string pokey_infor)
{
IList <Podetail> poDetails = new List <Podetail>();
string sql = string.Format("select * from MM_PO_DETAIL where Order_Number = '{0}' and STATUS='' and Warehouse_Number='90072' order by Article_Number asc", pokey_mm);
DataTable dt = DAL.SELECT_SQL(sql);
int count = DAL.IntReturn(dt.Rows.Count);
for (int i = 0; i < count; i++)
{
try
{
Podetail poDetail = new Podetail();
poDetail.pokey = pokey_infor;
poDetail.storerkey = "N0528";
string sku = dt.Rows[i]["Article_Number"].ToString().Trim().TrimStart('0');
poDetail.sku = sku;
poDetail.qtyordered = DAL.IntReturn(dt.Rows[i]["Order_Quantity"]);
poDetail.whseid = "wmwhse3";
poDetail.addwho = "wmsadmin";
poDetail.editwho = "wmsadmin";
poDetails.Add(poDetail);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_PODETAIL, "NORTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
return(poDetails);
}
public DataTable Get_Orderkey(int count)
{
string sql = string.Format("Exec PP_MM_Create_orderkey {0}", count);
DataTable dt = DAL.SELECT_SQL(sql);
return(dt);
}
public static DateTime GetTimeFinishToken()
{
string sql = string.Format("select ENDTIME from ION_TOKEN");
DataTable dt = DAL.SELECT_SQL(sql);
DateTime endTime = DateTime.Parse(dt.Rows[0][0].ToString());
return(endTime);
}
public JArray Create_ModelSO()
{
JArray orders = new JArray();
string sqlHeader = string.Format("select * from MM_ORDERS_HEADER where STATUS='' and Warehouse_Number='90071' ");
DataTable dt = DAL.SELECT_SQL(sqlHeader);
int count = dt.Rows.Count;
DataTable dtOrderkey = this.Get_Orderkey_South(count, "90071", "CS");
if (count > 0 && dtOrderkey.Rows.Count == count)
{
for (int i = 0; i < count; i++)
{
try
{
SOInfor_Model_South so = new SOInfor_Model_South();
IList <Orderdetail_South> orderDetail = new List <Orderdetail_South>();
string type = dt.Rows[i]["Order_Type"].ToString().Trim();
string orderkey_infor = dtOrderkey.Rows[i][0].ToString();
string orderkey_mm = dt.Rows[i]["Order_Number"].ToString().Trim();
string storer = dt.Rows[i]["Store_Number"].ToString().Trim().TrimStart('0');
string externorderkey = "S" + storer.Substring(3, 2);
code = orderkey_mm;
so.type = "9602";
so.orderkey = orderkey_infor;
so.storerkey = "OW9600";
so.consigneekey = storer;
so.externalorderkey2 = orderkey_mm;
so.externorderkey = externorderkey;
so.notes2 = dt.Rows[i]["Memo_Field"].ToString().Trim();
so.pokey = "";
so.requestedshipdate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_Date"].ToString());
so.deliverydate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_To_Warehouse"].ToString());
so.orderdate = DateTime.Parse(dt.Rows[i]["Order_Date"].ToString());
so.addwho = "wmsadmin";
so.editwho = "wmsadmin";
so.whseid = "wmwhse10";
orderDetail = this.Create_OrderDetail(orderkey_mm, orderkey_infor);
so.orderdetails = orderDetail;
string output = JsonConvert.SerializeObject(so);
JObject objectSO = JObject.Parse(output);
orders.Add(objectSO);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_SO, "CS_SOUTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
}
return(orders);
}
public JArray Create_ModelSO_Return()
{
JArray orders = new JArray();
string sqlHeader = string.Format("select * from [V_MM_SO_RETURN_HEADER_SOUTH] ");
DataTable dt = DAL.SELECT_SQL(sqlHeader);
int count = dt.Rows.Count;
DataTable dtOrderkey = this.Get_Orderkey_South(count, "90071", "RT");
if (count > 0 && dtOrderkey.Rows.Count == count)
{
for (int i = 0; i < count; i++)
{
try
{
SOInfor_Model_South so = new SOInfor_Model_South();
IList <Orderdetail_South> orderDetail = new List <Orderdetail_South>();
string orderkey_infor = dtOrderkey.Rows[i][0].ToString();
string po_MM = dt.Rows[i]["Order_Number"].ToString().Trim();
string supplier = dt.Rows[i]["Supplier_Number"].ToString().TrimStart('0');
string externorderkey = supplier;
code = po_MM;
so.type = "9603";
so.orderkey = orderkey_infor;
so.storerkey = "OW9600";
so.consigneekey = "STD";
so.externalorderkey2 = po_MM;
so.externorderkey = externorderkey;
so.susr2 = "";
so.notes2 = "";
so.pokey = "";
so.requestedshipdate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_Date"].ToString());
so.deliverydate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_Date"].ToString());
so.orderdate = DateTime.Parse(dt.Rows[i]["Order_Date"].ToString());
so.addwho = "wmsadmin";
so.editwho = "wmsadmin";
so.whseid = "wmwhse10";
orderDetail = this.Create_OrderDetail_Return(po_MM, orderkey_infor);
so.orderdetails = orderDetail;
string output = JsonConvert.SerializeObject(so);
JObject objectSO = JObject.Parse(output);
orders.Add(objectSO);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_SO, "RETURN_SOUTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
}
return(orders);
}
public JArray Create_ModelSO_Return()
{
JArray orders = new JArray();
string sqlHeader = string.Format("select * from [V_MM_SO_RETURN_HEADER_NORTH]");
DataTable dt = DAL.SELECT_SQL(sqlHeader);
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
try
{
SOInfor_Model so = new SOInfor_Model();
IList <Orderdetail> orderDetail = new List <Orderdetail>();
string po_MM = dt.Rows[i]["Order_Number"].ToString().Trim();
string supplier = dt.Rows[i]["Supplier_Number"].ToString().TrimStart('0');
code = po_MM;
so.type = "150";
string orderkey_infor = po_MM.TrimStart('0');
so.orderkey = "RT_" + orderkey_infor;
so.storerkey = "N0528";
so.consigneekey = "STD"; //dt.Rows[0]["Store_Number"].ToString();
so.externalorderkey2 = po_MM;
so.externorderkey = supplier;
so.notes2 = "";
so.pokey = "";
//so.stage = dt.Rows[0]["Store_Number"].ToString();
so.planneddelvdate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_Date"].ToString());
so.promiseddelvdate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_Date"].ToString());
so.orderdate = DateTime.Parse(dt.Rows[i]["Order_Date"].ToString());
so.addwho = "wmsadmin";
so.editwho = "wmsadmin";
so.whseid = "wmwhse3";
so.apportion = "0";
orderDetail = this.Create_OrderDetail_Return(po_MM, orderkey_infor);
so.orderdetails = orderDetail;
string output = JsonConvert.SerializeObject(so);
JObject objectSO = JObject.Parse(output);
orders.Add(objectSO);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_SO, "RETURN_NORTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
}
return(orders);
}
public JArray Create_ModelSO()
{
JArray orders = new JArray();
string sqlHeader = string.Format("select * from MM_ORDERS_HEADER where STATUS='' and Warehouse_Number='90072' ");
DataTable dt = DAL.SELECT_SQL(sqlHeader);
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
try
{
SOInfor_Model so = new SOInfor_Model();
IList <Orderdetail> orderDetail = new List <Orderdetail>();
string type = dt.Rows[i]["Order_Type"].ToString().Trim();
string orderkey_mm = dt.Rows[i]["Order_Number"].ToString().Trim();
code = orderkey_mm;
string orderkey_infor = orderkey_mm.Trim().TrimStart('0');
string store = dt.Rows[i]["Store_Number"].ToString().Trim().TrimStart('0');
so.type = "14";
so.orderkey = orderkey_infor;
so.storerkey = "N0528";
so.consigneekey = store;
so.externalorderkey2 = orderkey_mm;
so.externorderkey = dt.Rows[i]["Warehouse_Number"].ToString().Trim();
so.notes2 = dt.Rows[i]["Memo_Field"].ToString().Trim();
so.pokey = "";
so.stage = store.Substring(3, 2);
so.apportion = "1";
so.planneddelvdate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_Date"].ToString());
so.promiseddelvdate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_To_Warehouse"].ToString());
so.orderdate = DateTime.Parse(dt.Rows[i]["Order_Date"].ToString());
so.addwho = "wmsadmin";
so.editwho = "wmsadmin";
so.whseid = "wmwhse3";
orderDetail = this.Create_OrderDetail(orderkey_mm, orderkey_infor);
so.orderdetails = orderDetail;
string output = JsonConvert.SerializeObject(so);
JObject objectSO = JObject.Parse(output);
orders.Add(objectSO);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_SO, "CS_NORTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
}
return(orders);
}
public JArray Create_ModelSO_Xdock()
{
JArray orders = new JArray();
string sqlHeader = string.Format("select * from V_MM_SO_XDOCK_HEADER_SOUTH ");
DataTable dt = DAL.SELECT_SQL(sqlHeader);
int count = dt.Rows.Count;
DataTable dtOrderkey = this.Get_Orderkey_South(count, "90071", "XD");
if (count > 0 && dtOrderkey.Rows.Count == count)
{
for (int i = 0; i < count; i++)
{
try
{
SOInfor_Model_South so = new SOInfor_Model_South();
IList <Orderdetail_South> orderDetail = new List <Orderdetail_South>();
string orderkey_infor = dtOrderkey.Rows[i][0].ToString();
string orderkey_mm = dt.Rows[i]["SO"].ToString();
code = orderkey_mm;
string storer = dt.Rows[i]["Store"].ToString();
string externorderkey = "S" + storer.Substring(3, 2);
so.type = "0";
so.orderkey = orderkey_infor;
so.storerkey = "OW9600";
so.consigneekey = dt.Rows[i]["Store"].ToString();
so.externalorderkey2 = orderkey_mm;
so.externorderkey = externorderkey;
so.susr1 = orderkey_mm;
so.requestedshipdate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")); //DateTime.Parse(dt.Rows[i]["Plan_Delivery_Date"].ToString().Trim());
so.deliverydate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
so.orderdate = DateTime.Parse(dt.Rows[i]["Order_Date"].ToString().Trim());
so.addwho = "wmsadmin";
so.editwho = "wmsadmin";
so.whseid = "wmwhse10";
orderDetail = this.Create_OrderDetail_Xdock(orderkey_infor, orderkey_mm);
so.orderdetails = orderDetail;
string output = JsonConvert.SerializeObject(so);
JObject objectSO = JObject.Parse(output);
orders.Add(objectSO);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_SO, "XDOCK_SOUTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
}
return(orders);
}
public JObject Update_Model_South(string sku)
{
JObject pack = new JObject();
try
{
PackInfor_Model_Update_South packModel = new PackInfor_Model_Update_South();
string sql = string.Format("[PP_MM_UPDATE_PACK]'SOUTH','{0}'", sku);
DataTable dt = DAL.SELECT_SQL(sql);
string sku_current = sku.TrimStart('0');
packModel.packkey = sku_current + "_MMSOUTH";
int qtyPerPallet = DAL.IntReturn(dt.Rows[0]["PALLET_NEW"]);
packModel.packdescr = sku_current + "_MMSOUTH";
packModel.packuom1 = "CS";
int qtyPerCase = DAL.IntReturn(dt.Rows[0]["Number_Mu_Carton"]);
packModel.casecnt = qtyPerCase.ToString();
packModel.packuom3 = "MU";
packModel.cartonizeuom3 = "N";
packModel.pallet = qtyPerPallet.ToString();
int qtyInnerPack = DAL.IntReturn(dt.Rows[0]["INNERPACK_NEW"]);
packModel.innerpack = qtyInnerPack.ToString();
decimal carton_lenght1 = DAL.DecimalReturn(dt.Rows[0]["Carton_Length"]);
decimal carton_width1 = DAL.DecimalReturn(dt.Rows[0]["Carton_Width"]);
decimal carton_height1 = DAL.DecimalReturn(dt.Rows[0]["Carton_Height"]);
packModel.lengthuom1 = carton_lenght1.ToString();
packModel.widthuom1 = carton_width1.ToString();
packModel.heightuom1 = carton_height1.ToString();
decimal carton_lenght3 = DAL.DecimalReturn(dt.Rows[0]["Selling_Unit_Length"]);
decimal carton_width3 = DAL.DecimalReturn(dt.Rows[0]["Selling_Unit_Width"]);
decimal carton_height3 = DAL.DecimalReturn(dt.Rows[0]["Selling_Unit_Height"]);
packModel.lengthuom3 = carton_lenght3.ToString();
packModel.widthuom3 = carton_width3.ToString();
packModel.heightuom3 = carton_height3.ToString();
packModel.whseid = "wmwhse10";
packModel.addwho = "Admin";
packModel.editwho = "Admin";
string output = JsonConvert.SerializeObject(packModel);
pack = JObject.Parse(output);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_PACK, "SOUTH");
resultMapping.Handle_Error_Mapping(sku, e.ToString(), step);
}
return(pack);
}
public JArray Create_ModelSO_Xdock()
{
JArray orders = new JArray();
string sqlHeader = string.Format("select * from V_MM_SO_XDOCK_HEADER_NORTH");
DataTable dt = DAL.SELECT_SQL(sqlHeader);
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
try
{
SOInfor_Model so = new SOInfor_Model();
IList <Orderdetail> orderDetail = new List <Orderdetail>();
string orderkey_mm = dt.Rows[i]["SO"].ToString();
string pokey_MM = dt.Rows[i]["PO"].ToString();
code = pokey_MM + "_" + orderkey_mm;
string store = dt.Rows[i]["Store"].ToString().Trim().TrimStart('0');
so.type = "91";
so.orderkey = orderkey_mm.TrimStart('0');
so.storerkey = "N0528";
so.consigneekey = store;
so.externalorderkey2 = orderkey_mm;
so.externorderkey = dt.Rows[i]["Warehouse_Number"].ToString().Trim();
so.pokey = pokey_MM.TrimStart('0');
so.stage = store.Substring(3, 2);
so.apportion = "0";
so.planneddelvdate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_Date"].ToString().Trim()); //DateTime.Now.ToString('yyyy-MM-dd');
so.promiseddelvdate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_Date"].ToString().Trim());
so.orderdate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_Date"].ToString().Trim());
so.addwho = "wmsadmin";
so.editwho = "wmsadmin";
so.whseid = "wmwhse3";
orderDetail = this.Create_OrderDetail_Xdock(orderkey_mm, pokey_MM);
so.orderdetails = orderDetail;
string output = JsonConvert.SerializeObject(so);
JObject objectSO = JObject.Parse(output);
orders.Add(objectSO);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_SO, "XDOCK_NORTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
}
return(orders);
}
public JObject Create_ModelPack(string sku)
{
JObject pack = new JObject();
try
{
PackInfor_Model packModel = new PackInfor_Model();
string sql = string.Format("[PR_MM_PACK_INFORMATION_NORTH]'{0}'", sku);
DataTable dt = DAL.SELECT_SQL(sql);
sku = sku.TrimStart('0');
packModel.packkey = sku;
int qtyPerPallet = DAL.IntReturn(dt.Rows[0]["Number_Mu_Pallet"]);
packModel.pallet = qtyPerPallet.ToString();
packModel.packuom4 = "PL";
packModel.packdescr = qtyPerPallet + " PC per pallet";
packModel.packuom1 = "CS";
int qtyInCnt = DAL.IntReturn(dt.Rows[0]["Number_Mu_Carton"].ToString());
int qtyPerLayer = DAL.IntReturn(dt.Rows[0]["Number_Mu_Layer"].ToString());
int casecntPerLayer = qtyPerLayer / qtyInCnt;
packModel.palletti = casecntPerLayer.ToString();
packModel.pallethi = dt.Rows[0]["Number_Layer_Pallet"].ToString();
packModel.casecnt = dt.Rows[0]["Number_Mu_Carton"].ToString();
packModel.packuom3 = "MU";
packModel.cartonizeuom3 = "N";
decimal carton_lenght = DAL.DecimalReturn(dt.Rows[0]["Carton_Length"]);
decimal carton_width = DAL.DecimalReturn(dt.Rows[0]["Carton_Width"]);
decimal carton_height = DAL.DecimalReturn(dt.Rows[0]["Carton_Height"]);
decimal carton_grossWeight = DAL.DecimalReturn(dt.Rows[0]["Carton_GrossWeight"]);
packModel.lengthuom1 = carton_lenght.ToString();
packModel.widthuom1 = carton_width.ToString();
packModel.heightuom1 = carton_height.ToString();
packModel.weightuom1 = carton_grossWeight.ToString();
packModel.ext_udf_str1 = dt.Rows[0]["susr1"].ToString();
packModel.whseid = "wmwhse3";
packModel.addwho = "Admin";
packModel.editwho = "Admin";
string output = JsonConvert.SerializeObject(packModel);
pack = JObject.Parse(output);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_PACK, "NORTH");
resultMapping.Handle_Error_Mapping(sku, e.ToString(), step);
}
return(pack);
}
public JArray Create_ModelPo()
{
JArray pos = new JArray();
string sqlHeader = string.Format("select * from MM_PO_HEADER where STATUS = ''");
DataTable dt = DAL.SELECT_SQL(sqlHeader);
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
POInfor_Model po = new POInfor_Model();
IList <Podetail> podetails = new List <Podetail>();
string pokey_Infor = dt.Rows[i]["Order_Number"].ToString();
string type = dt.Rows[i]["Order_Type"].ToString().Trim();
switch (type)
{
case "19":
po.potype = "0";
break;
case "20":
po.potype = "1";
break;
case " ":
po.potype = "1";
break;
}
po.pokey = pokey_Infor;
po.storerkey = "ow0094";
po.externpokey = pokey_Infor;
po.expectedreceiptdate = DateTime.Parse(dt.Rows[i]["Plan_Delivery_Date"].ToString());
po.podate = DateTime.Parse(dt.Rows[i]["Order_Date"].ToString());
po.sellername = dt.Rows[i]["Supplier_Number"].ToString();
po.whseid = "wmwhse3";
po.addwho = "wmsadmin";
po.editwho = "wmsadmin";
podetails = this.Create_PoDetail(po.externpokey, pokey_Infor);
po.podetails = podetails;
string output = JsonConvert.SerializeObject(po);
JObject objectPo = JObject.Parse(output);
pos.Add(objectPo);
}
}
return(pos);
}
public JArray Create_ModelAsn()
{
JArray asns = new JArray();
string sqlHeader = string.Format("select * from MM_PO_HEADER where STATUS_ASN = '' and Warehouse_Number='90071' and Order_Type='02'");
DataTable dt = DAL.SELECT_SQL(sqlHeader);
int count = dt.Rows.Count;
DataTable dtReceiptkey = this.Get_Receiptkey(count, "90071", "ASN");
if (count > 0 && dtReceiptkey.Rows.Count == count)
{
for (int i = 0; i < count; i++)
{
try
{
ASNInfor_Model asn = new ASNInfor_Model();
IList <Receiptdetail> receiptdetails = new List <Receiptdetail>();
string pokey_mm = dt.Rows[i]["Order_Number"].ToString().Trim();
string pokey_infor = dt.Rows[i]["Order_Number"].ToString().Trim().TrimStart('0');
code = pokey_mm;
string receiptkey = dtReceiptkey.Rows[i][0].ToString();
string supplier = dt.Rows[i]["Supplier_Number"].ToString().Trim().TrimStart('0');
asn.receiptkey = receiptkey;
asn.addwho = "wmsadmin";
asn.storerkey = "OW9600";
asn.suppliercode = "RTV-" + supplier;
asn.type = "RTV-BBXD";
asn.pokey = pokey_infor;
asn.whseid = "wmwhse10";
receiptdetails = this.Create_ReceiptDetail(pokey_infor, pokey_mm, receiptkey);
asn.receiptdetails = receiptdetails;
string output = JsonConvert.SerializeObject(asn);
JObject objectAsn = JObject.Parse(output);
asns.Add(objectAsn);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_ASN, "SOUTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
}
return(asns);
}
public JObject Create_ModelPack_South(string sku)
{
JObject pack = new JObject();
try
{
PackInfor_Model_South packModel = new PackInfor_Model_South();
string sql = string.Format("select * from MM_Articles where Article_Number='{0}' and Warehouse_Number='90071'", sku);
DataTable dt = DAL.SELECT_SQL(sql);
sku = sku.TrimStart('0');
packModel.packkey = sku + "_MMSOUTH";
int qtyPerPallet = DAL.IntReturn(dt.Rows[0]["Number_Mu_Pallet"]);
packModel.packdescr = sku + "_MMSOUTH";
packModel.packuom1 = "CS";
int qtyPerCase = DAL.IntReturn(dt.Rows[0]["Number_Mu_Carton"]);
packModel.casecnt = qtyPerCase.ToString();
packModel.packuom3 = "MU";
packModel.cartonizeuom3 = "N";
decimal carton_lenght1 = DAL.DecimalReturn(dt.Rows[0]["Carton_Length"]);
decimal carton_width1 = DAL.DecimalReturn(dt.Rows[0]["Carton_Width"]);
decimal carton_height1 = DAL.DecimalReturn(dt.Rows[0]["Carton_Height"]);
packModel.lengthuom1 = carton_lenght1.ToString();
packModel.widthuom1 = carton_width1.ToString();
packModel.heightuom1 = carton_height1.ToString();
decimal carton_lenght3 = DAL.DecimalReturn(dt.Rows[0]["Selling_Unit_Length"]);
decimal carton_width3 = DAL.DecimalReturn(dt.Rows[0]["Selling_Unit_Width"]);
decimal carton_height3 = DAL.DecimalReturn(dt.Rows[0]["Selling_Unit_Height"]);
packModel.lengthuom3 = carton_lenght3.ToString();
packModel.widthuom3 = carton_width3.ToString();
packModel.heightuom3 = carton_height3.ToString();
packModel.whseid = "wmwhse10";
packModel.addwho = "Admin";
packModel.editwho = "Admin";
string output = JsonConvert.SerializeObject(packModel);
pack = JObject.Parse(output);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_PACK, "SOUTH");
resultMapping.Handle_Error_Mapping(sku, e.ToString(), step);
}
return(pack);
}
public JArray Update_ModelSku()
{
JArray items = new JArray();
string sql = string.Format("exec [PP_MM_UPDATE_ARTICLES] '{0}'", "NORTH");
DataTable dt = DAL.SELECT_SQL(sql);
if (dt.Rows.Count > 0)
{
int count = dt.Rows.Count;
for (int i = 0; i < count; i++)
{
try
{
SkuInfor_Model_Update_North item = new SkuInfor_Model_Update_North();
item.storerkey = "N0528";
string sku = dt.Rows[i]["Article_Number"].ToString().Trim();
code = dt.Rows[i]["Article_Number"].ToString().Trim();
sku = sku.TrimStart('0');
item.sku = sku;
item.descr = dt.Rows[i]["Desc_Article"].ToString().Trim().Replace("'", "\"");
item.susr4 = dt.Rows[i]["Artice_Subgroup_Number"].ToString().Trim();
item.addwho = "addmin";
item.editwho = "admin";
item.susr1 = dt.Rows[i]["susr1"].ToString().Trim().TrimStart('0');
//string logisticFlow = dt.Rows[i]["Logistic_Flow_Indicator"].ToString().Trim();
string output = JsonConvert.SerializeObject(item);
JObject objectitem = JObject.Parse(output);
items.Add(objectitem);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_SKU, "North");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
}
return(items);
}
public IList <Orderdetail> Create_OrderDetail_Xdock(string orderkey_mm, string pokey_MM)
{
IList <Orderdetail> orderDetails = new List <Orderdetail>();
string sql = string.Format("select * from [V_MM_SO_XDOCK_DETAIL] where Order_Number = '{0}' and Sale_Order='{1}'", pokey_MM, orderkey_mm);
DataTable dt = DAL.SELECT_SQL(sql);
int count = DAL.IntReturn(dt.Rows.Count);
for (int i = 0; i < count; i++)
{
try
{
Orderdetail orderDetail = new Orderdetail();
string sku = dt.Rows[i]["Article_Number"].ToString().Trim().TrimStart('0');
orderDetail.orderkey = orderkey_mm.TrimStart('0');
orderDetail.storerkey = "N0528";
orderDetail.sku = sku;
orderDetail.openqty = DAL.IntReturn(dt.Rows[i]["Order_Quantity"]);
orderDetail.originalqty = DAL.IntReturn(dt.Rows[i]["Order_Quantity"]);
orderDetail.newallocationstrategy = "MM";
orderDetail.susr2 = "";
orderDetail.lottable02 = "BBXD";
orderDetail.lottable03 = pokey_MM.TrimStart('0');
orderDetail.lottable10 = orderkey_mm.TrimStart('0');
orderDetail.whseid = "wmwhse3";
orderDetail.addwho = "wmsadmin";
orderDetail.editwho = "wmsadmin";
orderDetails.Add(orderDetail);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_SODETAIL, "XDOCK_NORTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
return(orderDetails);
}
public IList <Orderdetail_South> Create_OrderDetail_Return(string po_mm, string orderkey_infor)
{
IList <Orderdetail_South> orderDetails = new List <Orderdetail_South>();
string sql = string.Format("select * from V_MM_SO_RETURN_DETAIL_SOUTH where Order_Number = '{0}'", po_mm);
DataTable dt = DAL.SELECT_SQL(sql);
int count = DAL.IntReturn(dt.Rows.Count);
for (int i = 0; i < count; i++)
{
try
{
Orderdetail_South orderDetail = new Orderdetail_South();
orderDetail.orderkey = orderkey_infor;
orderDetail.storerkey = "OW9600";
string sku = dt.Rows[i]["Article_Number"].ToString().Trim().TrimStart('0');
orderDetail.sku = sku;
orderDetail.uom = "MU";
orderDetail.openqty = DAL.IntReturn(dt.Rows[i]["Order_Quantity"]);
orderDetail.originalqty = DAL.IntReturn(dt.Rows[i]["Order_Quantity"]);
orderDetail.susr2 = dt.Rows[i]["SUPPLIER"].ToString().Trim();
orderDetail.lottable10 = po_mm.TrimStart('0');
orderDetail.newallocationstrategy = "RTV";
orderDetail.whseid = "wmwhse10";
orderDetail.addwho = "wmsadmin";
orderDetail.editwho = "wmsadmin";
orderDetails.Add(orderDetail);
}
catch (Exception e)
{
string step = string.Format(Constant.MODEL_SODETAIL, "RETURN_SOUTH");
resultMapping.Handle_Error_Mapping(code, e.ToString(), step);
continue;
}
}
return(orderDetails);
}
