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