protected internal virtual void OnReceivingResponse(object sender, IReceivingResponseEventArgs <TService> e) { if (!Enabled) { return; } ReceivingResponse?.Invoke(sender, e); }
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); }