private void LoadDrivers()
{
HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory();
DataTable DriverDataTable = new DataTable();
string Condition = string.Empty;
TrafficFactory.SelectDriverMobile_nvc(Condition, ref DriverDataTable);
DriverDataTable.Columns.Add(new DataColumn("Checked_bit", Type.GetType("System.Boolean")));
DriverDataTable.Columns["Checked_bit"].AllowDBNull = true;
DriverDataTable.Columns["Checked_bit"].DefaultValue = false;
this.DriversdataGridView.AutoGenerateColumns = false;
this.DriversdataGridView.DataSource = DriverDataTable;
}
private void Showbutton_Click(object sender, EventArgs e)
{
if (FieldNamecomboBox.SelectedIndex != -1 && OperatorcomboBox.SelectedIndex != -1 && string.IsNullOrEmpty(SearchtextBox.Text) == false)
{
HPS.BLL.TrafficBLL.BLLTraffic_TFactory TrafficFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory();
DataTable DriverDataTable = new DataTable();
String Condition = string.Empty;
Condition = string.Format("{0} {1}", FieldNamecomboBox.SelectedValue.ToString(), OperatorcomboBox.SelectedValue.ToString());
Condition = string.Format(Condition, SearchtextBox.Text);
TrafficFactory.SelectDriverMobile_nvc(Condition, ref DriverDataTable);
DriverDataTable.Columns.Add(new DataColumn("Checked_bit", Type.GetType("System.Boolean")));
DriverDataTable.Columns["Checked_bit"].AllowDBNull = true;
DriverDataTable.Columns["Checked_bit"].DefaultValue = false;
this.DriversdataGridView.AutoGenerateColumns = false;
this.DriversdataGridView.DataSource = DriverDataTable;
}
}
private void LoadGrids()
{
HPS.BLL.TrafficBLL.BLLTraffic_TFactory DriverFactory = new HPS.BLL.TrafficBLL.BLLTraffic_TFactory();
DataTable DriverDataTable = new DataTable();
string Conditioin = string.Empty;
DriverFactory.SelectDriverMobile_nvc(Conditioin, ref DriverDataTable);
DriverDataTable.Columns.Add(new DataColumn("Checked_bit", Type.GetType("System.Boolean")));
DriverDataTable.Columns["Checked_bit"].AllowDBNull = true;
DriverDataTable.Columns["Checked_bit"].DefaultValue = false;
this.DriversdataGridView.AutoGenerateColumns = false;
this.DriversdataGridView.DataSource = DriverDataTable;
HPS.BLL.NewsBLL.BLLNews_TFactory NewsFactory = new HPS.BLL.NewsBLL.BLLNews_TFactory();
DataTable NewsDataTable = new DataTable();
NewsFactory.GetAllByCondition(string.Format("[News_T].[StartDate_nvc] <= '{0}' And [News_T].[EndDate_nvc] >= '{0}'", NewsFactory.ServerJalaliDate.ToString()), ref NewsDataTable);
NewsDataTable.Columns.Add(new DataColumn("Checked_bit", Type.GetType("System.Boolean")));
NewsDataTable.Columns["Checked_bit"].AllowDBNull = true;
NewsDataTable.Columns["Checked_bit"].DefaultValue = false;
this.NewsdataGridView.AutoGenerateColumns = false;
this.NewsdataGridView.DataSource = NewsDataTable;
}
