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
{ }
}
