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