protected void save(object sender, EventArgs e) { string membebrID = member.Text; string membername = memberName.Text; string date = Dateof.Text; string jeniskelamin = jk.Text; string email = Email.Text; string password = pass.Text; ServiceReference1.WCFShariaClient daftar = new ServiceReference1.WCFShariaClient(); ServiceReference1.Daftarmember objMember = new ServiceReference1.Daftarmember(); objMember.ID = membebrID; objMember.Nama = membername; objMember.DateOfBirth = date; objMember.Jk = jeniskelamin; objMember.Email = email; objMember.Password = password; int daf = daftar.insertMember(objMember); if (daf == 1) { Response.Write("<script>alert('Berhasil');</script>"); Response.Write("<script>window.location='Home.aspx';</script>"); } else { Response.Write("<script>alert('Gagal');</script>"); } }
protected void update(object sender, EventArgs e) { string membebrID = member.Text; string membername = memberName.Text; string alamat = Address.Text; string date = Dateof.Text; string jeniskelamin = Gender.Text; string work = Work.Text; string gajii = gaji.Text; string email = Email.Text; string hpp = Nohp.Text; string password = pass.Text; ServiceReference1.WCFShariaClient daftar = new ServiceReference1.WCFShariaClient(); ServiceReference1.Daftarmember objMember = new ServiceReference1.Daftarmember(); objMember.ID = membebrID; objMember.Nama = membername; objMember.Address = alamat; objMember.DateOfBirth = date; objMember.Jk = jeniskelamin; objMember.Work = work; objMember.Gaji = gajii; objMember.Email = email; objMember.NoHP = hpp; objMember.Password = password; int daf = daftar.updateMember(objMember); if (daf == 1) { Response.Write("<script>alert('Berhasil');</script>"); Response.Write("<script>window.location = 'HomeMember.aspx'</script>"); } else { Response.Write("<script>alert('Gagal');</script>"); } //try //{ // string sql = "UPDATE Member SET Member_ID = @Member_ID ,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"; // SqlConnection conn = new SqlConnection(connStr); // SqlCommand cmd = new SqlCommand(sql, conn); // conn.Open(); // string Member_ID = this.Request["Member_ID"]; // cmd.Parameters.Add("@Member_ID", SqlDbType.VarChar, 10).Value = member.Text; // cmd.Parameters.Add("@Member_Name", SqlDbType.VarChar, 225).Value = memberName.Text; // cmd.Parameters.Add("@Address", SqlDbType.VarChar, 225).Value = Address.Text; // cmd.Parameters.Add("@Date_Of_Birth", SqlDbType.VarChar, 225).Value = Dateof.Text; // cmd.Parameters.Add("@Gender", SqlDbType.VarChar, 9).Value = Gender.SelectedValue; // cmd.Parameters.Add("@Work", SqlDbType.VarChar, 225).Value = Work.Text; // cmd.Parameters.Add("@Monthly_Income", SqlDbType.VarChar, 225).Value = gaji.Text; // cmd.Parameters.Add("@Email", SqlDbType.VarChar, 200).Value = Email.Text; // cmd.Parameters.Add("@No_HP", SqlDbType.VarChar, 20).Value = Nohp.Text; // cmd.Parameters.Add("@Password", SqlDbType.VarChar, 500).Value = pass.Text; // int res = cmd.ExecuteNonQuery(); // conn.Close(); // Response.Write("<script>alert('update sucses');</script>"); // Response.Write("<script>window.location = 'HomeMember.aspx'</script>"); //} //catch (Exception ex) //{ // Response.Write("<script>alert('" + ex.Message + "'); </script>"); //} }