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