public AssignTransferRes AssignTransferProcess(AssignTransferReq ATReq)
{
AssignTransferRes ATRes = new AssignTransferRes();
try
{
if (ATReq.UserId == 0)
{
ATRes.Status = "Failure";
ATRes.Message = "Invalid UserId";
}
var json = JsonConvert.SerializeObject(ATReq.StillageList);
if (ATReq.IsTj == 0)
{
query = "Sp_AssignTransfer";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "SaveTempData");
dbcommand.Parameters.AddWithValue("@IsTj", ATReq.IsTj);
dbcommand.Parameters.AddWithValue("@SiteId", ATReq.SiteId);
dbcommand.Parameters.AddWithValue("@WareHouseId", ATReq.WareHouseId);
dbcommand.Parameters.AddWithValue("@FLT", ATReq.FLT);
dbcommand.Parameters.AddWithValue("@UserId", ATReq.UserId);
dbcommand.Parameters.AddWithValue("@FromWareHouseId", ATReq.FromWareHouseId);
dbcommand.Parameters.AddWithValue("@json", json);
dbcommand.CommandTimeout = 0;
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataSet dt = new DataSet();
da.Fill(dt);
query = "Sp_AxWebserviceIntegration";
dbcommand = new SqlCommand(query, conn);
// dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
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"]);
var Value = obj.InsertTransferHeader(Cct, ATReq.StillageList[0].StillageID, ATReq.WareHouseId, Convert.ToString(dt.Tables[0].Rows[0]["UserName"]), Convert.ToString(dt.Tables[0].Rows[0]["ActivityId"]));
int count = 0;
// foreach (var Data in ATReq.StillageList)
for (var i = 0; i < ATReq.StillageList.Count; i++)
{
//string a = ATReq.StillageList[i].StillageID;
obj.InsertTransferOrderLines(Cct, Value, ATReq.StillageList[i].StillageID);
if (count == 0)
{
query = "Sp_AssignTransfer";
dbcommand = new SqlCommand(query, conn);
//dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "SaveDataApi");
dbcommand.Parameters.AddWithValue("@IsTj", ATReq.IsTj);
dbcommand.Parameters.AddWithValue("@SiteId", ATReq.SiteId);
dbcommand.Parameters.AddWithValue("@WareHouseId", ATReq.WareHouseId);
dbcommand.Parameters.AddWithValue("@FLT", ATReq.FLT);
dbcommand.Parameters.AddWithValue("@UserId", ATReq.UserId);
dbcommand.Parameters.AddWithValue("@FromWareHouseId", ATReq.FromWareHouseId);
dbcommand.Parameters.AddWithValue("@json", json);
dbcommand.Parameters.AddWithValue("@ActivityId", dt.Tables[0].Rows[0]["ActivityId"]);
dbcommand.Parameters.AddWithValue("@LocationId", ATReq.LocationId);
dbcommand.CommandTimeout = 0;
SqlDataAdapter da5 = new SqlDataAdapter(dbcommand);
DataSet dt5 = new DataSet();
da5.Fill(dt5);
}
query = "Sp_AssignTransfer";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "FetchAssignTransferData");
dbcommand.Parameters.AddWithValue("@StickerId", ATReq.StillageList[i].StillageID);
dbcommand.Parameters.AddWithValue("@UserId", ATReq.UserId);
dbcommand.Parameters.AddWithValue("@journalId", Value);
SqlDataAdapter daGetData = new SqlDataAdapter(dbcommand);
DataSet dsGetData = new DataSet();
daGetData.Fill(dsGetData);
da = new SqlDataAdapter(dbcommand);
//var Hold = "";
//if (dsGetData.Tables[0].Rows[0]["isHold"].ToString() == "True")
//{
// Hold = "Qc Hold";
//}
//else
//{
// Hold = "Qc Release";
//}
obj.InsertHistoryHeaderData(Cct, ATReq.StillageList[i].StillageID, Convert.ToString(dsGetData.Tables[0].Rows[0]["SiteID"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["ItemId"]), Convert.ToDecimal(dsGetData.Tables[0].Rows[0]["WorkOrderQty"]));
obj.InsertHistoryDetailData(Cct, ATReq.StillageList[i].StillageID, "", "Planned for Transfer Order", "Planned for Transfer Order", Convert.ToString(dsGetData.Tables[0].Rows[0]["StillageLocation"]), "", Convert.ToString(ATReq.FLT), "", "", "", "", "Yes", 0, "", 0, 0, Convert.ToDecimal(dsGetData.Tables[0].Rows[0]["StillageQty"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["UserName"]), "Reserved", 0, "", Convert.ToString(dsGetData.Tables[0].Rows[0]["FromWareHouseId"]), ATReq.WareHouseId, Convert.ToString(dsGetData.Tables[0].Rows[0]["FromWareHouseId"]), 0);
count++;
}
query = "Sp_AssignTransfer";
dbcommand = new SqlCommand(query, conn);
//dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "UpdateIsAssignTransfer");
dbcommand.Parameters.AddWithValue("@json", json);
dbcommand.CommandTimeout = 0;
da = new SqlDataAdapter(dbcommand);
dt = new DataSet();
da.Fill(dt);
ATRes.Status = "Success";
ATRes.Message = "Transfer assigned successfully";
}
else
{
query = "Sp_AssignTransfer";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "SaveTempData");
dbcommand.Parameters.AddWithValue("@IsTj", ATReq.IsTj);
dbcommand.Parameters.AddWithValue("@SiteId", ATReq.SiteId);
dbcommand.Parameters.AddWithValue("@WareHouseId", ATReq.WareHouseId);
dbcommand.Parameters.AddWithValue("@FLT", ATReq.FLT);
dbcommand.Parameters.AddWithValue("@UserId", ATReq.UserId);
dbcommand.Parameters.AddWithValue("@FromWareHouseId", ATReq.FromWareHouseId);
dbcommand.Parameters.AddWithValue("@json", json);
dbcommand.CommandTimeout = 0;
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataSet dt = new DataSet();
da.Fill(dt);
query = "Sp_AxWebserviceIntegration";
dbcommand = new SqlCommand(query, conn);
// dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
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"]);
string journalId = obj.CreateTransferJournalHeader(Cct, Convert.ToString(dt.Tables[0].Rows[0]["ActivityId"]), Convert.ToString(dt.Tables[0].Rows[0]["UserName"]), ATReq.StillageList[0].StillageID);
int count = 0;
for (var i = 0; i < ATReq.StillageList.Count; i++)
{
//string a = ATReq.StillageList[i].StillageID;
if (count == 0)
{
query = "Sp_AssignTransfer";
dbcommand = new SqlCommand(query, conn);
//dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "SaveDataApi");
dbcommand.Parameters.AddWithValue("@IsTj", ATReq.IsTj);
dbcommand.Parameters.AddWithValue("@SiteId", ATReq.SiteId);
dbcommand.Parameters.AddWithValue("@WareHouseId", ATReq.WareHouseId);
dbcommand.Parameters.AddWithValue("@FLT", ATReq.FLT);
dbcommand.Parameters.AddWithValue("@UserId", ATReq.UserId);
dbcommand.Parameters.AddWithValue("@FromWareHouseId", ATReq.FromWareHouseId);
dbcommand.Parameters.AddWithValue("@json", json);
dbcommand.Parameters.AddWithValue("@ActivityId", dt.Tables[0].Rows[0]["ActivityId"]);
dbcommand.Parameters.AddWithValue("@LocationId", ATReq.LocationId);
dbcommand.CommandTimeout = 0;
dbcommand.CommandTimeout = 0;
SqlDataAdapter da2 = new SqlDataAdapter(dbcommand);
DataSet dt2 = new DataSet();
da2.Fill(dt2);
}
query = "Sp_AssignTransfer";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "FetchAssignTransferData");
dbcommand.Parameters.AddWithValue("@StickerId", ATReq.StillageList[i].StillageID);
dbcommand.Parameters.AddWithValue("@UserId", ATReq.UserId);
dbcommand.Parameters.AddWithValue("@journalId", journalId);
SqlDataAdapter daGetData = new SqlDataAdapter(dbcommand);
DataSet dsGetData = new DataSet();
daGetData.Fill(dsGetData);
da = new SqlDataAdapter(dbcommand);
//var Hold = "";
//if (dsGetData.Tables[0].Rows[0]["isHold"].ToString() == "True")
//{
// Hold = "Qc Hold";
//}
//else
//{
// Hold = "Qc Release";
//}
string result1 = obj.CreateTransferJournalLines(Cct, journalId, Convert.ToString(dsGetData.Tables[0].Rows[0]["ItemId"]), Convert.ToDecimal(dsGetData.Tables[0].Rows[0]["StillageQty"]), Convert.ToDateTime(DateTime.Now), Convert.ToString(dsGetData.Tables[0].Rows[0]["fromSiteID"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["FromWareHouseId"]), ATReq.SiteId, ATReq.WareHouseId, ATReq.StillageList[i].StillageID);
obj.InsertHistoryHeaderData(Cct, ATReq.StillageList[i].StillageID, Convert.ToString(dsGetData.Tables[0].Rows[0]["SiteID"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["ItemId"]), Convert.ToDecimal(dsGetData.Tables[0].Rows[0]["WorkOrderQty"]));
obj.InsertHistoryDetailData(Cct, ATReq.StillageList[i].StillageID, "", "Planned for Transfer Journal", "Planned for Transfer Journal", Convert.ToString(dsGetData.Tables[0].Rows[0]["StillageLocation"]), "", Convert.ToString(ATReq.FLT), "", "", "", "", "Yes", 0, "", 0, 0, Convert.ToDecimal(dsGetData.Tables[0].Rows[0]["StillageQty"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["UserName"]), "Reserved", 0, "", Convert.ToString(dsGetData.Tables[0].Rows[0]["FromWareHouseId"]), ATReq.WareHouseId, Convert.ToString(dsGetData.Tables[0].Rows[0]["FromWareHouseId"]), 0);
count++;
}
query = "Sp_AssignTransfer";
dbcommand = new SqlCommand(query, conn);
//dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "UpdateIsAssignTransfer");
dbcommand.Parameters.AddWithValue("@json", json);
dbcommand.CommandTimeout = 0;
da = new SqlDataAdapter(dbcommand);
dt = new DataSet();
da.Fill(dt);
ATRes.Status = "Success";
ATRes.Message = "Transfer assigned successfully";
}
}
catch (Exception Ex)
{
ATRes.Status = "Failure";
ATRes.Message = Ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(ATRes);
}
