}//END OF SEARCH SPECIFIC PENDING ACCOUNT public List <JoinAccountInfo> searchReceiptRefence_transactions(string dtFrom, string dtTo) { DateTime dfrom = DateTime.Parse(dtFrom); dtFrom = dfrom.ToString("yyyy-MM-dd"); DateTime dto = DateTime.Parse(dtTo); dtTo = dto.ToString("yyyy-MM-dd"); try { openConnection(); sql = @"SELECT * FROM (((tblreceiptreference A INNER JOIN tblvehicleinfo B ON A.refVehicleID = B.vehicleID) INNER JOIN tblparkingslot C ON A.refParkingID = C.slotID) INNER JOIN tblvehiclebrand D ON D.brandID = B.vehicleBrand) INNER JOIN tblvehicletype E ON E.typeID = D.brandCategory WHERE A.refStatus='PAID' AND (A.created_at BETWEEN '" + dtFrom + "' AND '" + dtTo + "') ORDER BY A.refID"; cmd = new MySqlCommand(sql, con); rd = cmd.ExecuteReader(); if (rd.HasRows) { var listOfReceipt = new List <JoinAccountInfo>(); while (rd.Read()) { var receipt = new JoinAccountInfo(); receipt.refID = rd["refID"].ToString(); receipt.refBarcode = rd["refBarcode"].ToString(); receipt.refVehicleID = rd["refVehicleID"].ToString(); receipt.refParkingID = rd["refParkingID"].ToString(); receipt.refTimeIn = rd["refTimeIn"].ToString(); receipt.refTimeOut = rd["refTimeOut"].ToString(); receipt.refPersonnelIn = rd["refPersonnelIn"].ToString(); receipt.refPersonnelOut = rd["refPersonnelOut"].ToString(); receipt.refStatus = rd["refStatus"].ToString(); receipt.refTimeCount = rd["refTimeCount"].ToString(); receipt.refPrice = rd["refPrice"].ToString(); receipt.refAmountChange = rd["refAmountChange"].ToString(); receipt.refAmountPaid = rd["refAmountPaid"].ToString(); receipt.vehicleOwner = rd["vehicleOwner"].ToString(); receipt.slotBlock = rd["slotBlock"].ToString(); receipt.slotNumber = rd["slotNumber"].ToString(); receipt.typeRatePerHour = rd["typeRatePerHour"].ToString(); receipt.vehicleColor = rd["vehicleColor"].ToString(); receipt.vehiclePlateNo = rd["vehiclePlateNo"].ToString(); receipt.typeName = rd["typeName"].ToString(); receipt.brandName = rd["brandName"].ToString(); listOfReceipt.Add(receipt); } return(listOfReceipt); } else { Console.WriteLine("No data"); } } catch (Exception ex) { Console.WriteLine(ex); } finally { con.Close(); } return(null); }//END OF SEARCH TRANSACTIONS PER DATE
}//END OF SEARCH FROM ALL PENDING ACCOUNT public List <JoinAccountInfo> searchReceiptRefence_pending_specific(string searchText) { try { openConnection(); sql = @"SELECT * FROM (((tblreceiptreference A INNER JOIN tblvehicleinfo B ON A.refVehicleID = B.vehicleID) INNER JOIN tblparkingslot C ON A.refParkingID = C.slotID) INNER JOIN tblvehiclebrand D ON D.brandID = B.vehicleBrand) INNER JOIN tblvehicletype E ON E.typeID = D.brandCategory WHERE A.refBarcode='" + searchText + "' AND refStatus='PENDING'"; cmd = new MySqlCommand(sql, con); rd = cmd.ExecuteReader(); if (rd.HasRows) { var listOfReceipt = new List <JoinAccountInfo>(); while (rd.Read()) { var receipt = new JoinAccountInfo(); receipt.refID = rd["refID"].ToString(); receipt.refBarcode = rd["refBarcode"].ToString(); receipt.refVehicleID = rd["refVehicleID"].ToString(); receipt.refParkingID = rd["refParkingID"].ToString(); receipt.refTimeIn = rd["refTimeIn"].ToString(); //receipt.refTimeOut = rd["refTimeOut"].ToString(); receipt.refPersonnelIn = rd["refPersonnelIn"].ToString(); receipt.refPersonnelOut = rd["refPersonnelOut"].ToString(); receipt.refStatus = rd["refStatus"].ToString(); receipt.refTimeCount = rd["refTimeCount"].ToString(); receipt.refPrice = rd["refPrice"].ToString(); receipt.refAmountChange = rd["refAmountChange"].ToString(); receipt.refAmountPaid = rd["refAmountPaid"].ToString(); receipt.vehicleOwner = rd["vehicleOwner"].ToString(); receipt.slotBlock = rd["slotBlock"].ToString(); receipt.slotNumber = rd["slotNumber"].ToString(); receipt.typeRatePerHour = rd["typeRatePerHour"].ToString(); receipt.vehicleColor = rd["vehicleColor"].ToString(); receipt.vehiclePlateNo = rd["vehiclePlateNo"].ToString(); receipt.typeName = rd["typeName"].ToString(); receipt.brandName = rd["brandName"].ToString(); listOfReceipt.Add(receipt); } return(listOfReceipt); } else { Console.WriteLine("No data"); } } catch (Exception ex) { Console.WriteLine(ex); } finally { con.Close(); } return(null); }//END OF SEARCH SPECIFIC PENDING ACCOUNT