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(); }