public void ProcessRequest(HttpContext context) { SqlConnection conn = new SqlConnection(strcon); long PTID = 0; try { if (context.Request.Form["oid"] != null) { orderID = long.Parse(context.Request.Form["oid"]); } if (context.Request.Form["wrid"] != null) { WarehouseID = long.Parse(context.Request.Form["wrid"]); } if (context.Request.Form["objname"] != null) { objname = context.Request.Form["objname"].ToString(); } if (context.Request.Form["uid"] != null) { UserID = long.Parse(context.Request.Form["uid"]); } if (context.Request.Form["page"] != null) { page = context.Request.Form["page"].ToString(); } if (context.Request.Form["isAllSelected"] != null) { AllSelect = context.Request.Form["isAllSelected"].ToString(); } if (context.Request.Form["Batch"] != null) { Batch = context.Request.Form["Batch"].ToString(); } if (context.Request.Form["loc"] != null) { LocID = long.Parse(context.Request.Form["loc"]); } if (context.Request.Form["pid"] != null) { ProdID = long.Parse(context.Request.Form["pid"]); } if (context.Request.Form["bulkdata"] != null) { BulkData = context.Request.Form["bulkdata"].ToString(); } iInboundClient Inbound = new iInboundClient(); string userName = GetUserID(UserID); CustomProfile profile = CustomProfile.GetProfile(userName); DataSet dsUserDetail = new DataSet(); dsUserDetail = GetUserDetails(UserID); CompanyID = long.Parse(dsUserDetail.Tables[0].Rows[0]["CompanyID"].ToString()); CustomerID = long.Parse(dsUserDetail.Tables[0].Rows[0]["CustomerID"].ToString()); int result = 0; context.Response.ContentType = "text/plain"; String jsonString = String.Empty; jsonString = "{\n"; /*json Loop Start*/ jsonString = jsonString + "\"result\":[{\n"; if (AllSelect == "yes") { result = BulkSavePutIn(orderID, objname, page, CompanyID, CustomerID, UserID, LocID, Batch, ProdID); if (result > 0) { jsonString = jsonString + "\"status\": \"success\",\n"; jsonString = jsonString + "\"reason\": \"\"\n"; } else { jsonString = jsonString + "\"status\": \"failed\",\n"; jsonString = jsonString + "\"reason\": \"Server error occured\"\n"; } } else { tPutInHead ph = new tPutInHead(); ph.ObjectName = objname; ph.OID = orderID; ph.PutInDate = DateTime.Now; ph.PutInBy = UserID; ph.Remark = ""; ph.CreatedBy = UserID; ph.CreationDate = DateTime.Now; ph.Status = getStatus(objname); ph.Company = CompanyID; ph.CustomerID = CustomerID; ph.OrderFrom = "Mobile"; PTID = GetPTINStatus(orderID, objname, UserID); if (PTID == 0) { PTID = Inbound.SavetPutInHead(ph, profile.DBConnection._constr); } if (PTID > 0) { int save = 0; string[] srno = BulkData.Split('|'); decimal srcount = Convert.ToDecimal(srno.Length); save = SavePutInDetail(orderID, PTID, ProdID, LocID, srcount, Batch); for (int i = 0; i <= srcount - 1; i++) { SaveLottablePutIn(orderID, srno[i].ToString(), objname, PTID, ProdID, 1, CompanyID, CustomerID, UserID, LocID, Batch); } if (save > 0) { jsonString = jsonString + "\"status\": \"success\",\n"; jsonString = jsonString + "\"reason\": \"\"\n"; } else { jsonString = jsonString + "\"status\": \"failed\",\n"; jsonString = jsonString + "\"reason\": \"Server error occured\"\n"; } } } jsonString = jsonString + "}]\n"; jsonString = jsonString + "}\n"; /*json Loop End*/ context.Response.Write(jsonString); } catch (Exception ex) { Login.Profile.ErrorHandling(ex, "bulk_assign_location", "ProcessRequest"); } finally { } }
public void ProcessRequest(HttpContext context) { SqlConnection conn = new SqlConnection(strcon); long PTID = 0; try { if (context.Request.QueryString["objname"] != null) { objname = context.Request.QueryString["objname"].ToString(); } if (context.Request.QueryString["oid"] != null) { orderID = long.Parse(context.Request.QueryString["oid"]); } if (context.Request.QueryString["wrid"] != null) { WarehouseID = long.Parse(context.Request.QueryString["wrid"]); } if (context.Request.QueryString["serialno"] != null) { serialno = (context.Request.QueryString["serialno"]).ToString(); } if (context.Request.QueryString["uid"] != null) { UserID = Convert.ToInt64(context.Request.QueryString["uid"]); } if (context.Request.QueryString["page"] != null) { page = (context.Request.QueryString["page"]).ToString(); } if (context.Request.QueryString["loc"] != null) { LocID = Convert.ToInt64(context.Request.QueryString["loc"]); } if (context.Request.QueryString["batch"] != null) { Batch = (context.Request.QueryString["batch"]).ToString(); } DataSet dsUserDetail = new DataSet(); dsUserDetail = GetUserDetails(UserID); CompanyID = long.Parse(dsUserDetail.Tables[0].Rows[0]["CompanyID"].ToString()); CustomerID = long.Parse(dsUserDetail.Tables[0].Rows[0]["CustomerID"].ToString()); long PrdID = 0; PrdID = GetPrdID(serialno, CompanyID, CustomerID); if (PrdID == 0) { PrdID = GetPrdIDNew(serialno, CompanyID, CustomerID); } if (PrdID == 0) { PrdID = GetPrdIDNewCode(serialno, CompanyID, CustomerID); } context.Response.ContentType = "text/plain"; String jsonString = String.Empty; jsonString = "{\n"; /*json Loop Start*/ jsonString = jsonString + "\"result\":[{\n"; if (PrdID == 0) { jsonString = jsonString + "\"status\": \"failed\",\n"; jsonString = jsonString + "\"reason\": \"SKU Not Available\"\n"; } else { DataTable dtorder = new DataTable(); dtorder = CheckSKUInOrder(PrdID, orderID, objname); if (dtorder.Rows.Count > 0) { DataTable dtsrorder = new DataTable(); dtsrorder = CheckSrNoInOrder(orderID, serialno, objname, PrdID); if (dtsrorder.Rows.Count > 0) { DataTable dtsrno = new DataTable(); dtsrno = CheckDuplicateSrNo(serialno, CompanyID, CustomerID, page, objname); if (dtsrno.Rows.Count > 0) { jsonString = jsonString + "\"status\": \"failed\",\n"; jsonString = jsonString + "\"reason\": \"Serial number already used\"\n"; } else { decimal ptqty = GetPtQty(orderID, objname, PrdID); decimal oqty = GetOrderQty(orderID, objname, PrdID); if (ptqty >= oqty) { jsonString = jsonString + "\"status\": \"failed\",\n"; jsonString = jsonString + "\"reason\": \"You have already reached max count\"\n"; } else { tPutInHead ph = new tPutInHead(); string userName = GetUserID(UserID); CustomProfile profile = CustomProfile.GetProfile(userName); iInboundClient Inbound = new iInboundClient(); ph.ObjectName = objname; ph.OID = orderID; ph.PutInDate = DateTime.Now; ph.PutInBy = UserID; ph.Remark = ""; ph.CreatedBy = UserID; ph.CreationDate = DateTime.Now; ph.Status = getStatus(objname); ph.Company = CompanyID; ph.CustomerID = CustomerID; ph.OrderFrom = "Mobile"; PTID = GetPTINStatus(orderID, objname, UserID); if (PTID == 0) { PTID = Inbound.SavetPutInHead(ph, profile.DBConnection._constr); } if (PTID > 0) { int save = SavePutInDetail(orderID, PTID, PrdID, LocID, 1, Batch); SaveLottablePutIn(orderID, serialno, objname, PTID, PrdID, 1, CompanyID, CustomerID, UserID, LocID, Batch); if (save > 0) { jsonString = jsonString + "\"status\": \"success\",\n"; jsonString = jsonString + "\"reason\": \"\"\n"; } else { jsonString = jsonString + "\"status\": \"failed\",\n"; jsonString = jsonString + "\"reason\": \"Server error occured\"\n"; } } } } } else { jsonString = jsonString + "\"status\": \"failed\",\n"; jsonString = jsonString + "\"reason\": \"Serial No. Not Available In Order\"\n"; } } else { jsonString = jsonString + "\"status\": \"failed\",\n"; jsonString = jsonString + "\"reason\": \"SKU Not Available In Order\"\n"; } } jsonString = jsonString + "}]\n"; jsonString = jsonString + "}\n"; /*json Loop End*/ context.Response.Write(jsonString); } catch (Exception ex) { Login.Profile.ErrorHandling(ex, "putin_scan_serial_and_save", "ProcessRequest"); } finally { } }