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); }