private void Form1_Load(object sender, EventArgs e)
{
//fetching connection string from ConstantData class
using (connection = new SqlConnection(ConstantData.getConnectionString()))
using (adapter = new SqlDataAdapter("select consumer_name from Consumer", connection))
{
//connection.Open();
DataTable consumer_col = new DataTable();
adapter.Fill(consumer_col);
//Inserting extra row in DataTable
DataRow row = consumer_col.NewRow();
row["consumer_name"] = "Select Consumer";
consumer_col.Rows.InsertAt(row, 0);
consumerList.DisplayMember = "consumer_name";
consumerList.DataSource = consumer_col;
}
}
private void getConsumerDetails(object sender, EventArgs e)
{
clearForm();
string name = consumerList.Text;
addrText.Text = "";
waterText.Text = "";
quotaText.Text = "";
using (connection = new SqlConnection(ConstantData.getConnectionString()))
{
DataTable consumerDetail = new DataTable();
connection.Open();
SqlDataReader myReader = null;
SqlCommand myCommand = new SqlCommand("select * from Consumer where consumer_name = '" + name + "'", connection);
myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
addrText.Text = (myReader["Address"].ToString());
waterText.Text = (myReader["water_source"].ToString());
quotaText.Text = (myReader["sanction_quota"].ToString());
//storing data for further referance
ConstantData.customerName = name;
ConstantData.customerAddress = myReader["Address"].ToString();
ConstantData.waterResource = myReader["water_source"].ToString();
ConstantData.sanctionQuota = double.Parse(myReader["sanction_quota"].ToString());
//take contact details from db if required
}
else
{
//MessageBox.Show("No Record Found.");
}
}
}
private void addDetailstoList(object sender, EventArgs e)
{
string contract = contractType.Text;
double kharip_rate = 0;
double rabbi_rate = 0;
double hot_rate = 0;
using (connection = new SqlConnection(ConstantData.getConnectionString()))
{
DataTable consumerDetail = new DataTable();
connection.Open();
SqlDataReader myReader = null;
SqlCommand myCommand = new SqlCommand("select * from Contract where contract_type = '" + contract + "'", connection);
//MessageBox.Show(contract);
myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
if (!checkMeterInstalled.Checked)
{
if (int.Parse(meter1.Text) > int.Parse(meter2.Text))
{
MessageBox.Show("Please enter correct details");
}
}
//addrText.Text = (myReader["Address"].ToString());
kharip_rate = float.Parse((myReader["kharip_rate"]).ToString(), System.Globalization.CultureInfo.InvariantCulture.NumberFormat);
rabbi_rate = float.Parse((myReader["rabbi_rate"]).ToString(), System.Globalization.CultureInfo.InvariantCulture.NumberFormat);
hot_rate = float.Parse((myReader["hot_season_rate"]).ToString(), System.Globalization.CultureInfo.InvariantCulture.NumberFormat);
//Adding record in bill table
ConstantData.contractType = contract;
updateBill(kharip_rate, rabbi_rate, hot_rate);
}
else
{
MessageBox.Show("Unable to fetch contract details");
}
}
}