internal FareQuery(UserEntity userinfo)
{
InitializeComponent();
this.userinfo = userinfo;
traininfo = new TrainRepo();
this.PopulateJourneyFrom();
this.PopulateGridView("select trainno,traininfo.name,departurestation,journeydate,departuretime,arrivalstation,arrivaltime,routetype,capacity,bogey,standard,priceperstandard,standardavailableseat,economy,pricepereconomy,economyavailableseat,firstclass,priceperfirstclass,firstclassavailableseat,bogeyinfo from traininfo,journeytimeinfo where traininfo.trainid=journeytimeinfo.trainid and journeydatetime>SYSDATETIME()");
}
internal SellAndFinanceHistory(Employee employee)
{
InitializeComponent();
this.employee = employee;
this.trainRepo = new TrainRepo();
this.trainList = this.trainRepo.TrainList();
string query = "select traininfo.trainid,soldticketid,issuedate,traininfo.name,trainno,departurestation,journeydatetime,arrivalstation,arrivaltime,routetype,passengerinfo.passengername,passengerinfo.mobilenumber,passengerinfo.email,passengerinfo.address,employeeinfo.employeename,class Couch ,amountofticket,bill,vat,netbill,paytype,card,cardnumber,cash,change,couchno,bogeyinfo from soldticketinfo,employeeinfo,journeytimeinfo,passengerinfo,traininfo where soldticketinfo.passengeremail=passengerinfo.email and employeeinfo.email=soldticketinfo.employeeemail and soldticketinfo.journeytimeid=journeytimeinfo.journeytimeid and soldticketinfo.trainid=traininfo.trainid order by soldticketid desc;";
this.PopulateGridView(query);
this.cmbTrainNo.Items.AddRange(this.trainList.ToArray());
}
public void Setup()
{
trainRepro = new TrainRepo(trainTestContext);
}
