public bool insert(suppliersbll u) { //Create a boolean variable and set its value to false and return it bool issucess = false; //MEthod to connect Database connclass c = new connclass(); SqlConnection conn = new SqlConnection(c.connection); try { //SQL Query to insert Data in DAtabase string query = "Insert into tbl_suppliers(user_name,email,company,adress,phone_no,added_by,added_date)Values(@user_name,@email,@company,@adress,@phone_no,@added_by,@added_date)"; //For Executing Command SqlCommand cmd = new SqlCommand(query, conn); //Passing Values to the Variables cmd.Parameters.AddWithValue("@user_name", u.user_name); cmd.Parameters.AddWithValue("@email", u.email); cmd.Parameters.AddWithValue("@company", u.company); cmd.Parameters.AddWithValue("@adress", u.adress); cmd.Parameters.AddWithValue("@phone_no", u.phone_no); cmd.Parameters.AddWithValue("@added_by", u.added_by); cmd.Parameters.AddWithValue("@added_date", u.added_date); //Database Connection Open conn.Open(); //To execute non query int row = cmd.ExecuteNonQuery(); //If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0 if (row > 0) { //Query Sucessfull issucess = true; } else { //Query Failed issucess = false; } } catch (Exception ex) { //Throw Message if any error occurs MessageBox.Show(ex.Message); } finally { //Closing Connection conn.Close(); } return(issucess); }
public bool exist(suppliersbll u) { //Create a boolean variable and set its value to false and return it bool issuccess = false; //MEthod to connect Database connclass c = new connclass(); SqlConnection conn = new SqlConnection(c.connection); try { //SQL Query to selecte Data from DAtabase string query = "select * from tbl_suppliers where email=@email AND phone_no=@phone_no"; //For Executing Command SqlCommand cmd = new SqlCommand(query, conn); //Passing Values to the Variables cmd.Parameters.AddWithValue("@email", u.email); cmd.Parameters.AddWithValue("@phone_no", u.phone_no); //Getting DAta from dAtabase SqlDataAdapter adapter = new SqlDataAdapter(cmd); //TO hold the data from database DataTable dt = new DataTable(); //Database Connection Open conn.Open(); //Fill Data in our DataTable adapter.Fill(dt); //Checking The rows in DataTable if (dt.Rows.Count > 0) { //Data Exist issuccess = true; } else { //Data not exist issuccess = false; } } catch (Exception ex) { //Throw Message if any error occurs MessageBox.Show(ex.Message); } finally { //Closing Connection conn.Close(); } return(issuccess); }
public bool delete(suppliersbll u) { //Create a boolean variable and set its value to false and return it bool issucess = false; //MEthod to connect Database connclass c = new connclass(); SqlConnection conn = new SqlConnection(c.connection); try { //SQL Query to delete Data in DAtabase string query = "DELETE FROM tbl_suppliers WHERE id=@id"; //For Executing Command SqlCommand cmd = new SqlCommand(query, conn); //Passing Values to the Variables cmd.Parameters.AddWithValue("@id", u.id); //Database Connection Open conn.Open(); //To execute non query int row = cmd.ExecuteNonQuery(); //If the query is executed Successfully then the value to rows will be greater than 0 else it will be less than 0 if (row > 0) { //Query Sucessfull issucess = true; } else { //Query Failed issucess = false; } } catch (Exception ex) { //Throw Message if any error occurs MessageBox.Show(ex.Message); } finally { //Closing Connection conn.Close(); } return(issucess); }