public List <cUkm> GetUKM(string Name) { List <cUkm> ukm = new List <cUkm>(); { con.Open(); SqlCommand cmd = new SqlCommand("select * from UKM where Ukmname like '%'+@Name+'%'", con); cmd.Parameters.AddWithValue("@Name", Name); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { cUkm customerInfo = new cUkm(); customerInfo.Id = dt.Rows[i]["id"].ToString(); customerInfo.Ukmname = dt.Rows[i]["Ukmname"].ToString(); customerInfo.Desc = dt.Rows[i]["Description"].ToString(); customerInfo.Idcoach = dt.Rows[i]["id_coach"].ToString(); ukm.Add(customerInfo); } } con.Close(); } return(ukm); }
public int doInsertUKM(cUkm acc) { con.Open(); SqlCommand cmd = new SqlCommand("insert into UKM(Ukmname, Description, id_coach) values(@ukm, @desc, @idcoach)", con); cmd.Parameters.AddWithValue("@ukm", acc.Ukmname); cmd.Parameters.AddWithValue("@desc", acc.Desc); cmd.Parameters.AddWithValue("@idcoach", acc.Idcoach); int result = cmd.ExecuteNonQuery(); if (result == 1) { con.Close(); return(1); } else { con.Close(); return(0); } }
public int doUpdateUKM(cUkm acc) { con.Open(); SqlCommand cmd = new SqlCommand("update UKM set Ukmname=@name, Description=@desc, id_coach=@coach where id=@id", con); cmd.Parameters.AddWithValue("@name", acc.Ukmname); cmd.Parameters.AddWithValue("@desc", acc.Desc); cmd.Parameters.AddWithValue("@coach", acc.Idcoach); cmd.Parameters.AddWithValue("@id", acc.Id); int result = cmd.ExecuteNonQuery(); if (result == 1) { con.Close(); return(1); } else { con.Close(); return(0); } }