void LoadLatestExpenseInput()
{
SqlConnection conn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["dbaseconnection"].ConnectionString);
try
{
SqlCommand command = new SqlCommand("SELECT TOP (1) expensesID FROM tbl_expensesDesc ORDER BY expensesID DESC", conn);
conn.Open();
SqlDataReader dr = command.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
Label1.Visible = false;
lbllatestExpenseId_Hiden.Text = dr[0].ToString();
ClassDataManager inssertData = new ClassDataManager();
inssertData.AddExpensesDescriptions_Users(double.Parse(lbluserID_hiden.Text), double.Parse(lbllatestExpenseId_Hiden.Text));
}
}
}
catch (Exception)
{
}
finally
{
conn.Close();
}
}
void Detect_ExpensesDescription()
{
SqlConnection conn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["dbaseconnection"].ConnectionString);
try
{
SqlCommand command = new SqlCommand("SELECT * FROM tbl_expensesDesc WHERE expensesDescription = '" + txtExpensesDescription.Text + "'", conn);
conn.Open();
SqlDataReader dr = command.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
lbllatestExpenseId_Hiden.Text = dr[0].ToString();
Detect_ExpensesDescription_conflict(double.Parse(lbluserID_hiden.Text), double.Parse(lbllatestExpenseId_Hiden.Text));
if (lblconnect.Text != "Detected")
{
Label1.Visible = false;
ClassDataManager inssertData = new ClassDataManager();
inssertData.AddExpensesDescriptions_Users(double.Parse(lbluserID_hiden.Text), double.Parse(lbllatestExpenseId_Hiden.Text));
}
else
{
Label1.Visible = true;
}
}
}
else
{
ClassDataManager data = new ClassDataManager();
data.AddExpensesDescriptions(txtExpensesDescription.Text);
LoadLatestExpenseInput();
}
}
catch (Exception)
{
}
finally
{
conn.Close();
}
}
