public HttpResponseMessage PostWMS_Cyclecount(List <BAL_PUSHDATA.DOC_HEADER_CLS> wMS_CycleCount)
{
try
{
/* header token */
IEnumerable <string> headerValues;
var TokenValue = string.Empty;
if (Request.Headers.TryGetValues("Token", out headerValues))
{
TokenValue = headerValues.FirstOrDefault();
}
/* header token ends */
if (TokenValue == "BNW@Cc!")
{
List <BAL_PUSHDATA.DOC_HEADER_CLS> NAVDATA = new List <BAL_PUSHDATA.DOC_HEADER_CLS>(); // 1)this will used in end of process, 2) collecting in list object Head/Detail and sending final response to the user
int count = wMS_CycleCount.Count;
for (int i = 0; i < count; i++)
{
BAL_PUSHDATA.DOC_HEADER_CLS P_objHeadDetail = new BAL_PUSHDATA.DOC_HEADER_CLS(); // creating object of the class for outer loop
P_objHeadDetail.H_DOCNO = wMS_CycleCount[i].H_DOCNO;
P_objHeadDetail.H_SUBDOCNO = wMS_CycleCount[i].H_SUBDOCNO;
P_objHeadDetail.H_WHNO = wMS_CycleCount[i].H_WHNO;
int detailcount = wMS_CycleCount[i].DOC_DETAIL_LIST.Count;
List <BAL_PUSHDATA.RESPONSE_DETAIL> cls_RESPONSE_OUTER = new List <BAL_PUSHDATA.RESPONSE_DETAIL>(); // creating the response class object for response sending to users
for (int j = 0; j < detailcount; j++)
{
List <BAL_PUSHDATA.RESPONSE_DETAIL> cls_RESPONSE_INNER = new List <BAL_PUSHDATA.RESPONSE_DETAIL>(); // cr
string DOCNO = wMS_CycleCount[i].H_DOCNO;
string SUBDOCNO = wMS_CycleCount[i].H_SUBDOCNO;
string WHNO = wMS_CycleCount[i].H_WHNO;
string ZONEID = wMS_CycleCount[i].DOC_DETAIL_LIST[j].D_ZONEID;
string BINNO = wMS_CycleCount[i].DOC_DETAIL_LIST[j].D_BINID;
string BARCODE = wMS_CycleCount[i].DOC_DETAIL_LIST[j].D_BARCODE;
string ITEMNO = wMS_CycleCount[i].DOC_DETAIL_LIST[j].D_ITEMNO;
string SERIALNO = wMS_CycleCount[i].DOC_DETAIL_LIST[j].D_SERIALNO;
string QTY = wMS_CycleCount[i].DOC_DETAIL_LIST[j].D_QTY;
string DESCRIPTION = wMS_CycleCount[i].DOC_DETAIL_LIST[j].D_DESCRIPTION;
string UOM = wMS_CycleCount[i].DOC_DETAIL_LIST[j].D_UOM;
try
{
cmd.CommandText = "WMS_NAVDATA_PULL";
cmd.Parameters.AddWithValue("@STATUS", 3);
cmd.Parameters.AddWithValue("@WHNO", WHNO);
cmd.Parameters.AddWithValue("@DOCNO", DOCNO);
cmd.Parameters.AddWithValue("@SUBDOCNO", SUBDOCNO);
cmd.Parameters.AddWithValue("@BARCODE", BARCODE);
cmd.Parameters.AddWithValue("@ITEMNO", ITEMNO);
cmd.Parameters.AddWithValue("@SERAILNO", SERIALNO);
cmd.Parameters.AddWithValue("@ITEMDESC", DESCRIPTION);
cmd.Parameters.AddWithValue("@UOM", UOM);
cmd.Parameters.AddWithValue("@QTY", QTY);
cmd.Parameters.AddWithValue("@BINNO", BINNO);
cmd.Parameters.AddWithValue("@ZONEID", ZONEID);
int k = dbt.EXECUTENONQUERY_PROCE_FUNCTION(cmd);
cmd.Parameters.Clear();
BAL_PUSHDATA.RESPONSE_DETAIL OBJ_PDTL = new BAL_PUSHDATA.RESPONSE_DETAIL(); // SIMPLE CLASS OBJECT TO STORE Indivisual
OBJ_PDTL.D_SERIALNO = SERIALNO;
OBJ_PDTL.D_ITEMNO = ITEMNO;
OBJ_PDTL.D_MESSAGE = "SUCCESS";
OBJ_PDTL.D_SUCCESS = 1;
cls_RESPONSE_INNER.Add(OBJ_PDTL); // adding SIMPLE CLASS OBJECT to list
}
catch (Exception ex)
{
// OnFailuer: applying header and detail to innser response list object
cmd.Parameters.Clear();
BAL_PUSHDATA.RESPONSE_DETAIL OBJ_PDTL = new BAL_PUSHDATA.RESPONSE_DETAIL(); // SIMPLE CLASS OBJECT TO STORE Indivisual
OBJ_PDTL.D_SERIALNO = SERIALNO;
OBJ_PDTL.D_ITEMNO = ITEMNO;
if (ex.Message.Contains("PRIMARY KEY constraint"))
{
OBJ_PDTL.D_MESSAGE = "Duplicate Record";
}
else
{
OBJ_PDTL.D_MESSAGE = ex.ToString();
}
OBJ_PDTL.D_SUCCESS = 0;
cls_RESPONSE_INNER.Add(OBJ_PDTL); // adding SIMPLE CLASS OBJECT to list
LogError(ex, OBJ_PDTL.D_ITEMNO);
}
cls_RESPONSE_OUTER.AddRange(cls_RESPONSE_INNER);
P_objHeadDetail.RESPONSE_LIST = cls_RESPONSE_OUTER;
}
NAVDATA.Add(P_objHeadDetail);
}
return(new HttpResponseMessage()
{
Content = new StringContent(JArray.FromObject(NAVDATA).ToString(), Encoding.UTF8, "application/json")
});
}
else
{
var message = string.Format("Invalid Token");
HttpError err = new HttpError(message);
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
catch (Exception ex)
{
var message = string.Format("Error");
LogError(ex, message);
HttpError err = new HttpError(message);
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
public HttpResponseMessage PostWMS_PICKING(List <BAL_PUSHDATA.PICKING_CLS> wMS_PICKING)
{
try
{
IEnumerable <string> headerValues;
var TokenValue = string.Empty;
if (Request.Headers.TryGetValues("Token", out headerValues))
{
TokenValue = headerValues.FirstOrDefault();
}
if (TokenValue == "BNW@Pick!")
{
List <BAL_PUSHDATA.PICKING_CLS> NAVDATA = new List <BAL_PUSHDATA.PICKING_CLS>();
int count = wMS_PICKING.Count;
for (int i = 0; i < count; i++)
{
BAL_PUSHDATA.PICKING_CLS P = new BAL_PUSHDATA.PICKING_CLS();
P.H_DOCNO = wMS_PICKING[i].H_DOCNO;
P.H_PICKNO = wMS_PICKING[i].H_PICKNO;
P.H_WHNO = wMS_PICKING[i].H_WHNO;
List <BAL_PUSHDATA.RESPONSE_DETAIL> PTDTL = new List <BAL_PUSHDATA.RESPONSE_DETAIL>();
int detailcount = wMS_PICKING[i].PICKINGDETAIL_LIST.Count;
for (int j = 0; j < detailcount; j++)
{
List <BAL_PUSHDATA.RESPONSE_DETAIL> PTDTL1 = new List <BAL_PUSHDATA.RESPONSE_DETAIL>();
BAL_PUSHDATA.PICKING_CLS P1 = new BAL_PUSHDATA.PICKING_CLS();
string DOCNO = wMS_PICKING[i].H_DOCNO;
string PICKNO = wMS_PICKING[i].H_PICKNO;
string WHNO = wMS_PICKING[i].H_WHNO;
string ZONEID = wMS_PICKING[i].PICKINGDETAIL_LIST[j].D_ZONEID;
string EANCODE = wMS_PICKING[i].PICKINGDETAIL_LIST[j].D_EANCODE;
string BINID = wMS_PICKING[i].PICKINGDETAIL_LIST[j].D_BINID;
string BARCODE = wMS_PICKING[i].PICKINGDETAIL_LIST[j].D_BARCODE;
string ITEMNO = wMS_PICKING[i].PICKINGDETAIL_LIST[j].D_ITEMNO;
string SERIALNO = wMS_PICKING[i].PICKINGDETAIL_LIST[j].D_SERIALNO;
string QTY = wMS_PICKING[i].PICKINGDETAIL_LIST[j].D_QTY;
string DESCRIPTION = wMS_PICKING[i].PICKINGDETAIL_LIST[j].D_DESCRIPTION;
string UOM = wMS_PICKING[i].PICKINGDETAIL_LIST[j].D_UOM;
try
{
cmd.CommandText = "WMS_NAVDATA_PULL";
cmd.Parameters.AddWithValue("@STATUS", 2);
cmd.Parameters.AddWithValue("@WHNO", WHNO);
cmd.Parameters.AddWithValue("@DOCNO", DOCNO);
cmd.Parameters.AddWithValue("@SUBDOCNO", PICKNO);
cmd.Parameters.AddWithValue("@BARCODE", BARCODE);
cmd.Parameters.AddWithValue("@ITEMNO", ITEMNO);
cmd.Parameters.AddWithValue("@SERAILNO", SERIALNO);
cmd.Parameters.AddWithValue("@ITEMDESC", DESCRIPTION);
cmd.Parameters.AddWithValue("@UOM", UOM);
cmd.Parameters.AddWithValue("@QTY", QTY);
cmd.Parameters.AddWithValue("@BINNO", BINID);
cmd.Parameters.AddWithValue("@ZONEID", ZONEID);
cmd.Parameters.AddWithValue("@EANCODE", EANCODE);
int k = dbt.EXECUTENONQUERY_PROCE_FUNCTION(cmd);
cmd.Parameters.Clear();
//if (k > 0)
{
P.H_DOCNO = wMS_PICKING[i].H_DOCNO;
P.H_PICKNO = wMS_PICKING[i].H_PICKNO;
P.H_WHNO = wMS_PICKING[i].H_WHNO;
BAL_PUSHDATA.RESPONSE_DETAIL OBJ_PDTL = new BAL_PUSHDATA.RESPONSE_DETAIL();
OBJ_PDTL.D_SERIALNO = SERIALNO;
OBJ_PDTL.D_ITEMNO = ITEMNO;
OBJ_PDTL.D_MESSAGE = "SUCCESS";
OBJ_PDTL.D_SUCCESS = 1;
PTDTL1.Add(OBJ_PDTL);
}
}
catch (Exception ex)
{
cmd.Parameters.Clear();
P.H_DOCNO = wMS_PICKING[i].H_DOCNO;
P.H_PICKNO = wMS_PICKING[i].H_PICKNO;
P.H_WHNO = wMS_PICKING[i].H_WHNO;
BAL_PUSHDATA.RESPONSE_DETAIL OBJ_PDTL = new BAL_PUSHDATA.RESPONSE_DETAIL();
OBJ_PDTL.D_SERIALNO = SERIALNO;
OBJ_PDTL.D_ITEMNO = ITEMNO;
if (ex.Message.Contains("PRIMARY KEY constraint"))
{
OBJ_PDTL.D_MESSAGE = "Duplicate Record";
}
else
{
OBJ_PDTL.D_MESSAGE = ex.ToString();
}
OBJ_PDTL.D_SUCCESS = 0;
PTDTL1.Add(OBJ_PDTL);
LogError(ex, P.H_DOCNO);
}
PTDTL.AddRange(PTDTL1);
P.RESPONSE_LIST = PTDTL;
}
NAVDATA.Add(P);
}
return(new HttpResponseMessage()
{
Content = new StringContent(JArray.FromObject(NAVDATA).ToString(), Encoding.UTF8, "application/json")
});
}
else
{
//Exception ex = null;
var message = string.Format("Invalid Token");
//LogError(ex, message);
HttpError err = new HttpError(message);
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
catch (Exception ex)
{
var message = string.Format("Error");
LogError(ex, message);
HttpError err = new HttpError(message);
return(Request.CreateResponse(HttpStatusCode.BadRequest, err));
}
}
