public GetrequestNo UpdateRAF(RAFDetailsReq RAFD)
{
GetrequestNo res = new GetrequestNo();
// List<GetrequestNoRes> ListView = new List<GetrequestNoRes>();
try
{
if (RAFD.StickerNo == "" || RAFD.StickerNo == null)
{
res.Status = "Failure";
res.Message = "Enter Sticker ID";
}
if (RAFD.Shift == "" || RAFD.Shift == null)
{
res.Status = "Failure";
res.Message = "Enter Shift";
}
//if (RAFD.WorkOrderNo == "" || RAFD.WorkOrderNo == null)
//{
// res.Status = "Failure";
// res.Message = "Invalid WorkOrderNo";
//}
bool AutoPicked = true;
bool AutoRoute = true;
if (RAFD.AutoPick == 1)
{
AutoPicked = true;
}
else
{
AutoPicked = false;
}
if (RAFD.AutoRoute == 1)
{
AutoRoute = true;
}
else
{
AutoRoute = false;
}
RAFD.ActivityID = 6;
query = "Sp_Counting";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "FetchRafData");
dbcommand.Parameters.AddWithValue("@StillageID", RAFD.StickerNo);
dbcommand.Parameters.AddWithValue("@UserId", RAFD.UserId);
dbcommand.Parameters.AddWithValue("@ActivityID", RAFD.ActivityID);
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";
}
if (Convert.ToString(dsGetData.Tables[1].Rows[0]["WorkOrderNo"]) == "NA")
{
res.Status = "Failure";
res.Message = "This operation doesn't process this stillage sticker ";
return(res);
}
if (dsGetData.Tables[0].Rows[0]["value"].ToString() == "3")
{
res.Status = "Failure";
res.Message = "This stillage is already counted";
return(res);
}
else 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");
NeproWebApi.AXWebServiceRef1.Iace_FinishedGoodServiceClient obj = new NeproWebApi.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"]);
NeproWebApi.AXWebServiceRef1.CallContext Cct = new NeproWebApi.AXWebServiceRef1.CallContext();
Cct.Company = Convert.ToString(ds.Tables[0].Rows[0]["Company"]);
Cct.Language = Convert.ToString(ds.Tables[0].Rows[0]["Language"]);
Global global = new Global();
string Username = global.GetUsername(RAFD.UserId.ToString());
string value2 = obj.ReportAsFinished(Cct, Convert.ToString(dsGetData.Tables[1].Rows[0]["WorkOrderNo"]), AutoPicked, AutoRoute, RAFD.Shift, RAFD.StickerNo, Username + "-HHD", false, false, false);
//string value2 = obj.UpdateQty(Cct, Convert.ToString(dsGetData.Tables[1].Rows[0]["WorkOrderNo"]), AutoPicked, AutoRoute, RAFD.Shift, RAFD.StickerNo, "HDD",150);
string value = obj.InsertHistoryHeaderData(Cct, RAFD.StickerNo, Convert.ToString(dsGetData.Tables[1].Rows[0]["SiteID"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["WorkOrderNo"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["ItemId"]), Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["WorkOrderQty"]));
//obj.InsertHistoryDetailData(Cct, RAFD.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"]), "", "", "", "", "", "", "Yes", 0, "", 0, Convert.ToDecimal(dsGetData.Tables[0].Rows[0]["StillageQty"]), Convert.ToDecimal(dsGetData.Tables[0].Rows[0]["StillageQty"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["UserName"]), Hold, 0, "","","", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]),0);
obj.InsertHistoryDetailData(Cct, RAFD.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"]), "", "", "", "", "", "", "Yes", 0, "", 0, Convert.ToDecimal(dsGetData.Tables[0].Rows[0]["StillageQty"]), Convert.ToDecimal(dsGetData.Tables[0].Rows[0]["StillageQty"]), Convert.ToString(dsGetData.Tables[0].Rows[0]["UserName"]), Hold, 0, "", "", "", Convert.ToString(dsGetData.Tables[0].Rows[0]["WareHouseID"]));
// DataTable dtItems = (DataTable)JsonConvert.DeserializeObject(Xmlitems, (typeof(DataTable)));
}
else
{
res.Status = "Failure";
res.Message = "This stillage does not exist";
return(res);
}
query = "Sp_MovingWebApi";
dbcommand = new SqlCommand(query, conn);
//dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "UpdateRAF");
//dbcommand.Parameters.AddWithValue("@WorkOrderNo", RAFD.WorkOrderNo);
dbcommand.Parameters.AddWithValue("@StickerId", RAFD.StickerNo);
dbcommand.Parameters.AddWithValue("@UserId", RAFD.UserId);
dbcommand.Parameters.AddWithValue("@Shift", RAFD.Shift);
dbcommand.Parameters.AddWithValue("@Quantity", RAFD.Quantity);
dbcommand.Parameters.AddWithValue("@AutoPick", RAFD.AutoPick);
dbcommand.Parameters.AddWithValue("@AutoRoute", RAFD.AutoRoute);
dbcommand.CommandTimeout = 0;
da = new SqlDataAdapter(dbcommand);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0]["value"].ToString() == "1")
{
res.Status = "Success";
res.Message = "RAF Posted successfully";
return(res);
}
else
{
res.Status = "Failure";
res.Message = "RAF Not Posted successfully";
return(res);
}
}
catch (Exception Ex)
{
res.Status = "Failure";
res.Message = Ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(res);
}
public ReceivingResponse UpdateAssignation(AssigningReq AR)
{
ReceivingResponse res = new ReceivingResponse();
try
{
if (AR == null)
{
res.Status = "Failure";
res.Message = "Object reference not set to an instance of an object.";
}
if (AR.StickerNo == "")
{
res.Status = "Failure";
res.Message = "Invalid Sticker No.";
}
else
{
query = "Sp_AssignWebApi";
dbcommand = new SqlCommand(query, conn);
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.CommandTimeout = 0;
dbcommand.Parameters.AddWithValue("@QueryType", "FetchDataAssigning");
dbcommand.Parameters.AddWithValue("@StillageID", AR.StickerNo);
dbcommand.Parameters.AddWithValue("@UserId", AR.UserId);
dbcommand.Parameters.AddWithValue("@Aisle", AR.Aisle);
dbcommand.Parameters.AddWithValue("@Bin", AR.Bin);
dbcommand.Parameters.AddWithValue("@Rack", AR.Rack);
dbcommand.Parameters.AddWithValue("@Zone", AR.Zone);
dbcommand.Parameters.AddWithValue("@AssignedUser", AR.AssignedFLT);
dbcommand.Parameters.AddWithValue("@WareHouseID", AR.WareHouseID);
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";
}
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");
NeproWebApi.AXWebServiceRef1.Iace_FinishedGoodServiceClient obj = new NeproWebApi.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"]);
NeproWebApi.AXWebServiceRef1.CallContext Cct = new NeproWebApi.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, AR.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, AR .StickerNo, "", Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityName"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["ActivityDesc"]), Convert.ToString(dsGetData.Tables[2].Rows[0]["ZONEID"]), "", Convert.ToString(dsGetData.Tables[1].Rows[0]["AssignedFLT"]), 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"]), "", 0, "");
obj.InsertHistoryDetailData(Cct, AR.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[1].Rows[0]["AssignedFLT"]), "", Convert.ToString(dsGetData.Tables[2].Rows[0]["ZONEID"]), "", "", "No", 0, "", 0, 0, Convert.ToDecimal(dsGetData.Tables[1].Rows[0]["StillageQty"]), Convert.ToString(dsGetData.Tables[1].Rows[0]["UserName"]), Hold, 0, "", "", "", Convert.ToString(dsGetData.Tables[1].Rows[0]["WareHouseID"]), 0);
}
else
{
res.Status = "Failure";
res.Message = "This Stillage Does Not Exist";
return(res);
}
query = "[Sp_AssignWebApi]";
dbcommand = new SqlCommand(query, conn);
dbcommand.Connection.Open();
dbcommand.CommandType = CommandType.StoredProcedure;
dbcommand.Parameters.AddWithValue("@QueryType", "UpdateAssign");
dbcommand.Parameters.AddWithValue("@StickerId", AR.StickerNo);
dbcommand.Parameters.AddWithValue("@Aisle", AR.Aisle);
dbcommand.Parameters.AddWithValue("@Rack", AR.Rack);
dbcommand.Parameters.AddWithValue("@Bin", AR.Bin);
dbcommand.Parameters.AddWithValue("@UserId", AR.UserId);
dbcommand.Parameters.AddWithValue("@AssignedUser", AR.AssignedFLT);
dbcommand.Parameters.AddWithValue("@WareHouseID", AR.WareHouseID);
dbcommand.Parameters.AddWithValue("@Zone", AR.Zone);
dbcommand.CommandTimeout = 0;
da = new SqlDataAdapter(dbcommand);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows[0]["value"].ToString() == "1")
{
res.Status = "Success";
res.Message = "Stillage assigned successfully";
}
else
{
res.Status = "Failure";
res.Message = "Stillage not successfully assigned.!";
}
}
}
catch (Exception Ex)
{
res.Status = "Failure";
res.Message = Ex.Message;
}
finally
{
dbcommand.Connection.Close();
}
return(res);
}
