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>");
//}
}