//To Populate ComboBox cmbYear
public void getYear()
{
DBFunctions s = new SQLFunctions(path);
List<string> year = s.cmbboxYear();
foreach (var y in year)
{
cmbYear.DataSource = year;
cmbYear.DisplayMember = y;
}
}
//To Populate ComboBox cmbMonth
public void getMonth()
{
DBFunctions s = new SQLFunctions(path);
//return month
List<string> month = s.cmbboxMonth();
foreach (var y in month)
{
cmbMonth.DataSource = month;
cmbMonth.DisplayMember = y;
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
bool result=txtValidate(this.txtUsage);
if(result==false)
{
errorProvider1.SetError(txtUsage, "Please enter a valid number");
}
else
{
errorProvider1.Clear();
string mon = cmbMonth.Text;
int year = Convert.ToInt32(cmbYear.Text);
int usage = Convert.ToInt32(txtUsage.Text);
Stopwatch stp = new Stopwatch();
if (rdbSql.Checked == true) //To Execute SQL
{
DBFunctions s = new SQLFunctions(path);
frmUsage f = new frmUsage();
stp.Start();
List<string> name = s.retrieveData(mon, year, usage);
stp.Stop();
GridView(name);
stopwatch2.Text = Convert.ToString(stp.ElapsedMilliseconds)+"ms";
}
else //To Execute LINQ
{
DBFunctions s = new LINQFunctions(conStr);
frmUsage f = new frmUsage();
stp.Start();
List<string> name = s.retrieveData(mon, year, usage);
stp.Stop();
GridView(name);
stopwatch1.Text = Convert.ToString(stp.ElapsedMilliseconds)+"ms";
}
}
}
