public IActionResult TrackDelivery(TrackDeliveryVM trackDeliveryVM) { ProductDAL ProductDAL = new ProductDAL(); trackDeliveryVM = ProductDAL.GetAllDeliveries(trackDeliveryVM); //trackDeliveryVM.DeliveriesList = DeliveriesList; return(View(trackDeliveryVM)); }
public IActionResult TrackDelivery() { TrackDeliveryVM DeliveriesList = new TrackDeliveryVM() { DeliveriesList = new List <DeliveriesDTO>() }; return(View(DeliveriesList)); }
public IActionResult TrackDelivery(TrackDeliveryVM trackDeliveryVM) { ProductDAL ProductDAL = new ProductDAL(); List <DeliveriesDTO> DeliveriesList = ProductDAL.GetAllDeliveries(trackDeliveryVM.WayBillNo); trackDeliveryVM.DeliveriesList = DeliveriesList; return(View(trackDeliveryVM)); }
public IActionResult TrackDeliverySingle(string wayBillNo) { ProductDAL ProductDAL = new ProductDAL(); List <DeliveriesDTO> DeliveriesList = ProductDAL.GetAllDeliveries(wayBillNo); TrackDeliveryVM trackDeliveryVM = new TrackDeliveryVM(); trackDeliveryVM.DeliveriesList = DeliveriesList; return(View(trackDeliveryVM.DeliveriesList.FirstOrDefault())); }
public TrackDeliveryVM GetAllDeliveries(TrackDeliveryVM trackDeliveryVM) { trackDeliveryVM.DeliveriesList = new List <DeliveriesDTO>(); try { using (SqlConnection con = new SqlConnection(connectionString)) { string commandText = "SELECT * FROM Deliveries WHERE WayBillNo =@WayBillNo"; SqlCommand cmd = new SqlCommand(commandText, con); cmd.Parameters.Add("@WayBillNo", SqlDbType.Int); cmd.Parameters["@WayBillNo"].Value = trackDeliveryVM.WayBillNo; cmd.CommandType = CommandType.Text; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { DeliveriesDTO deliveryDTO = new DeliveriesDTO(); deliveryDTO.DeliveryId = Convert.ToString(rdr["DeliveryId"]); deliveryDTO.WayBillNo = Convert.ToInt32(rdr["WayBillNo"]); deliveryDTO.FromAddress = Convert.ToString(rdr["FromAddress"]); deliveryDTO.ReceiverName = Convert.ToString(rdr["ReceiverName"]); deliveryDTO.ToAddress = Convert.ToString(rdr["ToAddress"]); deliveryDTO.PanCardNo = Convert.ToString(rdr["PanCardNo"]); deliveryDTO.Phone = Convert.ToString(rdr["Phone"]); deliveryDTO.IsDelivered = Convert.ToBoolean(rdr["IsDelivered"]); deliveryDTO.IsActive = Convert.ToBoolean(rdr["IsActive"].ToString()); trackDeliveryVM.DeliveriesList.Add(deliveryDTO); } con.Close(); } } catch (Exception) { trackDeliveryVM.IsError = true; } return(trackDeliveryVM); }