public int doInsertDaftarUKM(StudentUKM acc) { con.Open(); SqlCommand cmd = new SqlCommand("insert into StudentUKM(id_account, id_ukm, Status) values(@account, @ukm, @status)", con); cmd.Parameters.AddWithValue("@account", acc.IdAccount); cmd.Parameters.AddWithValue("@ukm", acc.Ukmid); cmd.Parameters.AddWithValue("@status", "Pending"); int result = cmd.ExecuteNonQuery(); if (result == 1) { con.Close(); return(1); } else { con.Close(); return(0); } }
public int doInsertCaptainAdmin(Account acc, StudentUKM ukm) { con.Open(); int hasil = 0; SqlCommand cmd = new SqlCommand("insert into Account(Nim, Name, Gender, Address, Phonenumber, Faculty, Major, Batch, Username, Password, Status) values(@nim, @name, @gender, @address, @phonenumber, @faculty, @major, @batch, @username, @password, @status)", con); cmd.Parameters.AddWithValue("@nim", acc.Nim); cmd.Parameters.AddWithValue("@name", acc.Name); cmd.Parameters.AddWithValue("@gender", acc.Gender); cmd.Parameters.AddWithValue("@address", acc.Address); cmd.Parameters.AddWithValue("@phonenumber", acc.PhoneNumber); cmd.Parameters.AddWithValue("@faculty", acc.Faculty); cmd.Parameters.AddWithValue("@major", acc.Major); cmd.Parameters.AddWithValue("@batch", acc.Batch); cmd.Parameters.AddWithValue("@username", acc.Username); cmd.Parameters.AddWithValue("@password", acc.Password); cmd.Parameters.AddWithValue("@status", "Captain"); int result = cmd.ExecuteNonQuery(); if (result == 1) { SqlCommand cmd2 = new SqlCommand("insert into StudentUKM(id_ukm, Status) values(@idukm, @status)", con); cmd2.Parameters.AddWithValue("@idukm", ukm.Ukmid); cmd2.Parameters.AddWithValue("@status", "Active"); int result2 = cmd2.ExecuteNonQuery(); if (result2 == 1) { SqlCommand cmd3 = new SqlCommand("select top 1 * from Account order by id desc", con); SqlDataAdapter da3 = new SqlDataAdapter(cmd3); DataTable dt3 = new DataTable(); da3.Fill(dt3); if (dt3.Rows.Count > 0) { for (int i = 0; i < dt3.Rows.Count; i++) { id = dt3.Rows[i]["id"].ToString(); } SqlCommand cmd4 = new SqlCommand("select top 1 * from StudentUKM order by id desc", con); SqlDataAdapter da4 = new SqlDataAdapter(cmd4); DataTable dt4 = new DataTable(); da4.Fill(dt4); if (dt4.Rows.Count > 0) { for (int i = 0; i < dt4.Rows.Count; i++) { idstudenukm = dt4.Rows[i]["id"].ToString(); } SqlCommand cmd5 = new SqlCommand("update StudentUKM set id_account = @id where id = @idd", con); cmd5.Parameters.AddWithValue("@id", id); cmd5.Parameters.AddWithValue("@idd", idstudenukm); int result5 = cmd5.ExecuteNonQuery(); if (result5 > 0) { con.Close(); hasil = 1; } else { con.Close(); hasil = 0; } } else { hasil = 0; } } } else { hasil = 0; } } else { hasil = 0; } return(hasil); }