private void NNbtn_Click(object sender, EventArgs e)
{
// Initial Value
Thanks = 0;
O10 = 0;
Cell = 0;
Archi = 0;
Mission = 0;
Rice = 0;
Help = 0;
Car = 0;
Term = 0;
// Set Name
name.Text = NN.Text;
DataSet temp;
if ((temp = SQLite.ExecuteSelectQuery(string.Format("select sum(amount) as sum from Offering_Thanks where name = '{0}' AND strftime('%Y', date) = '{1}'", NN.Text, date.Year))).Tables[0].Rows[0]["sum"] != DBNull.Value)
{
Thanks = Convert.ToInt32(temp.Tables[0].Rows[0]["sum"]);
}
if ((temp = SQLite.ExecuteSelectQuery(string.Format("select sum(amount) as sum from Offering_10 where name = '{0}' AND strftime('%Y', date) = '{1}'", NN.Text, date.Year))).Tables[0].Rows[0]["sum"] != DBNull.Value)
{
O10 = Convert.ToInt32(temp.Tables[0].Rows[0]["sum"]);
}
if ((temp = SQLite.ExecuteSelectQuery(string.Format("select sum(amount) as sum from Offering_Cell where name = '{0}' AND strftime('%Y', date) = '{1}'", NN.Text, date.Year))).Tables[0].Rows[0]["sum"] != DBNull.Value)
{
Cell = Convert.ToInt32(temp.Tables[0].Rows[0]["sum"]);
}
if ((temp = SQLite.ExecuteSelectQuery(string.Format("select sum(amount) as sum from Offering_Archi where name = '{0}' AND strftime('%Y', date) = '{1}'", NN.Text, date.Year))).Tables[0].Rows[0]["sum"] != DBNull.Value)
{
Archi = Convert.ToInt32(temp.Tables[0].Rows[0]["sum"]);
}
if ((temp = SQLite.ExecuteSelectQuery(string.Format("select sum(amount) as sum from Offering_Mission where name = '{0}' AND strftime('%Y', date) = '{1}'", NN.Text, date.Year))).Tables[0].Rows[0]["sum"] != DBNull.Value)
{
Mission = Convert.ToInt32(temp.Tables[0].Rows[0]["sum"]);
}
if ((temp = SQLite.ExecuteSelectQuery(string.Format("select sum(amount) as sum from Offering_Rice where name = '{0}' AND strftime('%Y', date) = '{1}'", NN.Text, date.Year))).Tables[0].Rows[0]["sum"] != DBNull.Value)
{
Rice = Convert.ToInt32(temp.Tables[0].Rows[0]["sum"]);
}
if ((temp = SQLite.ExecuteSelectQuery(string.Format("select sum(amount) as sum from Offering_Help where name = '{0}' AND strftime('%Y', date) = '{1}'", NN.Text, date.Year))).Tables[0].Rows[0]["sum"] != DBNull.Value)
{
Help = Convert.ToInt32(temp.Tables[0].Rows[0]["sum"]);
}
if ((temp = SQLite.ExecuteSelectQuery(string.Format("select sum(amount) as sum from Offering_Car where name = '{0}' AND strftime('%Y', date) = '{1}'", NN.Text, date.Year))).Tables[0].Rows[0]["sum"] != DBNull.Value)
{
Car = Convert.ToInt32(temp.Tables[0].Rows[0]["sum"]);
}
if ((temp = SQLite.ExecuteSelectQuery(string.Format("select sum(amount) as sum from Offering_Term where name = '{0}' AND strftime('%Y', date) = '{1}'", NN.Text, date.Year))).Tables[0].Rows[0]["sum"] != DBNull.Value)
{
Term = Convert.ToInt32(temp.Tables[0].Rows[0]["sum"]);
}
sum = Thanks + O10 + Cell + Archi + Mission + Rice + Help + Car + Term;
inputData();
setText();
}
