public DataTable select() { ConnClass cDL = new ConnClass(); SqlConnection connDL = new SqlConnection(cDL.Datalogconnection); DataTable dtDL = new DataTable(); try { string query = "SELECT* FROM Logs"; SqlCommand cmdDL = new SqlCommand(query, connDL); SqlDataAdapter adapter = new SqlDataAdapter(cmdDL); connDL.Open(); adapter.Fill(dtDL); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error While Loading!", MessageBoxButtons.OK, MessageBoxIcon.Warning); //MetroMessageBox.Show(ex.Message, Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Warning); } finally { connDL.Close(); } return(dtDL); }
public bool Check(UserBLL u) { bool isunique = false; ConnClass c = new ConnClass(); SqlConnection conn = new SqlConnection(c.Appconnection); try { string query = "Select * From tbl_user where email='" + u.username + "' OR username='******'"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd); conn.Open(); dataAdapter.Fill(dataSet); int i = dataSet.Tables[0].Rows.Count; if (i > 0) { isunique = true; } else { isunique = false; } } catch (Exception) { isunique = false; return(isunique); } finally { conn.Close(); } return(isunique); }
public bool delete(UserBLL u) { bool issucess = false; ConnClass c = new ConnClass(); SqlConnection conn = new SqlConnection(c.Appconnection); try { string query = "DELETE FROM tbl_user WHERE id=@id"; SqlCommand cmd = new SqlCommand(query, conn); cmd.Parameters.AddWithValue("@id", u.id); conn.Open(); int row = cmd.ExecuteNonQuery(); if (row > 0) { issucess = true; } else { issucess = false; } } catch (Exception) { issucess = false; return(issucess); } finally { conn.Close(); } return(issucess); }
public bool update(UserBLL u) { bool issucess = false; ConnClass c = new ConnClass(); SqlConnection conn = new SqlConnection(c.Appconnection); try { string query = "UPDATE tbl_user set email=@email,username=@username,password=@password WHERE id=@id"; SqlCommand cmd = new SqlCommand(query, conn); cmd.Parameters.AddWithValue("@email", u.email); cmd.Parameters.AddWithValue("@username", u.username); cmd.Parameters.AddWithValue("@password", u.password); cmd.Parameters.AddWithValue("@id", u.id); conn.Open(); int row = cmd.ExecuteNonQuery(); if (row > 0) { issucess = true; } else { issucess = false; } } catch (Exception) { issucess = false; return(issucess); } finally { conn.Close(); } return(issucess); }
public DataTable Search(string keyword) { ConnClass c = new ConnClass(); SqlConnection conn = new SqlConnection(c.Datalogconnection); DataTable dt = new DataTable(); try { string query = "SELECT* FROM Logs WHERE id Like '%" + keyword + "%' OR Level like '%" + keyword + "%' OR Type like '%" + keyword + "%'"; SqlCommand cmd = new SqlCommand(query, conn); SqlDataAdapter adapter = new SqlDataAdapter(cmd); conn.Open(); adapter.Fill(dt); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(dt); }
public bool login(LoginBLL u) { bool issuccess = false; ConnClass c = new ConnClass(); SqlConnection conn = new SqlConnection(c.Appconnection); try { string query = "select * from tbl_user where username=@username AND password=@password"; SqlCommand cmd = new SqlCommand(query, conn); cmd.Parameters.AddWithValue("@username", u.username); cmd.Parameters.AddWithValue("@password", u.password); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); conn.Open(); adapter.Fill(dt); if (dt.Rows.Count > 0) { issuccess = true; } else { issuccess = false; } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conn.Close(); } return(issuccess); }