public List <DeliveriesDTO> GetAllDeliveries(string wayBillNo)
{
List <DeliveriesDTO> lstStudent = new List <DeliveriesDTO>();
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand(string.Format("SELECT * FROM Deliveries WHERE WayBillNo ={0}", wayBillNo), con);
//SqlCommand cmd = new SqlCommand("SELECT * FROM Deliveries", con);
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());
lstStudent.Add(deliveryDTO);
}
con.Close();
}
return(lstStudent);
}
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);
}
