private void showData()
{
try
{
int rowNo = 1;
_entities = new KBBQEntities();
List <advBookingVM> modelList = new List <advBookingVM>();
var advanceBookingData = _entities.tblAdvBookings.Where(x => x.id == passedId).ToList();
foreach (var item in advanceBookingData)
{
advBookingVM model = new advBookingVM();
model.id = item.id;
model.rowNo = rowNo;
model.adults = item.adults;
model.child = item.child;
model.custName = item.custName;
model.mob = item.mob;
model.advancePayment = item.advancePayment;
model.eventDate = Convert.ToDateTime(item.eventDate).ToString("dd-MMM-yyyy");
model.totalPayment = item.totalPayment;
model.status = item.status;
model.udate = item.udate;
model.cdate = Convert.ToDateTime(item.cdate).ToString("dd-MMM-yyyy");
model.recptNo = item.recptNo;
model.id = item.id;
modelList.Add(model);
}
ReportDataSource datasource = new ReportDataSource("DataSet1", modelList);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(datasource);
}
catch (Exception x)
{
}
}
private void gridViewBind()
{
try
{
dgAdvBookingDetails.AutoGenerateColumns = false;
int rowNo = 1;
_entities = new KBBQEntities();
List <advBookingVM> modelList = new List <advBookingVM>();
var advanceBookingData = _entities.tblAdvBookings.Where(x => x.todayDate == dtpStartDate.Value.Date).ToList();
foreach (var item in advanceBookingData)
{
advBookingVM model = new advBookingVM();
model.id = item.id;
model.rowNo = rowNo;
model.adults = item.adults;
model.child = item.child;
model.custName = item.custName;
model.mob = item.mob;
model.advancePayment = item.advancePayment;
model.eventDate = Convert.ToDateTime(item.eventDate).ToString("dd-MMM-yyyy");
model.totalPayment = item.totalPayment;
model.status = item.status;
model.udate = item.udate;
model.cdate = Convert.ToDateTime(item.cdate).ToString("dd-MM-yyyy");
model.recptNo = item.recptNo;
model.id = item.id;
modelList.Add(model);
}
dgAdvBookingDetails.DataSource = modelList;
lblTotalRows.Text = modelList.Count.ToString();
}
catch (Exception x)
{
}
}
