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 STDetailResponce UpdateLoadingPlan(LoadReqForNew PAL)
{
STDetailResponce SM = new STDetailResponce();
try
{
if (PAL.UserId == "" || PAL.UserId == null)
{
SM.Status = "Failure";
SM.Message = "Invalid UserId";
return(SM);
}
if (PAL.LPID == "" || PAL.LPID == null)
{
SM.Status = "Failure";
SM.Message = "Invalid LoadingId";
return(SM);
}
query = "[Sp_NewLoadingPlan]";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "UpdateLoadingPlanStatus");
dbcommand.Parameters.AddWithValue("@UserId", PAL.UserId);
dbcommand.Parameters.AddWithValue("@LoadingId", PAL.LPID);
dbcommand.Parameters.AddWithValue("@Isdiscard", PAL.Isdiscard);
SqlDataAdapter daGetData = new SqlDataAdapter(dbcommand);
DataSet dsGetData = new DataSet();
daGetData.Fill(dsGetData);
if (dsGetData.Tables[0].Rows[0]["value"].ToString() == "1")
{
SM.Status = "Success";
SM.Message = "Loading Plan finished Successfully";
}
else if (dsGetData.Tables[0].Rows[0]["value"].ToString() == "3")
{
SM.Status = "Success";
SM.Message = "Loading Plan Discarded Successfully";
}
else if (dsGetData.Tables[0].Rows[0]["value"].ToString() == "2")
{
SM.Status = "Failure";
SM.Message = "Loading Failure";
}
else
{
SM.Status = "Failure";
SM.Message = "Loading Failure";
}
}
catch (Exception Ex)
{
SM.Status = "Failure";
SM.Message = Ex.Message;
}
return(SM);
}
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();
}
}
