public AssignTransferRes PostAssignTransfer(AssignTransferReq ATReq)
{
AssignTransferRes ATR = new AssignTransferRes();
try
{
if (ATReq.UserId == 0)
{
ATR.Status = "Failure";
ATR.Message = "Invalid UserId";
return(ATR);
}
query = "Sp_AssignTransfer";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "FetchAssignTransferDetails");
dbcommand.Parameters.AddWithValue("@UserId", ATReq.UserId);
dbcommand.Parameters.AddWithValue("@TATHID1", ATReq.TATHID);
SqlDataAdapter daGetData = new SqlDataAdapter(dbcommand);
DataSet dsGetData = new DataSet();
daGetData.Fill(dsGetData);
int i = 0;
if (Convert.ToString(dsGetData.Tables[0].Rows[0]["value"]) == "0")
{
query = "Sp_AxWebserviceIntegration";
dbcommand = new SqlCommand(query, conn);
// dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataSet ds = new DataSet();
da.Fill(ds);
// DataSet ds = CommonManger.FillDatasetWithParam("Sp_AxWebserviceIntegration");
AXWebServiceRef1.Iace_FinishedGoodServiceClient obj = new AXWebServiceRef1.Iace_FinishedGoodServiceClient();
obj.ClientCredentials.Windows.ClientCredential.Domain = Convert.ToString(ds.Tables[0].Rows[0]["Domain"]);
obj.ClientCredentials.Windows.ClientCredential.UserName = Convert.ToString(ds.Tables[0].Rows[0]["Username"]);
obj.ClientCredentials.Windows.ClientCredential.Password = Convert.ToString(ds.Tables[0].Rows[0]["Password"]);
AXWebServiceRef1.CallContext Cct = new AXWebServiceRef1.CallContext();
Cct.Company = Convert.ToString(ds.Tables[0].Rows[0]["Company"]);
Cct.Language = Convert.ToString(ds.Tables[0].Rows[0]["Language"]);
if (ATReq.IsTj == 1)
{
obj.PostTransferJournal(Cct, Convert.ToString(dsGetData.Tables[0].Rows[i]["TransferID"]));
for (i = 0; i < dsGetData.Tables[0].Rows.Count; i++)
{
string value = obj.InsertHistoryHeaderData(Cct, dsGetData.Tables[0].Rows[i]["StillageID"].ToString(), Convert.ToString(dsGetData.Tables[0].Rows[i]["SiteID"]), Convert.ToString(dsGetData.Tables[0].Rows[i]["WorkOrderNo"]), Convert.ToString(dsGetData.Tables[0].Rows[i]["ItemId"]), Convert.ToDecimal(dsGetData.Tables[0].Rows[i]["WorkOrderQty"]));
obj.InsertHistoryDetailData(Cct, dsGetData.Tables[0].Rows[i]["StillageID"].ToString(), "", "Transfered with TJ", "Transfered with TJ", Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", "", "", "No", 0, "", 0, 0, Convert.ToDecimal(dsGetData.Tables[0].Rows[i]["StillageQty"]), Convert.ToString(dsGetData.Tables[0].Rows[i]["UserName"]), "QC Release", 0, "", Convert.ToString(dsGetData.Tables[0].Rows[i]["FromWareHouseId"]), Convert.ToString(dsGetData.Tables[0].Rows[i]["ToWareHouseId"]), Convert.ToString(dsGetData.Tables[0].Rows[i]["ToWareHouseId"]), 0);
//i++;
}
}
else
{
obj.TransferOrderPickingList(Cct, Convert.ToString(dsGetData.Tables[0].Rows[i]["TransferID"]));
obj.shipTransferOrder(Cct, Convert.ToString(dsGetData.Tables[0].Rows[i]["TransferID"]));
for (i = 0; i < dsGetData.Tables[0].Rows.Count; i++)
{
string value = obj.InsertHistoryHeaderData(Cct, dsGetData.Tables[0].Rows[i]["StillageID"].ToString(), Convert.ToString(dsGetData.Tables[0].Rows[i]["SiteID"]), Convert.ToString(dsGetData.Tables[0].Rows[i]["WorkOrderNo"]), Convert.ToString(dsGetData.Tables[0].Rows[i]["ItemId"]), Convert.ToDecimal(dsGetData.Tables[0].Rows[i]["WorkOrderQty"]));
obj.InsertHistoryDetailData(Cct, dsGetData.Tables[0].Rows[i]["StillageID"].ToString(), "", "Transfered with TO", "Transfered with TO", Convert.ToString(dsGetData.Tables[0].Rows[i]["StillageLocation"]), "", "", "", "", "", "", "Yes", 0, "", 0, 0, Convert.ToDecimal(dsGetData.Tables[0].Rows[i]["StillageQty"]), Convert.ToString(dsGetData.Tables[0].Rows[i]["UserName"]), "QC Release", 0, "", Convert.ToString(dsGetData.Tables[0].Rows[i]["FromWareHouseId"]), Convert.ToString(dsGetData.Tables[0].Rows[i]["ToWareHouseId"]), Convert.ToString(dsGetData.Tables[0].Rows[i]["ToWareHouseId"]), 0);
// i++;
query = "Sp_AssignTransfer";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "UpdateAssignedSticker");
dbcommand.Parameters.AddWithValue("@UserId", ATReq.UserId);
dbcommand.Parameters.AddWithValue("@TATHID1", ATReq.TATHID);
dbcommand.Parameters.AddWithValue("@IsTj", ATReq.IsTj);
dbcommand.Parameters.AddWithValue("@StickerId", dsGetData.Tables[0].Rows[i]["StillageID"].ToString());
SqlDataAdapter daGetData1 = new SqlDataAdapter(dbcommand);
DataSet dsGetData1 = new DataSet();
daGetData1.Fill(dsGetData1);
if (dsGetData1.Tables[0].Rows[0]["value"].ToString() == "2")
{
ATR.Status = "Success";
ATR.Message = "Transfered successfully with TO Process.";
}
}
}
if (ATReq.IsTj == 1)
{
query = "Sp_AssignTransfer";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "UpdateAssignedSticker");
dbcommand.Parameters.AddWithValue("@UserId", ATReq.UserId);
dbcommand.Parameters.AddWithValue("@TATHID1", ATReq.TATHID);
dbcommand.Parameters.AddWithValue("@IsTj", ATReq.IsTj);
dbcommand.Parameters.AddWithValue("@StickerId", "");
SqlDataAdapter daGetData1 = new SqlDataAdapter(dbcommand);
DataSet dsGetData1 = new DataSet();
daGetData1.Fill(dsGetData1);
if (dsGetData1.Tables[0].Rows[0]["value"].ToString() == "1")
{
ATR.Status = "Success";
ATR.Message = "Transfered successfully with TJ Process.";
}
}
}
}
catch (Exception Ex)
{
ATR.Status = "Failure";
ATR.Message = Ex.Message;
}
return(ATR);
}
