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