void Detect_ExpensesDescription_conflict_expenses()
{
SqlConnection conn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["dbaseconnection"].ConnectionString);
try
{
SqlCommand commandz = new SqlCommand("SELECT RegisteredUsers.registereduserID, tbl_expensesDesc.expensesdescription FROM RegisteredUsers INNER JOIN tbl_expenses_users ON RegisteredUsers.registereduserID = tbl_expenses_users.registereduserID INNER JOIN tbl_expensesDesc ON tbl_expenses_users.expensesID = tbl_expensesDesc.expensesID WHERE RegisteredUsers.registereduserID ='" + double.Parse(lbluserID_hiden.Text) + "' AND tbl_expensesDesc.expensesdescription = '" + txtExpensesDescription.Text + "'", conn);
conn.Open();
SqlDataReader drz = commandz.ExecuteReader();
if (drz.HasRows)
{
while (drz.Read())
{
Label1.Visible = true;
Linksave.Visible = false;
}
}
else
{
Label1.Visible = false;
ClassDataManager data = new ClassDataManager();
data.AddExpensesDescriptions(txtExpensesDescription.Text);
LoadLatestExpenseInput();
Linksave.Visible = true;
}
}
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();
}
}
