private void BindGridData()
{
var filter = new VisitorFilter()
{
DATE_FROM = (dtFrom.Value == null || dtFrom.Value == DateTime.MinValue) ? DateTime.Now : dtFrom.Value,
DATE_TO = (dtTo.Value == null || dtTo.Value == DateTime.MinValue) ? DateTime.Now : dtTo.Value
};
if (radAll.Checked)
{
filter.TYPE = nameof(VisitorMode.All);
}
if (radIn.Checked)
{
filter.TYPE = nameof(VisitorMode.In);
}
if (radOut.Checked)
{
filter.TYPE = nameof(VisitorMode.Out);
}
filter.DEPT_ID = Convert.ToInt32(ddlDept.SelectedValue);
_container.Filter = filter;
_container = _service.GetVisitorForReport(_container);
SetDataSourceHeader(gridReportList, ListHeader(), _container.ResultObj);
}
private void BindGridData()
{
var filter = new VisitorFilter()
{
ID_CARD = txtIDCard.Text,
LICENSE_PLATE = txtLicense.Text,
NO = txtNo.Text == "" ? 0 : Convert.ToInt32(txtNo.Text),
FIRST_NAME = txtName.Text,
LAST_NAME = txtLastName.Text
};
if (comboType.SelectedIndex == 0)
{
}
else if (comboType.SelectedIndex == 1)
{
filter.TYPE = "In";
}
else if (comboType.SelectedIndex == 2)
{
filter.TYPE = "Out";
}
else if (comboType.SelectedIndex == 3)
{
filter.TYPE = "Appointment";
}
else if (comboType.SelectedIndex == 4)
{
filter.TYPE = "AppointmentOut";
}
_container.Filter = filter;
_container = _service.Retrieve(_container);
SetDataSourceHeader(gridVisitorList, ListHeader(), _container.ResultObj);
SetPageControl(_container);
}
private void BindGridData()
{
var filter = new VisitorFilter()
{
//TYPE = "IN",
DATE_FROM = (dtFrom.Value == null || dtFrom.Value == DateTime.MinValue) ? DateTime.Now : dtFrom.Value,
DATE_TO = (dtTo.Value == null || dtTo.Value == DateTime.MinValue) ? DateTime.Now : dtTo.Value
};
_container.Filter = filter;
_container = _service.GetVisitorForReport(_container);
SetDataSourceHeader(gridListVisitor, ListHeader(), _container.ResultObj);
}
private void BindGridData()
{
var filter = new VisitorFilter()
{
ID_CARD = txtIDCard.Text,
FIRST_NAME = txtName.Text,
LAST_NAME = txtLastName.Text,
LICENSE_PLATE = txtLicense.Text,
};
if (chkDate.Checked)
{
filter.DATE_FROM = dtContactDate.Value;
}
_container.Filter = filter;
_container = _service.GetListVisitorNotOut(_container);
lblTotalItem.Text = _container.PageInfo.TOTAL_ITEM.ToString();
SetDataSourceHeader(gridVisitorOut, ListHeader(), _container.ResultObj);
SetPageControl(_container);
}
private void btnPrintMonth_Click(object sender, EventArgs e)
{
var timeNow = DateTime.Now;
var firstDayOfMonth = new DateTime(timeNow.Year, timeNow.Month, 1);
var lastDayOfMonth = firstDayOfMonth.AddMonths(1).AddDays(-1);
var filter = new VisitorFilter()
{
DATE_FROM = ChangeTime(firstDayOfMonth, 0, 0, 0, 1),
DATE_TO = ChangeTime(lastDayOfMonth, 23, 59, 59, 59),
};
_container.Filter = filter;
_container = _service.GetVisitorForReport(_container);
if (_container.ResultObj.Count > 0)
{
List <CustomVisitor> listData = (List <CustomVisitor>)_container.ResultObj;
DataTable dt = ConvertToDataTable(listData);
DataTable headerTable = new DataTable("Customers");
DataColumn dtColumn;
DataRow myDataRow;
dtColumn = new DataColumn();
dtColumn.DataType = typeof(String);
dtColumn.ColumnName = "COMPANY_NAME";
headerTable.Columns.Add(dtColumn);
dtColumn = new DataColumn();
dtColumn.DataType = typeof(String);
dtColumn.ColumnName = "USER_PRINT";
headerTable.Columns.Add(dtColumn);
myDataRow = headerTable.NewRow();
myDataRow["COMPANY_NAME"] = "BIG Visitor Management";
myDataRow["USER_PRINT"] = LOGIN;
headerTable.Rows.Add(myDataRow);
ReportDocument rpt = new ReportDocument();
string path = System.Reflection.Assembly.GetExecutingAssembly().Location;
var appPath = Application.StartupPath + "\\" + "VisitorListReport.rpt";
rpt.Load(appPath);
rpt.Database.Tables[0].SetDataSource(dt);
rpt.Database.Tables[1].SetDataSource(headerTable);
using (Form form = new Form())
{
CrystalReportViewer tempViewer = new CrystalReportViewer();
tempViewer.ActiveViewIndex = -1;
tempViewer.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
tempViewer.Dock = System.Windows.Forms.DockStyle.Fill;
tempViewer.Name = "tempViewer";
tempViewer.SelectionFormula = "";
tempViewer.TabIndex = 0;
tempViewer.ViewTimeSelectionFormula = "";
tempViewer.ReportSource = rpt;
tempViewer.AutoSize = true;
tempViewer.Refresh();
form.Controls.Add(tempViewer);
form.Size = this.Size;
form.StartPosition = FormStartPosition.CenterParent;
form.ShowDialog();
}
}
SetDataSourceHeader(gridReportList, ListHeader(), _container.ResultObj);
}
