public LoadingPlan UpdateLoadingplanscanstatus(NewLoadingPlanReq LPR) { LoadingPlan SS1 = new LoadingPlan(); try { if (LPR.LPID == "0") { SS1.Status = "Failure"; SS1.Message = "Invalid ID"; } if (LPR.UserId == "0") { SS1.Status = "Failure"; SS1.Message = "Invalid UserId"; } query = "Sp_NewLoadingPlanWebApi"; dbcommand = new SqlCommand(query, conn); dbcommand.Connection.Open(); dbcommand.CommandType = CommandType.StoredProcedure; dbcommand.Parameters.AddWithValue("@QueryType", "UpdatePendingFlag"); dbcommand.Parameters.AddWithValue("@TLPHID", LPR.LPID); dbcommand.Parameters.AddWithValue("@UserId", LPR.UserId); dbcommand.CommandTimeout = 0; SqlDataAdapter da = new SqlDataAdapter(dbcommand); DataSet dt = new DataSet(); da.Fill(dt); if (dt != null && dt.Tables[0].Rows.Count > 0) { if (dt.Tables[0].Rows[0]["result"].ToString() == "1") { SS1.Status = "Success"; SS1.Message = "Successfull move to ongoing to pending"; } else { SS1.Status = "Failure"; SS1.Message = "Sorry Invalid loading plan no."; } } else { SS1.Status = "Failure"; SS1.Message = "Sorry Invalid loading plan no."; } } catch (Exception Ex) { SS1.Status = "Failure"; SS1.Message = Ex.Message; } finally { dbcommand.Connection.Close(); } return(SS1); }
public NewLoadingPlanDetails LoadingPlanDetails(NewLoadingPlanReq LPR) { NewLoadingPlanDetails SS = new NewLoadingPlanDetails(); try { if (LPR.LPID == "0") { SS.Status = "Failure"; SS.Message = "Invalid ID"; } if (LPR.UserId == "0") { SS.Status = "Failure"; SS.Message = "Invalid UserId"; } query = "Sp_NewLoadingPlanWebApi"; dbcommand = new SqlCommand(query, conn); dbcommand.Connection.Open(); dbcommand.CommandType = CommandType.StoredProcedure; dbcommand.Parameters.AddWithValue("@QueryType", "LoadingPlanDetails"); dbcommand.Parameters.AddWithValue("@TLPHID", LPR.LPID); dbcommand.Parameters.AddWithValue("@UserId", LPR.UserId); dbcommand.CommandTimeout = 0; SqlDataAdapter da = new SqlDataAdapter(dbcommand); DataSet dt = new DataSet(); da.Fill(dt); if (dt != null && dt.Tables[0].Rows.Count > 0) { if (dt.Tables[2].Rows[0]["result"].ToString() == "2") { SS.Status = "close"; SS.Message = "This loading plan is discarded"; } else if (dt.Tables[2].Rows[0]["result"].ToString() == "3") { SS.Status = "close"; SS.Message = "This loading plan is finished"; } else { SS.TruckID = dt.Tables[0].Rows[0]["TruckID"].ToString(); SS.DriverName = dt.Tables[0].Rows[0]["DriverName"].ToString(); SS.GateNo = Convert.ToInt16(dt.Tables[0].Rows[0]["GateNo"]); SS.LoadingPlanNo = dt.Tables[0].Rows[0]["LoadingPlanNo"].ToString(); SS.DriverID = dt.Tables[0].Rows[0]["DriverId"].ToString(); SS.TruckNo = dt.Tables[0].Rows[0]["TruckNo"].ToString(); List <NewLoadingPlanDetailsList> LoadingPlanList = new List <NewLoadingPlanDetailsList>(); foreach (DataRow row in dt.Tables[0].Rows) { NewLoadingPlanDetailsList A = new NewLoadingPlanDetailsList(); A.ItemName = row["ItemName"].ToString(); A.ItemId = row["ItemId"].ToString(); A.ToBeLoadedQty = Convert.ToDecimal(row["PickingQty"]); A.DeliveryReminderQty = Convert.ToDecimal(row["PDSCWDELIVERYREMINDER"]); A.LoadedQty = Convert.ToDecimal(row["LoadedQuantity"]); A.PickingPlanNo = row["PlanningID"].ToString(); A.SalesOrder = row["SalesOrder"].ToString(); LoadingPlanList.Add(A); } SS.ItemList = LoadingPlanList; List <ReasonList> ReasonList = new List <ReasonList>(); foreach (DataRow row in dt.Tables[1].Rows) { ReasonList A = new ReasonList(); A.id = Convert.ToString(row["id"]); A.name = row["name"].ToString(); ReasonList.Add(A); } SS.ReasonList = ReasonList; SS.Status = "Success"; SS.Message = "Data retrived successfully"; } } else { SS.Status = "Failure"; SS.Message = "There is no more stillage in this loading plan."; } } catch (Exception Ex) { SS.Status = "Failure"; SS.Message = Ex.Message; } finally { dbcommand.Connection.Close(); } return(SS); }