//public ArrayList ListMember(string id) //{ //} //public bool loginAdmin(string username, string password) //{ // Connection con = new Connection(); // SqlConnection sqlcon = new SqlConnection(); // using (sqlcon) // { // sqlcon.Open(); // string com = "select count (*) from Login_Admin where Username = @Username and Password = @Password"; // SqlCommand sqlconn = new SqlCommand(com, sqlcon); // int result = 0; // using (sqlconn) // { // sqlconn.Parameters.AddWithValue("@Username", username); // sqlconn.Parameters.AddWithValue("@Password", password); // result = (int)sqlconn.ExecuteScalar(); // if (result > 0) // return true; // else // return false; // } // } //} public int updateMember(Daftarmember daftar) { Connection con = new Connection(); SqlConnection sqlcon = con.openConnection(); int result = 0; using (sqlcon) { sqlcon.Open(); string conn = "update Member set Member_Name = @Member_Name, Address = @Address, Date_Of_Birth = @Date_of_Birth, Gender = @Gender, Work = @Work, Monthly_Income = @Monthly_Income, Email = @Email, No_HP =@No_HP, Password =@Password where Member_ID = @Member_ID "; SqlCommand com = new SqlCommand(conn, sqlcon); using (com) { com.Parameters.AddWithValue("@Member_ID", daftar.ID); com.Parameters.AddWithValue("@Member_Name", daftar.Nama); com.Parameters.AddWithValue("@Address", daftar.Address); com.Parameters.AddWithValue("@Date_Of_Birth", daftar.DateOfBirth); com.Parameters.AddWithValue("@Gender", daftar.Jk); com.Parameters.AddWithValue("@Work", daftar.Work); com.Parameters.AddWithValue("@Monthly_Income", daftar.Gaji); com.Parameters.AddWithValue("@Email", daftar.Email); com.Parameters.AddWithValue("@No_HP", daftar.NoHP); com.Parameters.AddWithValue("@Password", daftar.Password); result = com.ExecuteNonQuery(); } sqlcon.Close(); } return(result); }
public int insertMember(Daftarmember daftar) { Connection con = new Connection(); SqlConnection sqlcon = con.openConnection(); int result = 0; using (sqlcon) { sqlcon.Open(); string conn = "insert into Member (Member_ID, Member_Name, Date_Of_Birth, Gender, Email, Password) values(@Member_ID, @Member_Name, @Date_Of_Birth, @Gender, @Email, @Password)"; SqlCommand com = new SqlCommand(conn, sqlcon); using (com) { com.Parameters.AddWithValue("@Member_ID", daftar.ID); com.Parameters.AddWithValue("@Member_Name", daftar.Nama); com.Parameters.AddWithValue("@Date_Of_Birth", daftar.DateOfBirth); com.Parameters.AddWithValue("@Gender", daftar.Jk); com.Parameters.AddWithValue("@Email", daftar.Email); com.Parameters.AddWithValue("@Password", daftar.Password); result = com.ExecuteNonQuery(); } sqlcon.Close(); } return(result); }