public WorkOrderStartEndRES WorkOrderFinancialEnd(WorkOrder_Start_EndREQ WOSE)
{
WorkOrderStartEndRES SM = new WorkOrderStartEndRES();
// string date = DateTime.Now.ToString("dd/MM/yyyy");
Random rand = new Random();
string RandomNumer = rand.Next(11111, 99999).ToString();
try
{
if (WOSE.UserId == "" || WOSE.UserId == null)
{
SM.Status = "Failure";
SM.Message = "Invalid UserId";
return(SM);
}
if (WOSE.WorkOrderNo == "" || WOSE.WorkOrderNo == null)
{
SM.Status = "Failure";
SM.Message = "Invalid WorkOrderNo";
return(SM);
}
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"]);
//string value = obj.EndWorkOrder(Cct, WOSE.WorkOrderNo);
string value = obj.ReportAsFinished(Cct, WOSE.WorkOrderNo, false, false, "A", WOSE.WorkOrderNo, "HHD", true, true, true);
query = "Sp_WorkOrderWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "WorkOrderFinancialEnd");
dbcommand.Parameters.AddWithValue("@WorkOrderNo", WOSE.WorkOrderNo);
dbcommand.Parameters.AddWithValue("@UserId", WOSE.UserId);
dbcommand.CommandTimeout = 0;
da = new SqlDataAdapter(dbcommand);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0]["value"].ToString() == "1")
{
SM.Status = "Success";
SM.Message = "Workorder end job successfully";
}
else
{
SM.Status = "Failure";
SM.Message = "Invalid WorkOrder No";
}
}
catch (Exception Ex)
{
SM.Status = "Failure";
SM.Message = Ex.Message;
}
//finally
//{
// //dbcommand.Connection.Close();
//}
return(SM);
}
public WorkOrderStartEndRES WorkOrderStartService(WorkOrder_Start_EndREQ WOSE)
{
WorkOrderStartEndRES SM = new WorkOrderStartEndRES();
try
{
if (WOSE.UserId == "" || WOSE.UserId == null)
{
SM.Status = "Failure";
SM.Message = "Invalid UserId";
return(SM);
}
if (WOSE.WorkOrderNo == "" || WOSE.WorkOrderNo == null)
{
SM.Status = "Failure";
SM.Message = "Invalid WorkOrderNo";
return(SM);
}
bool AutoPicked = true;
bool AutoRoute = true;
if (WOSE.AutoPick == "1")
{
AutoPicked = true;
}
else
{
AutoPicked = false;
}
if (WOSE.AutoRoute == "1")
{
AutoRoute = true;
}
else
{
AutoRoute = false;
}
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"]);
string value = obj.StartWorkOrder(Cct, WOSE.WorkOrderNo, AutoPicked, AutoRoute, Convert.ToDecimal(WOSE.StartQty));
query = "Sp_WorkOrderWebApi";
dbcommand = new SqlCommand(query, conn);
//dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "WorkOrder_Start");
dbcommand.Parameters.AddWithValue("@WorkOrderNo", WOSE.WorkOrderNo);
dbcommand.Parameters.AddWithValue("@StartQty", WOSE.StartQty);
dbcommand.Parameters.AddWithValue("@UserId", WOSE.UserId);
dbcommand.CommandTimeout = 0;
da = new SqlDataAdapter(dbcommand);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0]["value"].ToString() == "1")
{
SM.Status = "Success";
SM.Message = "WorkOrder Started";
}
else
{
SM.Status = "Failure";
SM.Message = "Invalid WorkOrder No";
}
}
catch (Exception Ex)
{
SM.Status = "Failure";
SM.Message = Ex.Message;
}
//finally
//{
// //dbcommand.Connection.Close();
//}
return(SM);
}
public STDetailResponce STDetailUpdate(PickAndLoadReq PAL)
{
STDetailResponce SM = new STDetailResponce();
try
{
if (PAL.StickerNo == "" || PAL.StickerNo == null)
{
SM.Status = "Failure";
SM.Message = "Enter StickerNo";
return(SM);
}
if (PAL.UserId == "" || PAL.UserId == null)
{
SM.Status = "Failure";
SM.Message = "Invalid UserId";
return(SM);
}
if (PAL.LoadingId == "" || PAL.LoadingId == null)
{
SM.Status = "Failure";
SM.Message = "Invalid LoadingId";
return(SM);
}
query = "Sp_PickAndLoad";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "FetchDataPick&Load");
dbcommand.Parameters.AddWithValue("@StillageID", PAL.StickerNo);
dbcommand.Parameters.AddWithValue("@UserId", PAL.UserId);
dbcommand.Parameters.AddWithValue("@ActivityID", 4);
dbcommand.Parameters.AddWithValue("@Reason", PAL.Reason);
dbcommand.Parameters.AddWithValue("@LoadingId", PAL.LoadingId);
SqlDataAdapter daGetData = new SqlDataAdapter(dbcommand);
DataSet dsGetData = new DataSet();
daGetData.Fill(dsGetData);
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
if (dsGetData.Tables[0].Rows[0]["value"].ToString() != "2")
{
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 value = obj.InsertHistoryHeaderData(Cct, PAL.StickerNo, Convert.ToString(dsGetData.Tables[0].Rows[0]["SiteID"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["SiteID"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["ItemId"]), Convert.ToDecimal(dsGetData.Tables[0].Rows[0]["WorkOrderQty"]));
// obj.InsertHistoryDetailData(Cct, PAL.StickerNo, Convert.ToString(dsGetData.Tables[1].Rows[0]["PlanningId"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonDes"]), "No", Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["MergeQty"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["FromMerge"]), PAL.LoadQuantity, 0, Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["StillageQty"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]), "Reserved", 0, "","","", Convert.ToString(dsGetData.Tables[1].Rows[0]["WareHouseID"]),0);
obj.InsertHistoryDetailData(Cct, PAL.StickerNo, Convert.ToString(dsGetData.Tables[1].Rows[0]["PlanningId"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonDes"]), "No", Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["MergeQty"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["FromMerge"]), PAL.LoadQuantity, 0, Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["StillageQty"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]), "Reserved", 0, "", "", "", Convert.ToString(dsGetData.Tables[1].Rows[0]["WareHouseID"]));
}
else
{
SM.Status = "Failure";
SM.Message = "This Stillage Does Not Exist";
return(SM);
}
query = "Sp_AssignWebApi";
dbcommand = new SqlCommand(query, conn);
// dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "UpdatePickAndLoading");
dbcommand.Parameters.AddWithValue("@StickerId", PAL.StickerNo);
dbcommand.Parameters.AddWithValue("@Reason", PAL.Reason);
dbcommand.Parameters.AddWithValue("@LoadingId", PAL.LoadingId);
dbcommand.Parameters.AddWithValue("@UserId", PAL.UserId);
dbcommand.Parameters.AddWithValue("@ItemId", PAL.ItemId);
dbcommand.Parameters.AddWithValue("@LoadedQuantity", PAL.LoadQuantity);
dbcommand.Parameters.AddWithValue("@Iscompleted", PAL.Iscompleted);
dbcommand.CommandTimeout = 0;
da = new SqlDataAdapter(dbcommand);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0]["value"].ToString() == "1")
{
SM.Status = "Success";
SM.Message = "Loaded Successfully";
}
else if (dt.Rows[0]["value"].ToString() == "2")
{
SM.Status = "Failure";
SM.Message = "Stillage already loaded.!";
}
else
{
SM.Status = "Failure";
SM.Message = "Loading Failure";
}
}
catch (Exception Ex)
{
SM.Status = "Failure";
SM.Message = Ex.Message;
}
//finally
//{
// //dbcommand.Connection.Close();
//}
return(SM);
}
public CancelLoadingkResponse CancelLoadingProcess(CancelLoading CL)
{
CancelLoadingkResponse SM = new CancelLoadingkResponse();
try
{
if (CL.UserId == "" || CL.UserId == null)
{
SM.Status = "Failure";
SM.Message = "Invalid UserId";
return(SM);
}
if (CL.LPID == "" || CL.LPID == null)
{
SM.Status = "Failure";
SM.Message = "Invalid LoadingId";
return(SM);
}
query = "Sp_LadingPlanWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "FetchStillagesId");
dbcommand.Parameters.AddWithValue("@LPID", CL.LPID);
dbcommand.Parameters.AddWithValue("@UserId", CL.UserId);
SqlDataAdapter daGetData1 = new SqlDataAdapter(dbcommand);
DataSet dsGetData1 = new DataSet();
daGetData1.Fill(dsGetData1);
foreach (DataRow row in dsGetData1.Tables[0].Rows)
{
query = "Sp_LadingPlanWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "FetchStillagesData");
dbcommand.Parameters.AddWithValue("@StillageID", row["StickerID"].ToString());
dbcommand.Parameters.AddWithValue("@UserId", CL.UserId);
dbcommand.Parameters.AddWithValue("@LoadingId", CL.LPID);
SqlDataAdapter daGetData = new SqlDataAdapter(dbcommand);
DataSet dsGetData = new DataSet();
daGetData.Fill(dsGetData);
query = "Sp_AxWebserviceIntegration";
dbcommand = new SqlCommand(query, conn);
// dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
SqlDataAdapter da1 = new SqlDataAdapter(dbcommand);
DataSet ds = new DataSet();
da1.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 value = obj.InsertHistoryHeaderData(Cct, Convert.ToString(dsGetData.Tables[1].Rows[0]["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, Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageID"]), "", Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", "", "", "No", 0, "", 0, 0, Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["StillageQty"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]),"QC Release",0,"","","", Convert.ToString(dsGetData.Tables[1].Rows[0]["WareHouseID"]),0);
obj.InsertHistoryDetailData(Cct, Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageID"]), "", Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", "", "", "No", 0, "", 0, 0, Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["StillageQty"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]), "QC Release", 0, "", "", "", Convert.ToString(dsGetData.Tables[1].Rows[0]["WareHouseID"]));
}
query = "Sp_LadingPlanWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "CancelLoadingProcess");
dbcommand.Parameters.AddWithValue("@LoadingId", CL.LPID);
dbcommand.Parameters.AddWithValue("@UserId", CL.UserId);
dbcommand.CommandTimeout = 0;
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0]["value"].ToString() == "1")
{
SM.Status = "Success";
SM.Message = "Loading Cancel Successfully";
}
else
{
SM.Status = "Failure";
SM.Message = "Loading Cancel Failure";
}
}
catch (Exception Ex)
{
SM.Status = "Failure";
SM.Message = Ex.Message;
}
//finally
//{
// //dbcommand.Connection.Close();
//}
return(SM);
}
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);
}
public ReceivingResponse UpdateMergeStillage(UpdateMergeResponse UMR)
{
ReceivingResponse SM = new ReceivingResponse();
try
{
if (UMR.StickerNo == "")
{
SM.Status = "Failure";
SM.Message = "Enter Sticker ID";
}
if (UMR.UserId == 0)
{
SM.Status = "Failure";
SM.Message = "Invalid UserId";
}
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);
// 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"]);
query = "Sp_MergeStillage";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "FetchMergeData");
dbcommand.Parameters.AddWithValue("@StickerId", UMR.StickerNo);
dbcommand.Parameters.AddWithValue("@UserId", UMR.UserId);
dbcommand.Parameters.AddWithValue("@ActivityID", "Merge");
SqlDataAdapter daGetData = new SqlDataAdapter(dbcommand);
DataSet dsGetData = new DataSet();
daGetData.Fill(dsGetData);
var output = "";
if (dsGetData.Tables[0].Rows[0]["value"].ToString() != "2")
{
string value = obj.InsertHistoryHeaderData(Cct, UMR.StickerNo, 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"]));
string MergeFrom = "";
decimal MergeQty = 0;
decimal StillageQty = 0;
StillageQty = Convert.ToDecimal(dsGetData.Tables[0].Rows[0]["StillageQty"]);
string s = UMR.MergeStickers;
string[] values = s.Split(',');
var dict = new Dictionary <string, string>();
for (int i = 0; i < values.Length - 1; i++)
{
string[] values1 = values[i].Split(':');
MergeFrom = values1[0];
//values1[i] = values1[i].Trim();
MergeQty = Convert.ToDecimal(values1[1]);
dict.Add(values1[0], values1[1]);
decimal TotalQty = StillageQty + MergeQty;
StillageQty = TotalQty;
query = "Sp_MergeStillage";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "FetchMergeData");
dbcommand.Parameters.AddWithValue("@StickerId", MergeFrom);
dbcommand.Parameters.AddWithValue("@UserId", UMR.UserId);
dbcommand.Parameters.AddWithValue("@ActivityID", "Merge");
SqlDataAdapter daData = new SqlDataAdapter(dbcommand);
DataSet dsData = new DataSet();
daData.Fill(dsData);
var Hold = "";
if (dsGetData.Tables[0].Rows[0]["isHold"].ToString() == "True")
{
Hold = "Qc Hold";
}
else
{
Hold = "Qc Release";
}
decimal ReducedQty = Convert.ToDecimal(dsData.Tables[0].Rows[0]["StillageQty"]) - MergeQty;
if (ReducedQty == 0)
{
query = "[Sp_MasterDataWebApi]";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "GetActivityMaster");
dbcommand.Parameters.AddWithValue("@ActivityID", "Merge & Discarded");
SqlDataAdapter daGetData1 = new SqlDataAdapter(dbcommand);
DataSet dsGetData1 = new DataSet();
daGetData.Fill(dsGetData1);
// obj.InsertHistoryDetailData(Cct, UMR.StickerNo, "", Convert.ToString(dsGetData1.Tables[0].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["StillageLocation"]), "", "", "", "", "", "", "No", MergeQty, MergeFrom, 0, 0, StillageQty, Convert.ToString(dsGetData.Tables[0].Rows[0]["UserName"]), Hold, 0, "","","", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]),0);
obj.InsertHistoryDetailData(Cct, UMR.StickerNo, "", Convert.ToString(dsGetData1.Tables[0].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["StillageLocation"]), "", "", "", "", "", "", "No", MergeQty, MergeFrom, 0, 0, StillageQty, Convert.ToString(dsGetData.Tables[0].Rows[0]["UserName"]), Hold, 0, "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]));
obj.UpdateStillageQty(Cct, UMR.StickerNo, Convert.ToString(dsGetData.Tables[0].Rows[0]["StillageLocation"]), StillageQty);
//obj.InsertHistoryDetailData(Cct, MergeFrom, "", Convert.ToString(dsGetData1.Tables[0].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["ActivityDesc"]), Convert.ToString(dsData.Tables[0].Rows[0]["StillageLocation"]), "", "", "", "", "", "", "No", MergeQty, "", 0, 0, ReducedQty, Convert.ToString(dsData.Tables[0].Rows[0]["UserName"]), Hold, 0, UMR.StickerNo,"","", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]),0);
obj.InsertHistoryDetailData(Cct, MergeFrom, "", Convert.ToString(dsGetData1.Tables[0].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["ActivityDesc"]), Convert.ToString(dsData.Tables[0].Rows[0]["StillageLocation"]), "", "", "", "", "", "", "No", MergeQty, "", 0, 0, ReducedQty, Convert.ToString(dsData.Tables[0].Rows[0]["UserName"]), Hold, 0, UMR.StickerNo, "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]));
obj.UpdateStillageQty(Cct, MergeFrom, Convert.ToString(dsData.Tables[0].Rows[0]["StillageLocation"]), ReducedQty);
}
else
{
//obj.InsertHistoryDetailData(Cct, UMR.StickerNo, "", Convert.ToString(dsGetData.Tables[0].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["StillageLocation"]), "", "", "", "", "", "", "No", MergeQty, MergeFrom, 0, 0, StillageQty, Convert.ToString(dsGetData.Tables[0].Rows[0]["UserName"]), Hold, 0, "","","", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]),0);
obj.InsertHistoryDetailData(Cct, UMR.StickerNo, "", Convert.ToString(dsGetData.Tables[0].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["StillageLocation"]), "", "", "", "", "", "", "No", MergeQty, MergeFrom, 0, 0, StillageQty, Convert.ToString(dsGetData.Tables[0].Rows[0]["UserName"]), Hold, 0, "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]));
obj.UpdateStillageQty(Cct, UMR.StickerNo, Convert.ToString(dsGetData.Tables[0].Rows[0]["StillageLocation"]), StillageQty);
//obj.InsertHistoryDetailData(Cct, MergeFrom, "", Convert.ToString(dsGetData.Tables[0].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["ActivityDesc"]), Convert.ToString(dsData.Tables[0].Rows[0]["StillageLocation"]), "", "", "", "", "", "", "No", MergeQty, "", 0, 0, ReducedQty, Convert.ToString(dsData.Tables[0].Rows[0]["UserName"]), Hold, 0, UMR.StickerNo,"","", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]),0);
obj.InsertHistoryDetailData(Cct, MergeFrom, "", Convert.ToString(dsGetData.Tables[0].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["ActivityDesc"]), Convert.ToString(dsData.Tables[0].Rows[0]["StillageLocation"]), "", "", "", "", "", "", "No", MergeQty, "", 0, 0, ReducedQty, Convert.ToString(dsData.Tables[0].Rows[0]["UserName"]), Hold, 0, UMR.StickerNo, "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]));
obj.UpdateStillageQty(Cct, MergeFrom, Convert.ToString(dsData.Tables[0].Rows[0]["StillageLocation"]), ReducedQty);
}
}
output = Newtonsoft.Json.JsonConvert.SerializeObject(dict);
}
else
{
SM.Status = "Failure";
SM.Message = "This Stillage Does Not Exist";
return(SM);
}
query = "Sp_MergeStillage";
dbcommand = new SqlCommand(query, conn);
//dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "UpdateMergeStillage");
dbcommand.Parameters.AddWithValue("@StickerId", UMR.StickerNo);
dbcommand.Parameters.AddWithValue("@UserId", UMR.UserId);
dbcommand.Parameters.AddWithValue("@MergeStillage", output);
dbcommand.Parameters.AddWithValue("@MergeQuantity", UMR.TotalMergeQty);
dbcommand.CommandTimeout = 0;
da = new SqlDataAdapter(dbcommand);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0]["value"].ToString() == "1")
{
SM.Status = "Success";
SM.Message = "Stillage merged successfully";
}
else
{
SM.Status = "Failure";
SM.Message = "Stillage not merged successfully";
}
}
catch (Exception Ex)
{
SM.Status = "Failure";
SM.Message = Ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(SM);
}
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);
}
public STDetailResponce VariancePosting(STDetailRequest st)
{
STDetailResponce SM = new STDetailResponce();
try
{
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
if (st.StickerNo == "" || st.StickerNo == null)
{
SM.Status = "Failure";
SM.Message = "Enter Sticker Id";
return(SM);
}
if (st.UserId == "" || st.UserId == null)
{
SM.Status = "Failure";
SM.Message = "Invalid UserId";
return(SM);
}
if (st.Quantity == "" || st.Quantity == null)
{
SM.Status = "Failure";
SM.Message = "Please Enter Valid Quantity";
return(SM);
}
query = "Sp_Variance";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "FetchVarianceData");
dbcommand.Parameters.AddWithValue("@StillageID", st.StickerNo);
dbcommand.Parameters.AddWithValue("@UserId", st.UserId);
dbcommand.Parameters.AddWithValue("@Reason", st.Reason);
SqlDataAdapter daGetData = new SqlDataAdapter(dbcommand);
DataSet dsGetData = new DataSet();
daGetData.Fill(dsGetData);
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);
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 QCHold = "";
if (dsGetData.Tables[0].Rows[0]["isHold"].ToString() == "1")
{
QCHold = "Qc Hold";
}
else
{
QCHold = "QC Release";
}
string ActivityName = "";
string ActivityDesc = "";
if (st.Quantity != "0")
{
ActivityName = Convert.ToString(dsGetData.Tables[0].Rows[0]["ActivityName"]);
ActivityDesc = Convert.ToString(dsGetData.Tables[0].Rows[0]["ActivityDesc"]);
}
else
{
ActivityName = "Updated And Discarded";
ActivityDesc = "Updated And Discarded";
}
bool Autoroute = true;
bool Autopick = true;
if (st.AutoPick == 1)
{
Autopick = true;
}
else
{
Autopick = false;
}
if (st.AutoRoute == 1)
{
Autoroute = true;
}
else
{
Autoroute = false;
}
decimal Variance = 0;
//if (dsGetData.Tables[0].Rows[0]["STRP"].ToString() == "1")
//{
// Variance = Convert.ToDecimal(st.Variance) * Convert.ToDecimal((-1));
//}
//else
//{
Variance = Convert.ToDecimal(st.Variance);
//}
if (dsGetData.Tables[1].Rows[0]["Status"].ToString() == "7")
{
SM.Status = "Failure";
SM.Message = "The WO is Ended, please contact Accounts dept. for adjustment";
}
else if (dsGetData.Tables[1].Rows[0]["Status"].ToString() == "5" && dsGetData.Tables[1].Rows[0]["RemainingStatus"].ToString() == "5")
{
SM.Status = "Failure";
SM.Message = "The WO is Ended, please contact Accounts dept. for adjustment";
}
else if (Convert.ToBoolean(dsGetData.Tables[1].Rows[0]["IsCounted"]) != true)
{
obj.UpdateQty(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), Autopick, Autoroute, "A", st.StickerNo, "HHD", Convert.ToDecimal(st.Quantity), Convert.ToDecimal(Variance));
obj.InsertHistoryHeaderData(Cct, st.StickerNo, 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, st.StickerNo, "", ActivityName, ActivityDesc, Convert.ToString(dsGetData.Tables[0].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["ReasonDes"]), "Yes", 0, "", 0, Convert.ToDecimal(st.Quantity), Convert.ToDecimal(st.Quantity), Convert.ToString(dsGetData.Tables[0].Rows[0]["UserName"]), QCHold, 0, "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]), 0);
obj.InsertHistoryDetailData(Cct, st.StickerNo, "", ActivityName, ActivityDesc, Convert.ToString(dsGetData.Tables[0].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["ReasonDes"]), "Yes", 0, "", 0, Convert.ToDecimal(st.Quantity), Convert.ToDecimal(st.Quantity), Convert.ToString(dsGetData.Tables[0].Rows[0]["UserName"]), QCHold, 0, "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]));
//dbcommand.Connection.Close();
query = "Sp_Variance";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "UpdateQty");
dbcommand.Parameters.AddWithValue("@EntQty", st.Quantity);
dbcommand.Parameters.AddWithValue("@StillageId", st.StickerNo);
dbcommand.CommandTimeout = 0;
da = new SqlDataAdapter(dbcommand);
ds = new DataSet();
da.Fill(ds);
SM.Status = "Success";
SM.Message = "Quantity Updated and Variance Posted Successfully..!";
}
else
{
obj.UpdateQty(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), Autopick, Autoroute, "A", st.StickerNo, "HHD", Convert.ToDecimal(Variance), Convert.ToDecimal(Variance));
obj.InsertHistoryHeaderData(Cct, st.StickerNo, 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, st.StickerNo, "", ActivityName, ActivityDesc, Convert.ToString(dsGetData.Tables[0].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["ReasonDes"]), "Yes", 0, "", 0, Convert.ToDecimal(Variance), Convert.ToDecimal(st.Quantity), Convert.ToString(dsGetData.Tables[0].Rows[0]["UserName"]), QCHold, 0, "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]), 0);
obj.InsertHistoryDetailData(Cct, st.StickerNo, "", ActivityName, ActivityDesc, Convert.ToString(dsGetData.Tables[0].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["ReasonDes"]), "Yes", 0, "", 0, Convert.ToDecimal(Variance), Convert.ToDecimal(st.Quantity), Convert.ToString(dsGetData.Tables[0].Rows[0]["UserName"]), QCHold, 0, "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]));
//dbcommand.Connection.Close();
query = "Sp_Variance";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "UpdateQty");
dbcommand.Parameters.AddWithValue("@EntQty", st.Quantity);
dbcommand.Parameters.AddWithValue("@StillageId", st.StickerNo);
dbcommand.CommandTimeout = 0;
da = new SqlDataAdapter(dbcommand);
ds = new DataSet();
da.Fill(ds);
SM.Status = "Success";
SM.Message = "Quantity Updated and Variance Posted Successfully..!";
}
return(SM);
}
catch (Exception Ex)
{
SM.Status = "Failed";
SM.Message = Ex.Message;
return(SM);
}
finally
{
dbcommand.Connection.Close();
}
}
public SubmitProductionJournalResponse SubmitRouteJournalData(SubmitProductionJournalRequest SPJR)
{
SubmitProductionJournalResponse SM = new SubmitProductionJournalResponse();
try
{
if (SPJR.UserId == "" || SPJR.UserId == null)
{
SM.Status = "Failure";
SM.Message = "Invalid UserId";
return(SM);
}
if (SPJR.WorkOrderNo == "" || SPJR.WorkOrderNo == null)
{
SM.Status = "Failure";
SM.Message = "Invalid WorkOrderId";
return(SM);
}
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"]);
// var JournalIdPicking = obj.CreatePickingJournalHeader(Cct, SPJR.WorkOrderNo);
var JournalIdRoute = obj.CreateRouteJournalHeader(Cct, SPJR.WorkOrderNo);
//List<PickingListData> PickingList = new List<PickingListData>();
//PickingList = SPJR.PickingList;
//foreach (var row in PickingList)
//{
// PickingListData A = new PickingListData();
// A.ItemId = row.ItemId;
// A.Quantity = row.Quantity;
// obj.CreatePickingJournalDetails(Cct, JournalIdPicking, A.ItemId, A.Quantity);
//}
List <RoutingCardListData> RoutingCardList = new List <RoutingCardListData>();
RoutingCardList = SPJR.RoutingCardList;
foreach (var row in RoutingCardList)
{
RoutingCardListData A = new RoutingCardListData();
A.OperationName = row.OperationName;
A.Resource = row.Resource;
A.ResourceType = row.ResourceType;
A.Shift = row.Shift;
A.OperationId = row.OperationId;
A.Quantity = row.Quantity;
A.Hours = row.Hours;
A.Priority = row.Priority;
obj.CreateRouteJournalDetails(Cct, JournalIdRoute, A.OperationId, A.Priority, A.Quantity, A.Hours, A.Shift);
}
obj.PostRouteJournal(Cct, JournalIdRoute);
SM.Status = "Success";
SM.Message = "Route Journal Successfully ";
//if (ds.Rows[0]["value"].ToString() == "1")
//{
// SM.Status = "Success";
// SM.Message = "SubmitProductionJournalProcess Successfully";
//}
//else
//{
// SM.Status = "Failure";
// SM.Message = "SubmitProductionJournalProcess Failure";
//}
}
catch (Exception Ex)
{
SM.Status = "Failure";
SM.Message = Ex.Message;
}
//finally
//{
// //dbcommand.Connection.Close();
//}
return(SM);
}
public StickerMaster RejectedStillageDetail(RejectedStillageReq RSR)
{
StickerMaster SM = new StickerMaster();
try
{
if (RSR.StickerNo == "")
{
SM.Status = "Failure";
SM.Message = "Enter Sticker ID";
}
if (RSR.UserId == 0)
{
SM.Status = "Failure";
SM.Message = "Invalid UserId";
}
Decimal StillageQtyPcs = 0;
query = "Sp_RejectStillageWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "FetchDataRejectST");
dbcommand.Parameters.AddWithValue("@StillageID", RSR.StickerNo);
dbcommand.Parameters.AddWithValue("@UserId", RSR.UserId);
dbcommand.Parameters.AddWithValue("@ActivityID", "Reject");
dbcommand.Parameters.AddWithValue("@Reason", RSR.Reason);
SqlDataAdapter daGetData = new SqlDataAdapter(dbcommand);
DataSet dsGetData = new DataSet();
daGetData.Fill(dsGetData);
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
var Hold = "";
if (dsGetData.Tables[0].Rows[0]["isHold"].ToString() == "True")
{
Hold = "Qc Hold";
}
else
{
Hold = "Qc Release";
}
decimal StillageQty = 0;
if (dsGetData.Tables[0].Rows[0]["value"].ToString() != "2")
{
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"]);
if (Convert.ToString(dsGetData.Tables[1].Rows[0]["WOStatus"]) == "7")
{
if (RSR.IsKg == 1)
{
StillageQty = Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["StillageQty"]) - Math.Round(RSR.Quantity / Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["Factor"]));
}
else
{
StillageQty = Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["StillageQty"]) - RSR.Quantity;
}
if (StillageQty == 0)
{
query = "[Sp_MasterDataWebApi]";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "GetActivityMaster");
dbcommand.Parameters.AddWithValue("@ActivityID", "Reject & Discarded");
SqlDataAdapter daGetData1 = new SqlDataAdapter(dbcommand);
DataSet dsGetData1 = new DataSet();
daGetData.Fill(dsGetData1);
string JournalID = "";
if (RSR.IsKg == 1)
{
obj.UpdateQty(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), false, false, Convert.ToString(RSR.Shift), RSR.StickerNo, "HHD", StillageQty, Convert.ToDecimal(-1 * RSR.Quantity));
//JournalID = obj.QCRejectHeader(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), RSR.StickerNo, "Process");
//obj.QCRejectLines(Cct, JournalID, "Startup", Convert.ToDecimal(RSR.Quantity), Convert.ToString(RSR.Reason), Convert.ToString(RSR.Shift), Convert.ToDateTime(DateTime.Now.ToString()));
////obj.QCRejectFGLine(Cct, JournalID);
//obj.PostQCReject(Cct, JournalID);
}
else
{
obj.UpdateQty(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), false, false, Convert.ToString(RSR.Shift), RSR.StickerNo, "HHD", StillageQty, Convert.ToDecimal(-1 * RSR.Quantity));
//JournalID = obj.QCRejectHeader(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), RSR.StickerNo, "Process");
//obj.QCRejectLines(Cct, JournalID, "Process", Convert.ToDecimal(RSR.Quantity), Convert.ToString(RSR.Reason), Convert.ToString(RSR.Shift), Convert.ToDateTime(DateTime.Now.ToString()));
////obj.QCRejectFGLine(Cct, JournalID);
//obj.PostQCReject(Cct, JournalID);
}
//obj.UpdateStillageQty(Cct, RSR.StickerNo, Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), StillageQty);
string value = obj.InsertHistoryHeaderData(Cct, RSR.StickerNo, 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, RSR.StickerNo, "", Convert.ToString(dsGetData1.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData1.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonDes"]), "Yes", 0, "", 0, 0, StillageQty, Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]), Hold, RSR.Quantity, "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]), 0);
}
else
{
string JournalID = "";
if (RSR.IsKg == 1)
{
obj.UpdateQty(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), false, false, Convert.ToString(RSR.Shift), RSR.StickerNo, "HHD", StillageQty, Convert.ToDecimal(-1 * RSR.Quantity));
//JournalID = obj.QCRejectHeader(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), RSR.StickerNo, "Process");
//obj.QCRejectLines(Cct, JournalID, "Startup", Convert.ToDecimal(RSR.Quantity), Convert.ToString(RSR.Reason), Convert.ToString(RSR.Shift), Convert.ToDateTime(DateTime.Now.ToString()));
////obj.QCRejectFGLine(Cct, JournalID);
//obj.PostQCReject(Cct, JournalID);
}
else
{
obj.UpdateQty(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), false, false, Convert.ToString(RSR.Shift), RSR.StickerNo, "HHD", StillageQty, Convert.ToDecimal(-1 * RSR.Quantity));
//JournalID = obj.QCRejectHeader(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), RSR.StickerNo, "Process");
//obj.QCRejectLines(Cct, JournalID, "Process", Convert.ToDecimal(RSR.Quantity), Convert.ToString(RSR.Reason), Convert.ToString(RSR.Shift), Convert.ToDateTime(DateTime.Now.ToString()));
////obj.QCRejectFGLine(Cct, JournalID);
//obj.PostQCReject(Cct, JournalID);
}
string value = obj.InsertHistoryHeaderData(Cct, RSR.StickerNo, 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, RSR.StickerNo, "", Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonDes"]), "Yes", 0, "", 0, 0, StillageQty, Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]), Hold, RSR.Quantity, "", "", "", Convert.ToString(dsGetData.Tables[1].Rows[0]["WareHouseID"]), 0);
}
query = "Sp_RejectStillageWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "SingleRejectStillage");
dbcommand.Parameters.AddWithValue("@StickerId", RSR.StickerNo);
dbcommand.Parameters.AddWithValue("@RejectedQty", StillageQty);
dbcommand.Parameters.AddWithValue("@Reason", RSR.Reason);
dbcommand.Parameters.AddWithValue("@Shift", RSR.Shift);
dbcommand.Parameters.AddWithValue("@UserId", RSR.UserId);
//dbcommand.Parameters.AddWithValue("@ActivityID", RSR.ActivityID);
SqlDataAdapter daGetData0 = new SqlDataAdapter(dbcommand);
DataSet dsGetData0 = new DataSet();
daGetData0.Fill(dsGetData0);
da = new SqlDataAdapter(dbcommand);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0]["value"].ToString() == "1")
{
SM.Status = "Success";
SM.Message = "Stillage Reject successfully";
}
else
{
SM.Status = "Failure";
SM.Message = "Stillage Not Reject successful";
}
}
else
{
if (RSR.IsKg == 1)
{
StillageQty = Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["StillageQty"]) - Math.Round(RSR.Quantity / Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["Factor"]));
StillageQtyPcs = Math.Round(RSR.Quantity / Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["Factor"]));
}
else
{
StillageQty = Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["StillageQty"]) - RSR.Quantity;
}
if (Convert.ToBoolean(dsGetData.Tables[1].Rows[0]["IsCounted"]) == false)
{
if (StillageQty == 0)
{
query = "[Sp_MasterDataWebApi]";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "GetActivityMaster");
dbcommand.Parameters.AddWithValue("@ActivityID", "Reject & Discarded");
SqlDataAdapter daGetData1 = new SqlDataAdapter(dbcommand);
DataSet dsGetData1 = new DataSet();
daGetData.Fill(dsGetData1);
string JournalID = "";
if (RSR.IsKg == 1)
{
//obj.ProcessRejectionRAF(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), false, false, Convert.ToString(RSR.Shift), RSR.StickerNo, "HHD", false, false, StillageQtyPcs);
JournalID = obj.QCRejectHeader(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), RSR.StickerNo, "Web");
obj.QCRejectLines(Cct, JournalID, "Process", StillageQtyPcs, Convert.ToString(RSR.Reason), Convert.ToString(RSR.Shift), Convert.ToDateTime(DateTime.Now.ToString()), RSR.Quantity);
obj.QCRejectFGLine(Cct, JournalID);
obj.PostQCReject(Cct, JournalID);
string value = obj.InsertHistoryHeaderData(Cct, RSR.StickerNo, 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, RSR.StickerNo, "", Convert.ToString(dsGetData1.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData1.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonDes"]), "No", 0, "", 0, 0, StillageQty, Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]), Hold, StillageQtyPcs, "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]), 0);
}
else
{
// obj.ProcessRejectionRAF(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), false, false, Convert.ToString(RSR.Shift), RSR.StickerNo, "HHD", false, false, RSR.Quantity);
JournalID = obj.QCRejectHeader(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), RSR.StickerNo, "Process");
obj.QCRejectLines(Cct, JournalID, "Process", Convert.ToDecimal(RSR.Quantity), Convert.ToString(RSR.Reason), Convert.ToString(RSR.Shift), Convert.ToDateTime(DateTime.Now.ToString()), RSR.Quantity);
obj.QCRejectFGLine(Cct, JournalID);
obj.PostQCReject(Cct, JournalID);
string value = obj.InsertHistoryHeaderData(Cct, RSR.StickerNo, 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, RSR.StickerNo, "", Convert.ToString(dsGetData1.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData1.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonDes"]), "No", 0, "", 0, 0, StillageQty, Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]), Hold, RSR.Quantity, "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]), 0);
}
//obj.UpdateStillageQty(Cct, RSR.StickerNo, Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), StillageQty);
}
else
{
string JournalID = "";
if (RSR.IsKg == 1)
{
// obj.ProcessRejectionRAF(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), false, false, Convert.ToString(RSR.Shift), RSR.StickerNo, "HHD", false, false, StillageQtyPcs);
JournalID = obj.QCRejectHeader(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), RSR.StickerNo, "Web");
obj.QCRejectLines(Cct, JournalID, "Process", StillageQtyPcs, Convert.ToString(RSR.Reason), Convert.ToString(RSR.Shift), Convert.ToDateTime(DateTime.Now.ToString()), RSR.Quantity);
obj.QCRejectFGLine(Cct, JournalID);
obj.PostQCReject(Cct, JournalID);
string value = obj.InsertHistoryHeaderData(Cct, RSR.StickerNo, 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, RSR.StickerNo, "", Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonDes"]), "No", 0, "", 0, 0, StillageQty, Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]), Hold, StillageQtyPcs, "", "", "", Convert.ToString(dsGetData.Tables[1].Rows[0]["WareHouseID"]), 0);
}
else
{
//obj.ProcessRejectionRAF(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), false, false, Convert.ToString(RSR.Shift), RSR.StickerNo, "HHD", false, false, RSR.Quantity);
JournalID = obj.QCRejectHeader(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), RSR.StickerNo, "Process");
obj.QCRejectLines(Cct, JournalID, "Process", Convert.ToDecimal(RSR.Quantity), Convert.ToString(RSR.Reason), Convert.ToString(RSR.Shift), Convert.ToDateTime(DateTime.Now.ToString()), RSR.Quantity);
obj.QCRejectFGLine(Cct, JournalID);
obj.PostQCReject(Cct, JournalID);
string value = obj.InsertHistoryHeaderData(Cct, RSR.StickerNo, 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, RSR.StickerNo, "", Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonDes"]), "No", 0, "", 0, 0, StillageQty, Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]), Hold, RSR.Quantity, "", "", "", Convert.ToString(dsGetData.Tables[1].Rows[0]["WareHouseID"]), 0);
}
}
}
else
{
if (StillageQty == 0)
{
query = "[Sp_MasterDataWebApi]";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "GetActivityMaster");
dbcommand.Parameters.AddWithValue("@ActivityID", "Reject & Discarded");
SqlDataAdapter daGetData1 = new SqlDataAdapter(dbcommand);
DataSet dsGetData1 = new DataSet();
daGetData.Fill(dsGetData1);
string JournalID = "";
if (RSR.IsKg == 1)
{
obj.ProcessRejectionRAF(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), false, false, Convert.ToString(RSR.Shift), RSR.StickerNo, "HHD", false, false, StillageQtyPcs);
JournalID = obj.QCRejectHeader(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), RSR.StickerNo, "Web");
obj.QCRejectLines(Cct, JournalID, "Process", StillageQtyPcs, Convert.ToString(RSR.Reason), Convert.ToString(RSR.Shift), Convert.ToDateTime(DateTime.Now.ToString()), RSR.Quantity);
//obj.QCRejectFGLine(Cct, JournalID);
obj.PostQCReject(Cct, JournalID);
string value = obj.InsertHistoryHeaderData(Cct, RSR.StickerNo, 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, RSR.StickerNo, "", Convert.ToString(dsGetData1.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData1.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonDes"]), "Yes", 0, "", 0, 0, StillageQty, Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]), Hold, StillageQtyPcs, "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]), 0);
}
else
{
obj.ProcessRejectionRAF(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), false, false, Convert.ToString(RSR.Shift), RSR.StickerNo, "HHD", false, false, RSR.Quantity);
JournalID = obj.QCRejectHeader(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), RSR.StickerNo, "Process");
obj.QCRejectLines(Cct, JournalID, "Process", Convert.ToDecimal(RSR.Quantity), Convert.ToString(RSR.Reason), Convert.ToString(RSR.Shift), Convert.ToDateTime(DateTime.Now.ToString()), RSR.Quantity);
//obj.QCRejectFGLine(Cct, JournalID);
obj.PostQCReject(Cct, JournalID);
string value = obj.InsertHistoryHeaderData(Cct, RSR.StickerNo, 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, RSR.StickerNo, "", Convert.ToString(dsGetData1.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData1.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonDes"]), "Yes", 0, "", 0, 0, StillageQty, Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]), Hold, RSR.Quantity, "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]), 0);
}
//obj.UpdateStillageQty(Cct, RSR.StickerNo, Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), StillageQty);
}
else
{
string JournalID = "";
if (RSR.IsKg == 1)
{
obj.ProcessRejectionRAF(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), false, false, Convert.ToString(RSR.Shift), RSR.StickerNo, "HHD", false, false, StillageQtyPcs);
JournalID = obj.QCRejectHeader(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), RSR.StickerNo, "Web");
obj.QCRejectLines(Cct, JournalID, "Process", StillageQtyPcs, Convert.ToString(RSR.Reason), Convert.ToString(RSR.Shift), Convert.ToDateTime(DateTime.Now.ToString()), RSR.Quantity);
//obj.QCRejectFGLine(Cct, JournalID);
obj.PostQCReject(Cct, JournalID);
string value = obj.InsertHistoryHeaderData(Cct, RSR.StickerNo, 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, RSR.StickerNo, "", Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonDes"]), "Yes", 0, "", 0, 0, StillageQty, Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]), Hold, StillageQtyPcs, "", "", "", Convert.ToString(dsGetData.Tables[1].Rows[0]["WareHouseID"]), 0);
}
else
{
obj.ProcessRejectionRAF(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), false, false, Convert.ToString(RSR.Shift), RSR.StickerNo, "HHD", false, false, RSR.Quantity);
JournalID = obj.QCRejectHeader(Cct, Convert.ToString(dsGetData.Tables[0].Rows[0]["WorkOrderNo"]), RSR.StickerNo, "Process");
obj.QCRejectLines(Cct, JournalID, "Process", Convert.ToDecimal(RSR.Quantity), Convert.ToString(RSR.Reason), Convert.ToString(RSR.Shift), Convert.ToDateTime(DateTime.Now.ToString()), RSR.Quantity);
//obj.QCRejectFGLine(Cct, JournalID);
obj.PostQCReject(Cct, JournalID);
string value = obj.InsertHistoryHeaderData(Cct, RSR.StickerNo, 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, RSR.StickerNo, "", Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonName"]), Convert.ToString(dsGetData.Tables[2].Rows[0]["ReasonDes"]), "Yes", 0, "", 0, 0, StillageQty, Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]), Hold, RSR.Quantity, "", "", "", Convert.ToString(dsGetData.Tables[1].Rows[0]["WareHouseID"]), 0);
}
}
}
query = "Sp_RejectStillageWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "SingleRejectStillage");
dbcommand.Parameters.AddWithValue("@StickerId", RSR.StickerNo);
dbcommand.Parameters.AddWithValue("@RejectedQty", StillageQty);
dbcommand.Parameters.AddWithValue("@Reason", RSR.Reason);
dbcommand.Parameters.AddWithValue("@Shift", RSR.Shift);
dbcommand.Parameters.AddWithValue("@UserId", RSR.UserId);
//dbcommand.Parameters.AddWithValue("@ActivityID", RSR.ActivityID);
SqlDataAdapter daGetData0 = new SqlDataAdapter(dbcommand);
DataSet dsGetData0 = new DataSet();
daGetData0.Fill(dsGetData0);
da = new SqlDataAdapter(dbcommand);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0]["value"].ToString() == "1")
{
SM.Status = "Success";
SM.Message = "Stillage Reject successfully";
}
else
{
SM.Status = "Failure";
SM.Message = "Stillage Not Reject successful";
}
}
}
else
{
SM.Status = "Failure";
SM.Message = "This Stillage Does Not Exist";
return(SM);
}
}
catch (Exception Ex)
{
SM.Status = "Failure";
SM.Message = Ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(SM);
}
public StickerMaster HoldUnHoldStillageDetail(RejectedStillageReq RSR)
{
string StillageStatus = "";
StickerMaster SM = new StickerMaster();
try
{
if (RSR.StickerNo == "")
{
SM.Status = "Failure";
SM.Message = "Enter Sticker ID";
}
if (RSR.UserId == 0)
{
SM.Status = "Failure";
SM.Message = "Invalid UserId";
}
if (RSR.IsHold == 1)
{
StillageStatus = "Qc Hold";
}
else
{
StillageStatus = "Qc Release";
}
query = "Sp_PickAndLoad";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "FetchDataHold");
dbcommand.Parameters.AddWithValue("@StillageID", RSR.StickerNo);
dbcommand.Parameters.AddWithValue("@UserId", RSR.UserId);
//dbcommand.Parameters.AddWithValue("@ActivityID", RSR.ActivityID);
SqlDataAdapter daGetData = new SqlDataAdapter(dbcommand);
DataSet dsGetData = new DataSet();
daGetData.Fill(dsGetData);
SqlDataAdapter da = new SqlDataAdapter(dbcommand);
if (dsGetData.Tables[0].Rows[0]["value"].ToString() != "2")
{
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 value = obj.InsertHistoryHeaderData(Cct, RSR.StickerNo, 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]["LoadQuantity"]));
obj.InsertHistoryDetailData(Cct, RSR.StickerNo, "", Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["StillageLocation"]), "", "", "", "", "", "", "No", 0, "", 0, 0, Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["StillageQty"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]), StillageStatus, 0, "", "", "", Convert.ToString(dsGetData.Tables[1].Rows[0]["WareHouseID"]), 0);
}
else
{
SM.Status = "Failure";
SM.Message = "This stillage Does Not Exist";
return(SM);
}
query = "Sp_RejectStillageWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "UpdateHoldUnHoldStillage");
dbcommand.Parameters.AddWithValue("@StickerId", RSR.StickerNo);
dbcommand.Parameters.AddWithValue("@UserId", RSR.UserId);
dbcommand.CommandTimeout = 0;
da = new SqlDataAdapter(dbcommand);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0]["value"].ToString() == "1")
{
SM.Status = "Success";
SM.Message = "Stillage holded successfully";
}
else if (dt.Rows[0]["value"].ToString() == "2")
{
SM.Status = "Success";
SM.Message = "QC Released Successfully";
}
else
{
SM.Status = "Failure";
SM.Message = "Operation failure";
}
}
catch (Exception Ex)
{
SM.Status = "Failure";
SM.Message = Ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(SM);
}
